The question : Is there a way to suppress the detail section and group of a report if the subreports contained in the detail section are blank?

Here are the specifics on the report: The main report pulls student information, each student has a unique id number. The report is grouped first by school[GH1] then by grade[GH2] and finally by a formula that creates a unique string by concatenating their last and first names with their internal database id #[GH3].
Within the detail section of this report there are two subreports both of which are linked to the main report by the students internal database id.
The first one pulls discipline log entry items for the student who is listed in GH3.
The second subreport pulls course information for all courses the student in GH3 is failing.

I would like for GH3 and detail to be suppressed if both of the subreports are blank. Due to the order of evaluation, I can't pass a variable to use in a formula in the section expert because the GH3 is already processed by the time that the subreport is gotten to.

I appreciate any ideas that you folks have, on how to accomplish this. Thanks.
Timothy


Edited by rqs2344 - 12 Dec 2008 at 11:34am

I have actually already tried that. The problem is that the GH3 section is never blank, there will always be a student name in it, so telling it to suppress it when blank won't work. If, however, the two subreports in the detail section for that particular student are blank I don't want that student to show up on the report. I really appreciate the input and if you have any other ideas please let me know. 

I am pretty good with PL/SQL, I am just not sure that I can create a view. The vendor for the software package that I am trying to report out of (PowerSchool) has a lot of restrictions on what they allow their customers to can do in the DB. I will definitely look into it and see if I have sufficient rights to create a view. Good idea. Thanks for the input.
Timothy