I need to build an ad hoc query/report, knowing no more than the possible columns that may be chosen. If the user chooses to show a column, I must be able to put the header and data on the report, and add some sort of offset before writing out the next column.
I must build the queries and underlying tables on the fly, then present the user with a choice of fields to display (giving her the option to modify the report title and column headers). The user wants to be able to specify grouping and sorting, which I will need to specify in code, also.
Does anyone have any pointers on how to build this report, assuming that I'll figure out how to build the SQL and the temp data table to pull from? Thanks!
LynnC
[sig][/sig]
I must build the queries and underlying tables on the fly, then present the user with a choice of fields to display (giving her the option to modify the report title and column headers). The user wants to be able to specify grouping and sorting, which I will need to specify in code, also.
Does anyone have any pointers on how to build this report, assuming that I'll figure out how to build the SQL and the temp data table to pull from? Thanks!
LynnC
[sig][/sig]