asked on

How to add groups to an already existing report SSRS 2014

I have been given a report that is currently group by these fields:
EmployeeID
Project
CostCategory

They now what me to add not only the location and department but to have the ability at runtime to be able to select whether to print in location/department/employee/project/cost category order or department/location//employee/project/cost order. The SQL query has been modified to handle this, however the report was originally written using groups for the
EmployeeID,Project,CostCategory values. Should I scrap those groups and start over? How do I insert the location/department groups at the beginning? Do I create a parent group? How do I get the report to sort in two different orders?

arnold

Not clear what you are asking.

IMHO! Without knowing how the current report is being used, using the query here as a baseline while starting a new report.

rwheeler23

ASKER

My apologies. I do not do much with SSRS and when I do grouping has always been confusing. After spending over four hours on this last night I believe the proper way to do this is to start by dropping the table onto the report. You then either add groups above or below that table. This will create the row group detail. Down there you then click on the respective group and click Add Total either above or below the group. What I still do not understand is the parent/child relationship. I see reports where there is an extended left parenthesis that goes up several rows. I was never able to accomplish this. All I get are all the left parentheses on the same row. The required result is to how subtotals within subtotals within totals. Can you point me to any videos that demonstrate the proper way to accomplish this?

ASKER CERTIFIED SOLUTION

John_Vidmar

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rwheeler23

ASKER

Thanks