Multiple Subreports - make null reports not visible

[echorley]

I have several subreports (student transcripts from previous school years) on one report. Some students do not have any grades for a particular school year (if they moved out of district, then returned).

1. Is is possible to make the subreports that do not contain any data not visible and

2. then re-arrange the other subreports so there is not empty spaces where the null reports were?

Thanks!

 

[scalextric59]

Since you are processing by students, you can include something like this on the Detail_format of the parent report:

If Not [<subreport>].[Report].[HasData] Then
<your code here>
endif