Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Add a blank line between records Post Reply Post New Topic
Author Message
Yosteevo777
Newbie
Newbie
Avatar

Joined: 23 Apr 2012
Location: United States
Online Status: Offline
Posts: 33
Quote Yosteevo777 Replybullet Topic: Add a blank line between records
    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



Edited by Yosteevo777 - 08 May 2012 at 1:56pm
Stephen Waichulis
LIMS Database Administrator
IP IP Logged
LynnB
Newbie
Newbie


Joined: 08 May 2012
Online Status: Offline
Posts: 15
Quote LynnB Replybullet 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. 
IP IP Logged
mudcat1
Newbie
Newbie
Avatar

Joined: 21 Jul 2008
Online Status: Offline
Posts: 11
Quote mudcat1 Replybullet 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.

IP IP Logged
Yosteevo777
Newbie
Newbie
Avatar

Joined: 23 Apr 2012
Location: United States
Online Status: Offline
Posts: 33
Quote Yosteevo777 Replybullet 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
IP IP Logged
Yosteevo777
Newbie
Newbie
Avatar

Joined: 23 Apr 2012
Location: United States
Online Status: Offline
Posts: 33
Quote Yosteevo777 Replybullet 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
IP IP Logged
mudcat1
Newbie
Newbie
Avatar

Joined: 21 Jul 2008
Online Status: Offline
Posts: 11
Quote mudcat1 Replybullet 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.
IP IP Logged
LynnB
Newbie
Newbie


Joined: 08 May 2012
Online Status: Offline
Posts: 15
Quote LynnB Replybullet 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.

IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet Posted: 14 May 2012 at 6:12am
try to create a formula like
 replace (table.field,"-"," ")
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.