Print Page | Close Window

Add a blank line between records

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16389
Printed Date: 04 May 2024 at 7:40pm


Topic: Add a blank line between records
Posted By: Yosteevo777
Subject: Add a blank line between records
Date Posted: 08 May 2012 at 9:31am
I need to create a blank line (space) or return a line (space) after each Test Group of data in my report.
Currently I have a thin black line showing where I need to have blank spaces inserted.

Any help would be great...


Here is a screen capture of my current report for reference:
https://docs.google.com/open?id=0B2mUAbTW2Ei1aUNCUXpUeFJjc0E



-------------
Stephen Waichulis
LIMS Database Administrator


Replies:
Posted By: LynnB
Date Posted: 08 May 2012 at 8:06pm
Hi,

Unable to view the link, but if you are using a formula, then add 'chr(10) + chr(13)' where you want the line break.

Lynn. 

Posted By: mudcat1
Date Posted: 10 May 2012 at 10:22am

If you need a static space at the end of a Group section of your report, you can also just add the addtional space in the report by lengthening the section after the last object in the section.  This will add empty space between sections, and you can adjust it in the designer.

Posted By: Yosteevo777
Date Posted: 11 May 2012 at 6:46am
Hi Lynn,

You have to copy and past the url into your browser.


https://docs.google.com/open?id=0B2mUAbTW2Ei1aUNCUXpUeFJjc0E



Thanks
Stephen.


-------------
Stephen Waichulis
LIMS Database Administrator

Posted By: Yosteevo777
Date Posted: 11 May 2012 at 6:57am
Hello mudcat1,


I need to come up with a script that will create a space between each record of data.

I work with a LIMS database that handles testing data for a chemistry lab.

My employer needs to have their reports formatted so that each method grouping of tests is separated by a space between other method grouping of tests.

In the past I created 100s of subreports to accomplish this goal.
 
I am now trying to do this without the need of 100s of subreports for each method grouping of tests.

I am also not interested in creating 100s of details sections in my main report either to accomplish this goal.




Thanks again for your reply.

Stephen


-------------
Stephen Waichulis
LIMS Database Administrator

Posted By: mudcat1
Date Posted: 11 May 2012 at 7:37am
Ifa you are using a formula for one of you fields in the Details section of the report, you ca add to the end of the formula:
"End of Your String"&"chr(10)" & "chr(13)"
This will add a CRLF for the entire row.  I dont understand the part about subreports--do you have a one to many join that requires multiple lines in a Group Section of the report??  If that is the case, the only way to do Multiple records for a Group is with a subReport.

Posted By: LynnB
Date Posted: 11 May 2012 at 12:48pm
The thin black line will be in the group header (or/and footer??).
Delete the line and change the size of the header group so as it is the size that you want.

If you can't see the line, it could be sitting right at the bottom of the group section, just increase the group so as you can see it.

Lynn.


Posted By: kostya1122
Date Posted: 14 May 2012 at 6:12am
try to create a formula like
 replace (table.field,"-"," ")


Print Page | Close Window