Group headers and subreports

[amrnewman]

Hi all

CR XI
SQL Server

I have a report with group header 1a of lead applicant name. Group header 1b contains 5 subreports, each pulling in information about different areas of work and is linked by USER_ID - Testing has shown the data is correct.

I want to be able to suppress 1a (name) if there is no data in the subreports. I have set all the subreports in 1b to 'Suppress blank subreport' and have set the section to suppress if blank through section expert.

I have passed a shared variable from subreport to header 1c and added a reset formula in 1d and then tried to suppress 1a based on the shared variable (string) being null. HOwever this suppresses all the headers - I want to view header1a if there is data in the subreport.

I used to be quite advanced with CR but have not used for a while and have fogottnen basic stuff like where shared and reset formulas shoudl be. have tried some trial and error and looking through these posts but am lost!

Help!

Thanks in advance, Ade

 

[MrBillSC]

I believe that the subreports would have to be in a section on the main report above the header section you want to suppress.

MrBill

 

[amrnewman]

I found the following very useful and solved the problem. the CR memories are coming back now!

thread767-1133866