I'm using Crystal Reports 9 with a SQL Server database. I'm attempting to create a report from a query that returns a dynamic set of columns based on a users input. The report displays the number of products sold to date for a user-specified date range (by month). For example, my if a user selects Products A, B, and C and then selects the date range from Jan 2004 to July 2004, the report will contain the following column headings:
I'm creating the final output table using temp tables and actually adding columns (through the ALTER command) dynamically based on the date range specified.
Is there any way in Crystal to display this data dynamically so that the column headers are determined by what is exactly returned in the query?
I'm new to Crystal so please be detailed in your suggested solutions.