Solved

SSRS - dynamically build columns off a "Select *"?

Posted on 2010-09-01
5
492 Views
Last Modified: 2012-05-10
Hello all,

Is there a way in SSRS to build a report that acts as a datadump but the thing is I have three columns I know will be there that I need to use as parameter selection dropdowns, the rest of the columns could increase over time and I don't want to manually have to open the SSRS report to add the column headers etc.

Any idea?
0
Comment
Question by:sbornstein2
  • 2
  • 2
5 Comments
 
LVL 12

Accepted Solution

by:
mcv22 earned 350 total points
ID: 33580016
0
 

Author Comment

by:sbornstein2
ID: 33580215
It seems that solution works but only within the application it seems.  I need to create just the RDL report to publish out to a server with the stored proc as the dataset.  The stored proc having a Select * and I need to parameter three columns I know exist.
0
 
LVL 12

Expert Comment

by:mcv22
ID: 33580329
The idea behind defining the columns beforehand is so the data types are handled appropriately. I usually work-around these by having the stored procedure send out the e-mail (generating HTML on the fly) and skip SSRS altogether.
0
 
LVL 16

Assisted Solution

by:Auric1983
Auric1983 earned 150 total points
ID: 33585578
If you can represent the dataset in a pivot table or matrix then yes you could do something.  

A good example of this would be a budget file comparing actuals against but for each period.  You would have the Account code, name, etc. then fo each period you would have a repeating set of actual & budget?
0
 

Author Closing Comment

by:sbornstein2
ID: 33636859
thanks all
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

860 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