Click here to Skip to main content
15,792,386 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:

I have a problem in crystal report.
I designed a crystal report of page size a4, in many cases the report part is just half of the page, but the full a4 size page is printed. I want to stop printer if data is printed,not the white space. even for 2 or 3 records the whole sheet is printed. kindly help me to solve this..

thank you
Dinesh.V.Kumar 10-Feb-14 1:06am    
Right click on the text controls. Select Properties..You will have a property named "Suppress". To the right of that there will be a button. Click on that button. It will open a Formula window. There use the formula similar to the one below
if trim({<field from="" db="">}) = "" then true else false.
This will suppress the fields from displaying if there are no records...Hence will not be available for printing.

Hope it helps

Prasanna Veeramani 10-Feb-14 4:20am    
Thanks for ur reply dinesh. I set the page size to a4 so it print full sheet. its not working dinesh, any other suggestions??
Dinesh.V.Kumar 10-Feb-14 4:23am    
Oops!!Sorry about that....Please check the Solution provided below by another member the mean time let me check if there is any other solution for you...

Sorry once again that the solution didnot work..

Prasanna Veeramani 10-Feb-14 4:30am    
thats ok dinesh, let me tell u after solving this issue
Dinesh.V.Kumar 10-Feb-14 4:34am    
Sure just post the solution so that it may be helpful some time later..

Thanks & Regards

1 solution

Share this answer
Prasanna Veeramani 10-Feb-14 4:32am    
thank q for response, That method is different, I need to solve in this. im sure it have a solution.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900