I have a query:
Select * from TableNm
The first two columns returned by the query will always be the same. However, the remaining column names and column numbers will vary everytime I run the query from tableNm table as the table structure is going to be modified every week by dropping and recreating the table.
I want to display the results of the query in a reporting services .rdl file. How can I dynamically modify/refresh the header names of the same layout in the .rdl file every time I generate the report by running the select query above. Can someone please guide me with a solution?