Auto Formatting Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report based on a crosstab. The crosstab will return a varying
number of columns depending on the user-defined criteria. I want the report
to print all of, and only, the columns generated through the crosstab.

The column display data from individual stores, so depending on which stores
are selected by user input, the crosstab/report may have 1-10 columns.

This causes an error when I run the report because it cannot find a defined
fieldname.

Any quidance would be appreciated...
 
Thanks for taking time to respond. This is example is close but not quite the
answer to the situation I'm facing. I have 58 stores and want to layout sales
data in a "trend" format with each store being a column. When I run the
report, I may want stores 1,2,3,4 and 5 one-time(ex#1), but the next time I
run it, I may want stores 34, 35 and 36(ex#2).

So, 1 is not always going to be the first column and it might be a 3 column
report one-time and 6 column report the next.

ex#1
store1 store2 store3 store4
store5
Sales 100 50 250 125
310
Cost 65 38 185 98
201


ex#2
store33 store34 store35
Sales 300 450 210
Cost 215 345 141

If I understand your example, it would print "blank" columns for stores 1
thru 32 in ex#2. It is rare that I would generate the report for all 58
stores. Normally, we would filter it by our "districts" which comprise 5-8
store groups.

Ultimately, I could just create multiple reports forour most common
reporting parameters, but I wanted a single db that would/could produce any
sequential series of stores in a report.
 
I still the the Crosstab.MDB has a solution that only creates columns where
needed.
 
Back
Top