I am preparing exam results reports in SSRS using Visual Studio 2008, and the actual report is visually very simple.
I have attached a simplified version here, and it simply lists subjects, grades, and the total of each grade.
I am trying to add a column at the end, to show the percentage of both A and B grades together, within all grades (A,B,C,D).
So, for example, in English, out of a total of 25 candidates, 14 had A or B, so the percentage of A,B is 56%
I'm struggling to write an expression to do this. I would normally do a expression, consisting of a calculation, and reference textboxes in the report grid
to get the values, but in this case the data is grouped, so I'm not sure what to do.
I can't find any similar example on the web.
I have attached sample of the report preview, rendered report, and the SQL output grid showing all the field names.
Can anyone help, please?