Hi David,
Will something like this help?
AddrLine2 = (IFEQ(.Address2,NULL,.CityStZip,.Address2))
AddrLine3 = (IFEQ(.AddrLine2, .Address2,.CityStZip,NULL))
Bernie Lis
----- Original Message -----
From: David Blocker
To: RBASE-L Mailing List
Sent: Friday, November 27, 2009 7:20 PM
Subject: [RBASE-L] - Tearing My Hair Out Over Report Suppressing Blank Values
I have tried to follow the directions from Doug Hamilton and Sami Aaron and
Karen Tellef for this kind of report and after far too much time I have to turn
to the list again to see what I?m doing wrong.
Here are the key facts about the report, which is a membership directory for
a Musicians? Union:
<!--[if !supportLists]-->1. <!--[endif]-->This is COLUMNAR report: File
/ Page Setup / Layout / Columns 4
<!--[if !supportLists]-->2. <!--[endif]-->Because of space issues, the
font is small: Arial 8 for all fields
<!--[if !supportLists]-->3. <!--[endif]-->There could be as many as 8
lines of data for each listing: top line is far left, other 7 are slightly
indented to the right. So an example of a successful entry with all 8 lines
not null would be:
Brown, Roger
3 Main St.
Apt. 3
Boston, MA 02112
(617)333-4455
(781)999-8877
[email protected]
WC WJ WK
If say, Street2 was blank it would be:
Brown, Roger
3 Main St.
Boston, MA 02112
(617)333-4455
(781)999-8877
[email protected]
WC WJ WK
Specs:
Field
Font
NULLs possible?
Full Name (Last / First)
Bold
No
Street
Normal
No
Street 2
Normal
Yes
City, State Zip
Normal
No
Home Phone
Bold
Yes
Work Phone
Bold
Yes
Email *
Bold
Yes
Instruments Played **
Normal
Yes
* Email is a very long field and so the data should wrap onto a
second line if necessary: it should NOT be truncated
** Instruments are up to 10 possible 2 letter codes representing
instruments the musician plays
The report is based on a view that does all the concatenating needed (for
full name, for City, state zip, and for instruments played list)
Never mind getting the groups to print together in a column without going to
the next column: all I?ve tried to do so far is to get the spacing between the
lines right. I?m having a lot of trouble right there.
From John?s email it wasn?t clear to me whether there should be ONE region /
rich text object per line desired, or if you could / should put more than one
line in a rich text object. John, for example, your directions from Sami read:
? In the Edit Window, Choose the Edit Menu and then Insert Fields -
choose Person1.
Press ENTER to go to the next line in the text box and
Edit / Insert Fields and choose Person2.
Click the "x" to close the Rich Text window.?
This implied to me more than one row of data in each Rich Text object
But later you said:
?I just created a member directory report. Each listing may have from
one to five lines (lastname/firstname, children's names, addr1, addr2 &
CSZ). It works great! Each line is a rich text object in its own region
that stretches and shifts relative to the preceding region? ?
This implied to me only one row of data in each Rich Text object
Whatever ? neither is giving me what I want. I?ve only tried so far to get
the first 4 rows of the 8 rows to be what I want. Here?s what I?ve tried and
what?s happened:
Trial 1: ONE line of data per Rich Text Object
Region
Settings
Contains
Rich T Obj
Settings
Contains
Results
Region1
Stretch
Visible
No line
RTO 1
RTO 1
Mailmerge
Stretch
Visible
Full Name
Prints fine
Region2
Stretch
Visible
Shift Relative to Region 1
No line
RTO 2
RTO 2
Mailmerge
Stretch
Visible
Street
No matter how close to Region1 I place these two, I get the equivalent
of a DOUBLE space between Fullname and street: in my latest version, Region2
OVERLAPS region1 and I still get the spacing error
Region3
Stretch
Visible
Shift Relative to Region 2
No line
RTO3
RTO3
Mailmerge
Stretch
Visible
Street 2
If there is NO Value, the blank line is suppressed, but again too much
spacing between Street and CSZ below
If there IS Street 2, it is TOO close to CSZ, with CSZ slightly
overlapping it, even if place region4 WAY below region 3
Region4
Stretch
Visible
Shift Relative to Region 3
No line
RTO4
RTO4
Mailmerge
Stretch
Visible
City, State Zip
See above
Results are like this if there?s no street2:
Brown, Roger
3 Main St.
Boston, MA 02112
<!--[if !supportLineBreakNewLine]-->
<!--[endif]-->
Like this if there is a street2
Brown, Roger
3 Main St.
Apt. 3
Boston, MA 02112
<!--[if !supportLineBreakNewLine]-->
<!--[endif]-->
(Boston line slightly overlaps the Apt 3 line)
I?ve tried, making the region object larger than the Rich text object inside
it, making the size of the Region and RTO?s the same ? it has no effect. I can
even appear to drag the RTO outside the region and it has no effect. My
current report screen is jammed and wierd looking from trying to move objects
to reduce spacing between lines.
If I try putting Fullname and Street together in the first region, with
Street a line below fullname, the spacing between Fullname and street is
perfect, but then I get a huge space between that the next line:
Brown, Roger
3 Main St.
<!--[if !supportLineBreakNewLine]-->
<!--[endif]-->
Boston, MA 02112
<!--[if !supportLineBreakNewLine]-->
<!--[endif]-->
Help would be appreciated!
David Blocker
"David Blocker
[email protected]
Office: 781-344-1920
Cell: 339-206-0261"
