Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Reporting Services: Can I Add Columns at Runtime?

Posted on 2004-08-04
3
Medium Priority
?
301 Views
Last Modified: 2008-01-09
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
0
Comment
Question by:ppastor
  • 2
3 Comments
 
LVL 12

Accepted Solution

by:
kselvia earned 2000 total points
ID: 11723235
You can return

UPC#, UPC description, Store #1
UPC#, UPC description, Store #2
...

and add list with a matrix on the stores column.  Sorry I can't explain exactly how off the top of my head, but look at the adventureworks sample for an example. (It should be in the samples folder)

0
 

Author Comment

by:ppastor
ID: 11725539
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?
0
 
LVL 12

Expert Comment

by:kselvia
ID: 11737353
Sorry I did not answer your last question. I don't have access to SRS this week so I could not do any tests.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question