Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 554
  • Last Modified:

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
0
CMANI10
Asked:
CMANI10
  • 6
  • 5
1 Solution
 
CMANI10Author Commented:
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').
0
 
peter57rCommented:
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?
0
 
CMANI10Author Commented:
When i view the report in Viewer itself  i am getting same problem...
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
mlmccCommented:
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
0
 
CMANI10Author Commented:
Dear Experts,
Thanks for Ur comments ,
 I have attached RPT file, please view this and suggest me a Solution
CR-00058-CR.rpt
0
 
mlmccCommented:
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),"  ")

0
 
CMANI10Author Commented:
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
0
 
mlmccCommented:
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
0
 
CMANI10Author Commented:
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 .
0
 
mlmccCommented:
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
0
 
CMANI10Author Commented:
Right click - Format object and UN check   Keep object together.
I got the solution what i need.
0
 
mlmccCommented:
That will not resolve the original issue of the "blank" lines.  It may resolve the overlap issue.

mlmcc
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now