Crystal Reports How to supress main report row when subreport is..

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: How to supress main report row when subreport is..

Author	Message
kgbo Newbie Joined: 26 Jun 2013 Online Status: Offline Posts: 30	Topic: How to supress main report row when subreport is.. Posted: 11 Sep 2013 at 9:04am
	How do you suppress your main report group footer row when the subreport placed in that footer is null, or comes up empty?
	IP Logged


kgbo Newbie Joined: 26 Jun 2013 Online Status: Offline Posts: 30	Posted: 11 Sep 2013 at 9:12am
	I should add that my subreport contains 2 groupings (one by patient ID (this is a number) and the other by CPT code (this is a number)). The line that is showing the data is a Sum of the patient balance and then the corresponding CPT Code for each balance.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 11 Sep 2013 at 9:16am
	set the sub report property to suppress when blank and set the GF section property to suppress when blank.
	IP Logged

kgbo Newbie Joined: 26 Jun 2013 Online Status: Offline Posts: 30	Posted: 11 Sep 2013 at 10:41am
	Still shows blank
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 11 Sep 2013 at 11:18am
	so you right clicked on the sub report select format sub report select subreport tab set the 'suppress blank subreport' as check (true) does this portion work and suppress it as expected?
	IP Logged

kgbo Newbie Joined: 26 Jun 2013 Online Status: Offline Posts: 30	Posted: 12 Sep 2013 at 3:10am
	It still pulls the main report data with a blank spot where the subreport is. My goal is to suppress the whole role if the subreport comes up empty.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 12 Sep 2013 at 3:55am
	Is there any other content on the group footer besides the sub report?
	IP Logged

kgbo Newbie Joined: 26 Jun 2013 Online Status: Offline Posts: 30	Posted: 12 Sep 2013 at 4:13am
	Yes, Patient Name, Transaction Date and Provider's last name. There is two groupings, the first being by Patient Name and the Second being by Patient ID. The subreport is linked via the Patient ID. Edited by kgbo - 12 Sep 2013 at 4:14am
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 12 Sep 2013 at 4:51am
	That is a different question. I assume you have to have the name, date and provider above the sub report. This means you will have to run the subreport twice and split these items into multiple group footers. run it once in GFa above the names, return a shared variable, use that to conditinally suppress the next GFb section with the names and dates and a 3rd to re-run the subreport to show results for positive hits. Or consider moving the names and dates into the subreport and getting them out of the main report.
	IP Logged

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum