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

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.