Print Page | Close Window

to hide the blank rows in the crystal report

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Self-Publishing
Forum Discription: Thinking about writing your own book or already have something to sell? Let me give you advice from my experiences.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12726
Printed Date: 02 May 2024 at 8:02am


Topic: to hide the blank rows in the crystal report
Posted By: subash141
Subject: to hide the blank rows in the crystal report
Date Posted: 28 Mar 2011 at 12:26am
HI ,
       I have a report which is showing the chart. It will display data datewise.For some dates there is no data. In such dates blank space is displaying the chart accordingly. Below the Chart report is also there. This report is also displaying the data datewise. In Chart and report same data is getting displayed. " The requirement is in the report balnk rows sholud not display for the dates which is not having data. " How to hide the blank rows on the Crystal report.
 
Thanks,
Subash


Replies:
Posted By: paul_birm
Date Posted: 28 Mar 2011 at 4:51am
Hi there.
 
have you tried "suppress if Blank" in the report sub-section ?


-------------
Paul
Birmingham
England
{A friend in need is a pain in the a***}

Posted By: sudh
Date Posted: 12 Jul 2011 at 9:17am
Hi,
following steps may be help you to get the requirement:
1.go to report--> selection formulas-->record-->select n option as "default values for null " that exist beside comment (//) option.
2.Write following formula:
   not (isnull({Customer.Address2}))
   (formula will give you data that has no null values.)
3.Now insert you chart into the report,you will get chart without spaces.
 
 
Resolution2:
 
1.You must get your data to the report without null by using add command(free hand sql)
2.you insert the chart.you will get chat without spaces.
 
Thanks,
Sudh.


Print Page | Close Window