Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Blank rows in report suppress Post Reply Post New Topic
Author Message
mkolmos
Newbie
Newbie


Joined: 03 Aug 2010
Online Status: Offline
Posts: 2
Quote mkolmos Replybullet Topic: Blank rows in report suppress
    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.
 
 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 03 Aug 2010 at 3:56am
you can conditionally suppress a section in the section expert
as
isnull({bmprdstr_sql_2.item_no})
IP IP Logged
mkolmos
Newbie
Newbie


Joined: 03 Aug 2010
Online Status: Offline
Posts: 2
Quote mkolmos Replybullet Posted: 03 Aug 2010 at 3:59am
Thanks- Worked great.
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.015 seconds.