CODEWITHSUNDEEP
reporting-servicesgroupingsql-server-2016ssrs-2016
Leslie
Leslie

Reputation: 3644

SSRS group by multiple fields and groupings

I have a query that returns the following fields:

GrantCode

EmplID

EmployeeFullName

AssignedUnit

DaysOff

HourlyRate

CalendarEventStart

CalendarEventEnd

NumberOfHours

StatuteNumber

ViolationDescription

I want to have a stepped SSRS report that shows: enter image description here the calendar start time, end time and number of hours under the employee name info and then another grouping that shows the citations that were issued during the time period. I can't quite figure out how to get the SSRS groups set up to display in this manner.

I currently have all the data in a single query/data set but can separate it if that will make the reporting easier.

Any suggestions? Thanks! Leslie

Upvotes: 2

Views: 8728

Answers (1)

Strawberryshrub
Strawberryshrub

Reputation: 3389

Add a tablix to your report. Put in the tablix the fields Citation Number, Statue Number, Violation Description, Number of Citations. Then go to Row Groups > Add Group > Parent Group chose for group by the EmplID and check the Add group header, then hit OK.

Afterwards click on the most left column in your tablix and chose Insert Column > Inside Group - Right. Do this a few times and put in these colums the fields EmployeeFullName, Assigned Unit, HourlyRate, DaysOff, StartTime, EndTime.

Then go to your Row Groups and click on the drop down by (Details) and chose Group Properties > Visibilty and check Display can be toggled by this report item:. Here you have to chose the name of the textbox where the EmplID field is. Now the detail data get toggled by the EmplID.

If you want other data to display just add another column and put your fields or expressions in this column. A new column before the two dotted lines is on the group level and column after the two dotted lines are for the detail section.

Upvotes: 4

Related Questions