Link to home
Start Free TrialLog in
Avatar of CMANI10
CMANI10Flag for India

asked on

Supress Blank space in crystal report

Dear Expert,

Here i have attached the PDF file which i generate from Report, Please Look that,
I am Getting Blank Space between Record 2  and 3 , how to suppress that blank Space, i need an Continuous Record.

Please look the 2nd attachment,
My remark Field is Overlapping in Line, i had applied ('Extend to bottom of section while printing').

Please Suggest ur comments. CallReport1.pdf CallReport1.pdf
Callreport3.bmp
Avatar of CMANI10
CMANI10
Flag of India image

ASKER

I am Getting Blank Space between Record 2  and 3 , how to suppress that blank Space, i need an Continuous Record.
My remark Field is Overlapping in Line, i had applied ('Extend to bottom of section while printing').
Avatar of peter57r
When you view the report on the screen does it have the same problems, or are these issues only occurring in the export to pdf?
Avatar of CMANI10

ASKER

When i view the report in Viewer itself  i am getting same problem...
Avatar of Mike McCracken
Mike McCracken

Can you upload the RPT file?

You probably need to format the section with SUPPRESS BLANK SECTION or reformat so the blank line is in its own section and then use the SUPPRESS BLANK SECTION option.

mlmcc
Avatar of CMANI10

ASKER

Dear Experts,
Thanks for Ur comments ,
 I have attached RPT file, please view this and suggest me a Solution
CR-00058-CR.rpt
You have to change the data.  The blank line really isn't blank it has a "." in it.  I suspect the data has a CR/LF there so it is just doing as it should.

You could make the field a little wider which would move the "." up but a field with 1 more letter in it would simply create the same problem.

Instead of showing the field itself you could use a formula to replace the CR/LF with 2 spaces.

A quick check shows it is just a chr(10) or LF charaacter in the text.

I made the field a little wider 2.1" instead of 2.03", Solved the spaces you see but a new one appeared a few lines later.  Made it 1.95 and they all disappeared but that is just dependent on the data.  A slight change and you will have the same result.

You could use a formula like this to change the LF to 2 spaces.  In that case the new date shows in the middle of the line rather than being its own line.

mlmcc
   Replace({R00058.CALL_DESCRIPTION},chr(10),"  ")

Avatar of CMANI10

ASKER

Dear Experts ,
Here i have attached the screen shot of  Call description field from DB, here i didn't find any space or dot.
Please check and suggest Ur solution.
Data.bmp
The issue is the "." at the end of each sentence.  In some cases they wrap to the next line.

I guess you could replace all of them with ""

Replace({R00058.CALL_DESCRIPTION},".","")

Note how your document puts each entry on its own line.  That is what Crystal is doing.  The difference is Crystal is wrapping the text and the field is narrower.

mlmcc
Avatar of CMANI10

ASKER

Dear Experts ,
Thanks for your valuable comments , i understand the problem, but i don't know how to solve .
i applied the replace formula for call description, but i am getting same issue .
You may not be able to fully solve the issue unless you are willing to see

10/10/11 the initial visit my comment
end.  11/11/11 next comment starts

If that is fine in the report then you could use a replace like this to replace the LF with 2 spaces
      Replace({R00058.CALL_DESCRIPTION},chr(10),"  ")

The text also has some spaces before the ".".  I expected the spaces to be ignored on the wrapping but maybe not.
You could replace the " ." with nothing then replace the "." with nothing
       Replace(Replace({R00058.CALL_DESCRIPTION}," .","")," .","")

mlmcc
Avatar of CMANI10

ASKER

Right click - Format object and UN check   Keep object together.
I got the solution what i need.
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial