I have created a crosstab query where as the results can change each time based on user selection. My issue is segment names as the column heading can change based on the parameters so I need to create them dynamically. The report would be pulled based on a segment and a date range which could produce anywhere from 1 store to 60 stores and reflects sales. Any Ideas would be great.
Example Results:
Period StoreName1 StoreName2 StoreName3 Storename4 .... StoreName60
Jan-13 $500.00 $1,200.00 $5,000.00 $10,000.00 $120,000.00
Example Results:
Period StoreName1 StoreName2 StoreName3 Storename4 .... StoreName60
Jan-13 $500.00 $1,200.00 $5,000.00 $10,000.00 $120,000.00