how do I avoid blank space in crystal report

Question

1.00/5 (1 vote)

See more:

HI FRIRNDS.

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

Posted 9-Feb-14 18:19pm

Prasanna Veeramani

Add a Solution

Comments

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

Regards

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 thatraja...in the mean time let me check if there is any other solution for you...

Sorry once again that the solution didnot work..

Regards

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

Prasanna Veeramani 10-Feb-14 4:38am

sure....:)

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

thatraja · Accepted Answer · 2014-02-09T20:53:00

Solution 1

Someone solved the issue, check it out
How stop the printer after print the Last line in the crystal report (VS2005)[^]

Posted 9-Feb-14 20:53pm

thatraja

Comments

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.