Print Page | Close Window

Suppression of Line if Empty

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19517
Printed Date: 04 May 2024 at 5:07pm


Topic: Suppression of Line if Empty
Posted By: jsh8286
Subject: Suppression of Line if Empty
Date Posted: 08 May 2013 at 8:24am
Have a question regarding suppressing a row if the field in the row is empty.
 
Have a report sorted into two groups. Field A is in group A and Field B is in group B right below. There is not always a value in Field A but always B. The issue is if Field A is blank it creates a blank line so the report has spaces between the lines. For example:
 
This is Field A Line
           This is Field B 1st Line
 
           This is Field B 2nd Line
 
           This is Field B 3rd Line (and so on)
 
I want to eliminate the spaces between these Field B lines but can't seem to do so. Field A is obviously blank hence the gaps.
 
So in a perfect world the resulting layout should look like this:
 
This is Field A Line
          This is Field B 1st Line
          This is Field B 2nd Line
          This is Field B 3rd Line
 
No gaps.
 
Any suggestions?
 
Thanks in advance for any postings.
 


Replies:
Posted By: DBlank
Date Posted: 08 May 2013 at 8:32am

can't quite 'see' your set up here. Not sure if this is groupsections, a detail sections, seomething else...

In general,
go into the section expert
select the section you need to suppress (likely the detail section)
mark the 'suppress blank section' as true.
 
if you need it to be more sophisticated than that you can use the formula for consitional suppression int eh 'suppress (no drill down)' option.

Posted By: nhopp4
Date Posted: 08 Jan 2014 at 3:31am
Goto Section Expert and click on the check by suppress and you can put in a formula to suppress a line if a field is blank.
 
if isnull({field}) then TRUE


Print Page | Close Window