Author |
Message |
Yosteevo777
Newbie
Joined: 23 Apr 2012
Location: United States
Online Status: Offline
Posts: 33
|
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 Logged |
|
LynnB
Newbie
Joined: 08 May 2012
Online Status: Offline
Posts: 15
|
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 Logged |
|
mudcat1
Newbie
Joined: 21 Jul 2008
Online Status: Offline
Posts: 11
|
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 Logged |
|
Yosteevo777
Newbie
Joined: 23 Apr 2012
Location: United States
Online Status: Offline
Posts: 33
|
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 Logged |
|
Yosteevo777
Newbie
Joined: 23 Apr 2012
Location: United States
Online Status: Offline
Posts: 33
|
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 Logged |
|
mudcat1
Newbie
Joined: 21 Jul 2008
Online Status: Offline
Posts: 11
|
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 Logged |
|
LynnB
Newbie
Joined: 08 May 2012
Online Status: Offline
Posts: 15
|
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 Logged |
|
kostya1122
Senior Member
Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
|
Posted: 14 May 2012 at 6:12am |
try to create a formula like replace (table.field,"-"," ")
|
IP Logged |
|
|