I have a report that is made up of three sub reports. The sub reports have completely different queries and select statements, so the main report is kind of a one page summary display.
Each of the sub reports contains data that the users want to drill down into. The users accept that they have to open the subreport (by double clicking on it in the main report) and then they can drill down.
The problem is that they want to see the report header at the top of the report for the sub-report if they are in the actual sub-report.
How can I supress the header information in the sub-report if I am viewing it from the main report (since I don't want to see three copies of it), while displaying the information if it is the sub-report's window that is open?
I know that there is a formula that I can use when I am doing something like this to determine if I am in a drill down screen verses the main screen. I am hoping there is the same type of thing for sub-reports.
Each of the sub reports contains data that the users want to drill down into. The users accept that they have to open the subreport (by double clicking on it in the main report) and then they can drill down.
The problem is that they want to see the report header at the top of the report for the sub-report if they are in the actual sub-report.
How can I supress the header information in the sub-report if I am viewing it from the main report (since I don't want to see three copies of it), while displaying the information if it is the sub-report's window that is open?
I know that there is a formula that I can use when I am doing something like this to determine if I am in a drill down screen verses the main screen. I am hoping there is the same type of thing for sub-reports.