p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Crystal Reports (http://p2p.wrox.com/forumdisplay.php?f=113)
-   -   Section Line Not to Print (http://p2p.wrox.com/showthread.php?t=63405)

bharatsaboo October 31st, 2007 11:42 AM

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

dineshkrishna108 November 1st, 2007 02:25 AM

   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
Klient Informatics


bharatsaboo November 4th, 2007 11:45 AM

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


All times are GMT -4. The time now is 11:14 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.