[Progresso] SSRS Reporting Grade Values

[RootsSchImp]

Hi,

 

I'm sure this is probably the case but I wonder if a Progresso reporting user could confirm for me: can you store and report on grade values of assessment results, so that, for example, teachers could give 5+, 4- etc on a marksheet but in a report you could count number of grades with values greater than 4?

 

Thanks

 

Ed

[Mic_Impero]

You can report on those fields, and in the report you'd need an inline if to replace the grades determined with a 1, wrapped in a sum. So =sum(iif(fieldname='5+',1,0)) If you wanted to count multiple values you'd nest the iif. If you were basing on integer you could do greater than but if you've used + and - then you'd need to nest an iif listing anything greater than a 4 so it knows what greater than a 4 consists of.

 

The other way you could do this is with a matrix and totals, but that completely escapes me. It's been a good couple of years since I've done this and don't have a test environment so that's from memory as best guess... i'm sure someone such as @djrscally will be along with a better answer for you at some point!

 

Mic

[djrscally]

Mics way works fine; rather than nested Iif() it's slightly easier to just to leave the "Points" field in the Assessment Scale as being the points for the full grade (so "5+", "5" and "5-" would all be worth 5 points) and then you can just do =Sum(Iif(Fields!Points.Value >= 5, 1, 0)).

 

Matrix and totals still need the same code to get the totals so not actually any easier.