I tried to enter a formula to evaluate to true when I wanted the section suppressed. So I checked the suppress checkbox and entered the following formula:
recordnumber < 2
The problem is that it would suppress rows 2 through infinity if there was more than one row. I want it to suppress the whole section if only one row exists in the data set. This requires the use of a different reserved word, as recordnumber does not refer to the logic I want to use.
To answer your question, the subreport is in the detail section of the main report. The group (patient_name) is in the subreport and not in the main report. There will be multiple subreports that will run with similar logic. And the report is for one person, by the way. I added the group because I wanted to try something that ended up not working anyway.
You say that your solution should work "if the number of rows in the group is 1 then suppress". But the question remains: What reserved word do I use in CR11 to refer to the whole dataset so I can discern a dataset with one row from one with many rows? If there isn't a reserved word that will do the job, what procedure do I use to get CR11 to hide the section anyway?
Please tell me if this is not clear.
Thanks,
Joel
Edited by Hammershell - 18 Aug 2009 at 9:15am