Print Page | Close Window

Blank rows in report suppress

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=10718
Printed Date: 02 May 2024 at 3:33pm


Topic: Blank rows in report suppress
Posted By: mkolmos
Subject: Blank rows in report suppress
Date Posted: 03 Aug 2010 at 3:24am
Hi
I have tried to read threads but still having issues with removing blank rows from data.  I have created an Indented Bill of Material with everything properly link. I have 5 groups for the various levels with Parent linked to component for each of the tables.
 
Group A  Comp_item
    Group B Comp_item
       Group C Comp_item
 
I am getting blank lines where no components are present.  It creates a blank row and creates a very long report.
 
Current result
105112 
         105337
                Blank becuase no Group c component present
120328-001
          102236
              200053-01
              200092-01
      
I have tried suppress blank section,  I have tried formula {bmprdstr_sql_2.item_no}='null' for group section
 
Thanks for feedback.  I can send .RPT if desired.
 
 


Replies:
Posted By: DBlank
Date Posted: 03 Aug 2010 at 3:56am
you can conditionally suppress a section in the section expert
as
isnull({bmprdstr_sql_2.item_no})

Posted By: mkolmos
Date Posted: 03 Aug 2010 at 3:59am
Thanks- Worked great.


Print Page | Close Window