Monday 10 November 2014

SSRS - Alternate Change Column Background Color of Matrix/Table

Query:

select 1 Month,'JAN' Month_Name 
union all
select 2 ,'FEB'
union all
select 3 ,'MAR'
union all
select 4 ,'APR'
union all
select 5 ,'JUN'
union all
select 6 ,'JUL'
union all
select 7 ,'AUG'

Create a dataset using this query.
add your local datasource for this dataset.

Create Matrix as shown below and select column and follow the steps.

Step 1:


Step 2:


Step 3:

Output:




No comments:

Post a Comment