Section Line Not to Print
 

Hello Everyone

I have made a report in Crystal Reports in which in the Detail Section I am printing two lines
The second line has only few data and that too not always
I am able to supress the data when not needed but the line gets printed whether there is data or not
Is there anyway I can avoid printing the second line if there is no data

Thanks in advance

Hi,
   What u can do is keep the line alone in a separate section and then in the suppress formula part of the section You check whether the data field becomes null. If it becomes null then make suppress formula = true .

For eg:
1.Clik the suppress formula button of the new section created for line
2. if(<datafield> = "")then //Basic syntax
    formula = true 'this will suppress the line if there is no data in the data field.
3.Please ensure that in the Report options u chek the two options
  i. Convert DB null values to default and the one below it as well
Note: Otherwise this null condition checking will not work.


Hope this meets You Well
Regards
dinesh
Klient Informatics
Chennai

m.dinesh

To M.Dinesh

Thanks for the suggestion. It worked wonderfully well and I have implemented it in my report.

Shall post again if any more queries

Thanks again

Bharat