SUPPRESS RECORD ON MAIN REPORT WHEN SUBREPORT IS BLANK

[lhill1108]

I have a patient report that is currently being used by our financial counselors. They want to split the report up by medicare patients and non-medicare patients. I have a subreport that has the insurance information in it. When I use the select expert to not equal "Medicare" it still puts the patient information on the main report but just blanks out the insurance information. I would like it so it takes the entire record out.

 

[lbass]

If you are grouping by patient, insert a formula in the (suppressed) GH1a of the main report:

//{@reset}:
whileprintingrecords;
shared stringvar insur;
if not inrepeatedgroupheader then
insur := "";

The subreport should be in GH1b, with a formula in the subreport footer:

whileprintingrecords;
shared stringvar insur := maximum({table.insur});

Then show the main report group info in GH1c and in the section expert->GH1c->suppress->x+2->enter:

whileprintingrecords;
shared stringvar insur;
insur = "";

You should also format each GH1 section to "suppress blank section" and also format the subreport to "suppress blank subreport" (format subreport->subreport tab) and remove the border around the sub. If you need to align the sub information with main report info in the group header, you can format GH1b to "underlay following sections".

-LB