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.