I’ve got question on grouping in SSRS that sounds pretty simple, but I can’t figure it out due to SSRS limitation on how you can move fields around in SSRS grouped reports. Please click on the below link for the suggested report layout. The data is grouped by all 3 fields – Employee/Order Type/Status. However, Order Type & Status fields should be displayed on one row, and SSRS doesn’t allow me to do that. I've done similar things in Crystal. Is it doable at all in SSRS? PLEASE CLICK THIS LINK TO SEE THE PROPOSED REPORT LAYOUT
Actually, I was able to implement it using a free form report (List), subsequently adding a group to a list, then adding Employee Name and table with the rest of the fields. Subtotals were added within the list using expression and totals where adding using Add Total command of the Group
