Create CrossTable Query report

[ysrini]

Hi,i have a crosstable query that can return any number of columns at runtime depending on data.
How can i create report ontop of this query when i don't know ahead the number of columns that will be populated?



The maximum number of columns will be 10
The crosstable query can return ColA, ColB one time and ColB,ColC,ColE next time.
How to design report for this?

Thanks
-srinivas

[llkhoutx]

Union or append your data with a recordset that has a zero value for each column. All columns will then always appear in you crosstab.