ppastor
asked on
Reporting Services: Can I Add Columns at Runtime?
Hi,
A Reporting Services newbie here...Can I add columns to a report at runtime? I have some .NET datagrids that I add template columns to at runtime based on a datacolumn naming convention. I would like to do something similar in Reporting Services. Is this possible?
For example, I have this large query that returns data like:
UPC# - UPC Description - Store #1 - Store #2 - etc...
...so I would like my report to have the "UPC#" and "UPC Description" as static columns, and then the ability to add a column to the report for each "Store".
If this is possible, and you can provide a snippet of how to do this, it would be greatly appreciated. If the answer is no this is not possible, then the reward is not so great :)
Thanks in advance,
Phil
A Reporting Services newbie here...Can I add columns to a report at runtime? I have some .NET datagrids that I add template columns to at runtime based on a datacolumn naming convention. I would like to do something similar in Reporting Services. Is this possible?
For example, I have this large query that returns data like:
UPC# - UPC Description - Store #1 - Store #2 - etc...
...so I would like my report to have the "UPC#" and "UPC Description" as static columns, and then the ability to add a column to the report for each "Store".
If this is possible, and you can provide a snippet of how to do this, it would be greatly appreciated. If the answer is no this is not possible, then the reward is not so great :)
Thanks in advance,
Phil
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sorry I did not answer your last question. I don't have access to SRS this week so I could not do any tests.
ASKER