Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Dynamic Report

Posted on 2011-09-11
5
Medium Priority
?
457 Views
Last Modified: 2012-05-12
Hello Experts,
I need to create Dynamic report,I mean I can use one report  for different tables and fields,
I need to select colums in aspx page then pass the database and function  to sql report .
How can I change field name in the report ?
0
Comment
Question by:samprg
  • 3
  • 2
5 Comments
 
LVL 25

Expert Comment

by:TempDBA
ID: 36524517
As far as I know, this is not possible with SSRS.
But still this looks achievable. Create a report that gives all the fields that is possible, with NULL values for the fields where data is not retrieved for a particular report type, and while showing in the frontend, hide the columns where datavalue is NULL.
0
 

Author Comment

by:samprg
ID: 36525061
Please Can you give more detail
0
 

Author Comment

by:samprg
ID: 36525075
Do you have any example ?
0
 
LVL 25

Accepted Solution

by:
TempDBA earned 2000 total points
ID: 36527527
What I wanted to say is create a common procedure that retrives data from all other procedures and finally creates a temporary table with all the possible columns. Then select data from this table. This is because while creating a rdl, you need to finalize on the datafields which can't be produced dynamically. So, this is the way I was suggesting. This is troublesome but to create a master procedure for all as you wish, you have to do in this way only I guess.

Suppose you have three procedures which gives different results. So, now instead of creating three different reports, Create a master procedure and call all the three procedure inside, and built a temporary table with all the possible columns and fetch data from that. For the fileds which are not resutled from the procedure, by default keep the value to be NULL. Now built a rdl which will have dataset getting datafiled for all the possible ones. When you are showing your data, just hide the columns with no data. I did this for one of my report where we had  100 columns to display but everywhere data presence was not sured and the presence of data was based on some criteria. so, generally the column respect to the criteria just yields 10-12 columns with good data.

This is again an overhead for the server as you will be running the procedures unnecessarily . But based on your requirement you can even skip that.
0
 

Author Closing Comment

by:samprg
ID: 36530830
Awesome
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
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, …

886 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