.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Generating Reports using SQL Reporting depending on dynamic column

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

Hi All,

I have a task where i need to create dynamic report using SQL Server 2005 Reporting Server.

Client will be given a page where there are drop down will be provided from which he can select columns and in 2nd drop down can select where conditions and on button click will generate report using sql reporting server.

Pls advise architecture how can i proceed with this project

-- Kind Regards Sandeep

View Complete Post

More Related Resource Links

Reporting Subscription - dynamic To depending on dynamic input parameter



SSRS : 2005

Deployed: A Simple RDL with a single input parameter(for simplicity say the parameter is City).

The requirement is to send the report to Mayor of each city.  I already have a table with following info.





> Report should run at a static schedule and send reports to each mayor with their City. Currently using regular subscriptions.. which means 50 subscriptions for fifty different cities.

Every time a new city comes, automatic subscription to the Mayor Email ID. Email should not be sent if the there is no data for the city on that particular day.



Need an auto generating number for a document depending on a list column



I have an infopath form in my document library and I have list with columns Service ID and Service Name.

Base on the service id i need to generate another request id for the form starting from 0 for each service id as follows.

service 1---Id-1)Request form          

            ----Id-2)Request form  


service 2---Id-1)Request form

            ----Id-2)Request form  

Any little help would be much appreciated.



displaying dynamic added value in reports



I my application i have generated dynamic rows that contains some textbox values, i need to take those values and display in

reports. I am storing that dynamically added values in another table. please help me.

dynamically change column names in Crystal reports


I need to develop 3 pages.

On the first page user defines atmost 7 column names to be displayed on the report. I'm saving these names in a Sql DB table 'Columns' with Column_Nm and Column_ID as Table columns.

On the second page I'm retrieving column_Nm from the table and displaying them on the page so that the user enters the data. This data is saved in another table 'Summary' with the Columns column1 through column7.

on the 3rd page I need to show a report of 'Summary' table.

How do I dynamically replace column1 through column7 names with that of 'Column_Nm' on the report?

Any help/suggestions would be appreciated.


Data Points: Designing Reports with SQL Server Reporting Services 2005


Many applications require some degree of integration with a reporting tool. A good solution, SQL ServerT Reporting Services 2005, provides Web-based reports and can be integrated into both Windows® Forms and Web-based applications.

John Papa

MSDN Magazine June 2006

Reporting Services: Deliver SQL Server Reports To SharePoint To Enhance Team Collaboration


The solution covered here includes a custom SharePoint Web service that accepts SQL Server-generated report files and, through the WSS object model, stores the file in the appropriate library for enhanced collaboration possibilities.

Ed Hild

MSDN Magazine March 2006

Reporting: Deliver User-Friendly Reports from Your Application with SQL Server Reporting Services


SQL Server 2000 Reporting Services--a server-based reporting platform built on the .NET Framework and integrated with SQL Server 2000--lets you easily add reporting from diverse data sources. Using Visual Studio and Reporting Services you can integrate reports from any data source that has an OLE DB, ODBC, or ADO.NET provider into your Web applications. This article explains how it's done.

John C. Hancock

MSDN Magazine August 2004

Coloring sql reporting services report depending on the change of value of a certain field

Hey guys, I have an SSRS report that looks something like this: Column1 Column2 Row1 2 A Row2 2 B Row3 2 C Row4 6 A Row5 11 E How can I color the rows with the same value in Column1 with the same color? for example Row1 to Row3 would have one color, Row4 would have a different color, then I'd go back to Row1's color for Row5? note: I don't know in advance the numbers returned in Column1. I query for them and then I hide them from the user so Column1 shouldn't show on the report, but I want to use it for the coloring only.

Dynamically change column names in Crystal reports - ASP.Net

Hi I am developing an application in ASP.net 3.0 and MY SQL database . I want to display column names & values in crystal report as user selects in ASP.net application  and column names and corresponding values will be changed dynamically. Any help/suggestions and sample code would be appreciated. Thanks in advance....  

Generating Reports

Can anyone guide to, the smart way to generate reports (like crystal reports) in wss3.0   Thanks

Generating Multiple Excel Sheet using Reporting Services 2005.

<p> Hi, I'm currently developing a program using ASP.NET 2.0 (C#) and i am using Reporting Services 2005. One of the report requirements is to export a data to an excel with multiple excel sheet. Is there other way to generate multiple excel sheet using the reporting services? if yes, i would like to ask a sample code... Thanks in advance, JP  </p> 

Reports are not showing on management studio for SQL 2008 reporting services

I just did the side by side upgrade for reproting server from 2005 to 2008 and everything was fine. But when I login to the reporting server from management studio I am not able to see the report server folders like we do in SQL 2005. The only think i saw is jobs, security and shared schedules. I dont even see any jobs under this jobs folder. Do i need to do anything after the upgrade to be able to see the reports, subscriptions and data sources from the management studio? please let me know. Thanks!  kp

Custom webpart displaying Reports from Reporting service

Hi          I created a report in VS 2008 and deployed to reporting service. Then when I access this report through a custom webpart some of the cell borders are getting disappeared from inside the table control. Even the cell is not getting misaligned within the cell. But the same report when I retrieve through ReportViewer builtin webpart. Its displaying without any issues. How do I fix such issues?

Dynamic Column in Excel Source

Hi,I am having Excel Source Which needs to be imported into Sql Server Table using SSIS.In the Excel Source I dont have Month and Year Column.But in Table I have Month and year column and both the columns are Primary Key columns.So i am not able to Import data from Excel to Table.So is there any possiblities to add Columns Dynamically in Excel source inorder to  get the Year and Month

Dynamic rows(fields) generation in crystal reports

Hi.....frnds,     I am working on Crystal reports.My requirement is that i need to  generate dynamic fields according to the count of Family_Members column in sql server database,for example if i have '4' in 'Family_Members' column i need to generate 4(Family members details)dynamically.

Using Sub reports and dynamic crystal report generation

Hi..........friends,         I am working on crystal reports to generate Ration card details.My form  consists of the fields like Address details of the ration card owner,existing ration card details and family members details.in these Family Details i have to generate dynamically according to the count of the family members.I am new to crystal reports.I am confusingabout whether i have to use sub reports or formula fields.................               Plz help me                                                                    Thanks in advance      

Reporting Services Reports Migration

Hi , Apart from the RSScripter is there any plans from microsoft to release a tool in the future which can be used to deploy reports/security etc from one report to another. This will be very useful for administration purposes. I believe BO also has a similar tool probably named as Life cycle manager.   Regards, Vikram
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend