Home > MSDN, SSRS > SSRS Report Parameter Summary Page -MSDN

SSRS Report Parameter Summary Page -MSDN

I got this question from MSDN, link to original question is here

User comment:-

Advise the solution options to display runtime values of the report multi select parameters in the below format and then highlight the background color based on selection or not selection of the report parameters values by the report user

 

Let’s create sample report, create one dataset for the parameter with the name “ParameterQuery_DS”

SQL query for ParameterQuery_DS :-

select ‘Approved’  projectStatus

union

select ‘Closed’

union

select ‘In Progress’

Let’s Create one more dataset as “ParameterFilterDS”

SQL query for ParameterFilterDS:-

select * from

(

select ‘Approved’  projectStatus

union

select ‘Closed’

union

select ‘In Progress’

)t

where projectStatus in (@Status)

Create one Parameter with name Status, make it as multivalue and put the available values from SQL query and select ParameterQuery_DS dataset.

Report layout, create on matrix table and select ParameterQuery_DS dataset for the Matrix.

Put the projectstatus column on column section of Matrix and hide the row of the Matrix.

Design will look like below:-

Design

Go to Column properties to write expression for backgroundcolor as shown in below screen

ReportExpression

Write below expression in above screen area:-

=iif(Fields!projectStatus.Value=Lookup(Fields!projectStatus.Value,Fields!projectStatus.Value,Fields!projectStatus.Value, “ParameterFilterDS”),”Blue”,”No Color”)

Run the report with two parameters or more, output look like below:-

ReportOutput

Select other parameter and run the report

ReportOutput1

Thanks
Prasad

Learn Different BI Tools
Subscribe my YouTube Channel : BI Tools

Advertisements
Categories: MSDN, SSRS Tags: ,
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: