Solved

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

Posted on 2010-09-01
5
491 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
exporting a ssrs report to word 2 50
Tracking a Database Lock - SQL 2014 10 49
SSRS Dynamic Column Names - Last 8 Weeks 3 37
SSRS 2013 - Creating a summarized report 19 35
Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

773 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