?
Solved

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

Posted on 2010-09-01
5
Medium Priority
?
497 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 1400 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 600 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Time Corrections for Reports Working with a report, we made some interesting discoveries about the time corrections/updates We are using the following Parameters: Starting Entered Date (Date) formatted as Data type: "Date/Time" Ending Entered …
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Suggested Courses

850 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