Improve company productivity with a Business Account.Sign Up

x
?
Solved

Dynamic Report

Posted on 2011-09-11
5
Medium Priority
?
459 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

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.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
In this article, we will see two different methods to recover deleted data. The first option will be using the transaction log to identify the operation and restore it in a specified section of the transaction log. The second option is simpler and c…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

585 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