CODEWITHSUNDEEP
reporting-serviceschartsssrs-tablix
Renu
Renu

Reputation: 81

SSRS Tablix and Chart Filtering

I have a chart and matrix that shows records for a given date range. User wants to see the records for indidual months.If the user selects date range from January to April then the results would be 4 charts and 4 tablix based on month instead of single chart and single tablix that shows for all months. Could anyone please help me on how to do that. TIA

Upvotes: 0

Views: 728

Answers (1)

Jonnus
Jonnus

Reputation: 3038

  1. Create a list

  2. Insert your existing Tablix/Matrix into the body of the list

  3. Right click the Row header (grey box) of the List and on the General tab set the Group expression to group on the Month value, i.e.

    =Month(Fields!myDate.Value)

  4. Right click the Row header (grey box) of the List and on the Filters tab set two expressions. 

    Expression           Operator Value
-------------------- -------- --------------------------
=Fields!myDate.Value >=       =Parameters!StartDate.Value
=Fields!myDate.Value <=       =Parameters!EndDate.Value

This approach will then take an output that looks like this (for all months)

enter image description here

When applied, and the parameters set so that StartDate = 01/Jan/2015 and EndDate = 28/Feb/2015, will look like this

enter image description here

Note how the data for each month appears separately.

Let me know if this approach works for you, or if you need any further assistance.

Upvotes: 1

Related Questions