New answers tagged ssrs
I think you got it half way there with the grouping on student ID. In your report, the group header should include the student ID and name fields, and the detail should include one row per course. You just need to format the layout/grid to make it look like the student ID/name is part of the detail data. Worst case, just add student name to the grouping.
There are two places you can control this visibility. The first is on the row in the tablix; the second is on the row in the Row Groups. If you change visibility by right-clicking the row in the tablix then on the final report the row will be invisible, but still there. If you change visibility by right-clicking the Row Groups line then on the final ...
Unless I'm missing some nuance, you will simply set the Row Visibility based on the value. Right click on the detail line and select Row Visiblity... In the window that pops up, select Show or hide based on an expression Within that expression, you'll use logic like =Fields!Total_Allocation.Value = 0 And Fields!Total_Actual_Cost.Value = 0
You actually just put a SUM around the outside: =Sum(IIF(Fields!Role.Value = "Contractor", Fields!actualwork.Value * 100, Fields!actualwork.Value * 77)) It will evaluate that row by row and will provide the correct sum.
Top 50 recent answers are included