September 2, 2015 at 10:04 am
Hi
I am trying to create a report that shows by Programme Area those people who have attended the programme 5 times or more.
I have set a count based on the Person ID field to show that and then set an Expression on the Row Visibilty to hide the records if less than 5. The Expression I use is:
=IIF(Count(Fields!Person_ID.Value)<5,True,False)
That works and it only displays the records where the total is 5 or more.
However, my client requires a Count of those records where the attendance is 5 or more but totalling also includes the hidden fields
I have tried creating an additional column to output a 1 if it is 5 or more and a 0 if less than 5 by the expression =IIF(reportitems!Person_ID7.Value >= 5, 1,0).
However, if I try and do a similar thing to get a Sum of this total, I get an error saying aggregate functions can for report items can only be placed within a Page Header or Footer. The client needs the Count broken down by programme so it needs to be within the Tablix!
Is this something which is possible to do?
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply