Link to home
Start Free TrialLog in
Avatar of ppastor
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
ASKER CERTIFIED SOLUTION
Avatar of Ken Selvia
Ken Selvia
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ppastor
ppastor

ASKER

Thanks, that IS pretty close, but how do I add a Column Header like "UPC Number" above the UPC# field? Also, I have a field which is the SUM of all Store values for each UPC. Any way to get that at the end of the row, instead of before the store columns?
Sorry I did not answer your last question. I don't have access to SRS this week so I could not do any tests.