Solved

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

Posted on 2010-09-01
5
493 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server 2014 - Report Server - Stored Procs 8 62
SQL 2012 R2 Express report problem 2 97
SSRS  - Dropdown with Null 3 33
SSRS 2008 Jump To Report 4 26
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 …
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

749 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