Solved

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

Posted on 2010-09-01
5
489 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSRS - Select nth row of dataset 4 123
SSRS Questions regarding Parameters (EXPERTS HELP!) 4 60
Ssrs disable the home lonk 1 69
SSRS set Parameter value 2 48
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 …
This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.

919 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now