Supress Section in Crystal XI based on value passed from subreport
Posted on 2007-10-16
I need some assistance with suppressing a section based on a shared value passed from a subreport.
I have a request to filter out students on my report that have less than let's say 5 absences this school year. I figured the best (perhaps more correctly the easiest way) to do this would be to suppress the section displaying student information when the student less that 5 absences. I plan to replace this arbitrary number of 5 with a parameter field later. Anyway for arguments sake I am using the sum of 5 absences.
At present, I have several groupings and my subreport is in GH3. The subreport sums up the total absences for each student. I link on the student's ID #. The report runs great. The shared value that I pass from the subreport (shr_Q1_AbsTotal) declared in the following formula:
Shared NumberVar shr_Q1_AbsTotal;
...is placed on a section below the subreport for the variable to correctly display the value for each respective student.
I need to somehow display only those students with 5 or more absences. How to suppress the section with the subreport to do this? Is there a better method? I could use perhaps previous.record somehow but that method excludes the last record and errors out on the first record. Anyway, I am presenting this question to this forum for assistance.