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 0 posts
You must be logged in to reply to this topic. Login to reply