Self-Publishing
 Crystal Reports Forum : General Information : Self-Publishing
Message Icon Topic: to hide the blank rows in the crystal report Post Reply Post New Topic
Author Message
subash141
Newbie
Newbie


Joined: 28 Mar 2011
Online Status: Offline
Posts: 9
Quote subash141 Replybullet Topic: to hide the blank rows in the crystal report
    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
IP IP Logged
paul_birm
Newbie
Newbie
Avatar

Joined: 10 Jul 2008
Online Status: Offline
Posts: 25
Quote paul_birm Replybullet 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***}
IP IP Logged
sudh
Newbie
Newbie


Joined: 11 Jul 2011
Location: India
Online Status: Offline
Posts: 6
Quote sudh Replybullet 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.
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.047 seconds.