you can't. CR doesn't like a dynamic schema...ok you could probably build the entire report in code, but that seems like too much work to me, and maintenance would be an utter nightmare.
Instead of dynamic column names, put all the names to a standard, say col1, col2, col3...
then create a table of what the verbiage you want displayed is and display that instead. The table doesn't have to be linked to any other, and CR will only read the first line of the table...but that is enough. I use this table to pass back the parameters for my reports. You could also embed this table in your main return.
Is there a max # of columns? If so, create that many columns in your output, whether or not they are populated and then dynamically suppress the columns if their title is null or blank (use it as a flag).
If there is truly limit to the number of columns, perhaps a crosstabs style report is a better option as it is dynamic in the number and name of the columns
IP Logged
