Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Blank Supressed Subreport Post Reply Post New Topic
Author Message
urbanmojo
Newbie
Newbie


Joined: 26 Sep 2012
Location: Canada
Online Status: Offline
Posts: 3
Quote urbanmojo Replybullet Topic: Blank Supressed Subreport
    Posted: 26 Sep 2012 at 11:16pm
I have Crystal Reports 2008. I have a subreport in Details A, and the main report data row in Details B. In the subreport I do a count, set a shared variable to that count and pass it to the main report. The Details A section on top is set to underlay Details B, standard practice to get the subreport to calculate the variable first. Details B is set to be suppressed if the count from the subreport is greater than zero.

Problem is that when the subreport returns a greater than zero value Details B is suppressed but Details A still underlays a blank line so creates a gap. So I have small little gaps in between rows of data.

All sections in the subreport are suppressed but the subreport itself cannot be suppressed because it has to do the calculation. And it won't know until it runs.

How to avoid these gaps?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 27 Sep 2012 at 3:34am
set the subreport to suppress when blank and set detail A to uppress when blank
IP IP Logged
urbanmojo
Newbie
Newbie


Joined: 26 Sep 2012
Location: Canada
Online Status: Offline
Posts: 3
Quote urbanmojo Replybullet Posted: 27 Sep 2012 at 7:38pm
Thought I tried that combo but I hadn't I guess. That works, thanks.
IP IP Logged
Post Reply Post New Topic
Printable version 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



This page was generated in 0.016 seconds.