SSRS : Fiscal Grouping

0
votes

I need to group within my SSRS report by Fiscal Week, Month and Year. I'm having the user select a date then referencing a created table that houses the fiscal week, month year etc. for that calendar date. How do I group on this within SSRS?

Fiscal Table Sample Data

Calendar_Date: 04/28/2013
Fiscal_Week: 13
Fiscal_Month: 3
Fiscal_Year: 2013

I want the report to display like

enter image description here

How do I do a grouping where I can group on the week and month of the selected date?

1
reporting-services

1 Answers

0
votes

You can set up a group to be grouped on multiple fields, though it's not exactly intuitive.

When you add a group you can only choose one grouping expression:

enter image description here

However, when you've created the group you can add more grouping criteria:

enter image description here

Add in all your required fields here and it should group correctly by the various required fields.