Click here to Skip to main content
15,941,690 members
Articles / Programming Languages / ASP

Displaying Dynamic Columns in SSRS Report From ASP Page

Rate me:
Please Sign up or sign in to vote.
4.88/5 (6 votes)
28 Aug 2014CPOL2 min read 30.2K   9   6
How to display dynamic columns in SSRS report from ASP page


A report contains N number of fields. Some users want to see only 3 fields, some users 2 fields, and others may want to see 20 fields. Our idea is display selected columns dynamically in SSRS reports. We can control the Columns from ASP web page.


For basic report creation, please refer to other articles. There are many here on The Code Project.

Using the Code

Step 1

Create a report with required dataset. Drag and drop table control and select dataset fields. In my example, I have the following fields in the dataset: Id, Functionality, Status, Activity.

Image 1

Step 2

Simply create Dataset dsDynamicColumns using this query:

SELECT 1 ID, 'Id' AS ColumnName UNION
SELECT 2 ID, 'Functionality' AS ColumnName UNION
SELECT 3 ID, 'Status' AS ColumnName UNION
SELECT 4 ID, 'Activity' AS ColumnName

Image 2

Step 3

Create a new parameter with name pDisplayFields and prompt DisplayFields as shown below:

Image 3

In available values of Report Parameter Properties wizard, select Get values from a query, select dsDynamicColumns in Dataset, ColumName in value field and label field.

In Default Values of Report Parameter Properties wizard, select Get values from a query, select dsDynamicColumns in Dataset, ColumName in value field.

Image 4

Step 4

Now, you have to set the expression to display the columns which are selected in the pDisplayColumn parameter. Right click on First Column (Id in our example) and click Column Visibility...

Image 5

Write the following expression in Show or hide based on an expression of Column Visibility wizard:


Then repeat this expression for all the columns by modifying the expression for the respective column name accordingly.

Now, we can see the preview of the report.

Image 6

We can select the required Column that we want:

Image 7

The challenge is we need to control the Display Columns from ASP page.

Step 5

Create an ASP page with Check Box List And Button Click Control.

In Check Box List Control, add Lists like:

Image 8

Image 9

Step 6

In Button Click Event, the Selected Items as concatenated strings using the ',' separator:

var selectedValues = chkColumnList.Items.Cast< ListItem >()
                 .Where(li => li.Selected)
                 .Select(li => li.Value)
           string dynamiColumns = string.Join(",", selectedValues);

Step 7

Get the Report Values from the database using SPC Or Query.

Pass the Report data Value and Parameters in such a way:

rptViewer.Visible = true;

    string path = HttpContext.Current.Server.MapPath("~/Reports/");
    rptViewer.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
    Microsoft.Reporting.WebForms.LocalReport r = rptViewer.LocalReport;
    r.ReportPath = path + "reportName.rdlc";
    Microsoft.Reporting.WebForms.ReportDataSource rds;

    DataTable dt = "Report Data from Data Base" as DataTable;
    rds = new ReportDataSource("DataSet1", dt);

    r.SetParameters(dynamiColumns); //values from check box list

That's all! Now just run the application. We can get the column combination that we want.

Image 10


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Comments and Discussions

PraiseGood Article Pin
SanthoshBabu Mahimairaj23-Oct-15 0:26
professionalSanthoshBabu Mahimairaj23-Oct-15 0:26 
It works fine
QuestionError Received Pin
Jan613-Apr-15 10:41
Jan613-Apr-15 10:41 
AnswerRe: Error Received Pin
Santhosh Babu Mahimairaj14-Apr-15 0:15
professionalSanthosh Babu Mahimairaj14-Apr-15 0:15 
GeneralRe: Error Received Pin
Jan614-Apr-15 3:09
Jan614-Apr-15 3:09 
QuestionNice Article Pin
Member 1028790628-Aug-14 2:54
professionalMember 1028790628-Aug-14 2:54 
AnswerRe: Nice Article Pin
Santhosh Babu Mahimairaj28-Aug-14 3:08
professionalSanthosh Babu Mahimairaj28-Aug-14 3:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.