At 11:00 AM 4/29/2009, Ed Rivkin wrote:
Razzak,
Thanks for the quick response last night. Here's what I did. Unfortunately
I still have the same spacing problem.
My first print line always prints so I didn't include it in the IFEXISTS
/IFNULL logic or the vaddress variable.
Here are my variables.
1 : TEXT : PH : sal = salutation in salutation where salut = salut
2 : TEXT : PH : fname = fnamer in tenant where acct = acct
3 : TEXT : PH : lname = lnamer in tenant where acct = acct
4 : TEXT : PH : v1name = (sal & fname & lname)
5 : TEXT : PH : sal2 = salutation in salutation where salut2 = salut2
6 : TEXT : PH : fname2 = fnamer2 in tenant where acct = acct
and salut ne '5'
7 : TEXT : PH : lname2 = lnamer2 in tenant where acct = acct
and salut ne '5'
8 : TEXT : PH : name2 = (sal2 & fname2 & lname2)
9 : INTEGER : PH : addr = addr1r in tenant where acct = acct
10 : TEXT : PH : st = street in commaddr where stcode = stcode
11 : TEXT : PH : street = (ctxt(.addr) & st)
12 : TEXT : PH : city = city in commaddr where stcode = stcode
13 : TEXT : PH : state = state in commaddr where stcode = stcode
14 : TEXT : PH : zipcd = zipcd in commaddr where stcode = stcode
15 : TEXT : PH : csz = (.city + ',' & state & zipcd)
16 : TEXT : PH : vprintline2 = (IFEXISTS(.name2,.name2,.street))
17 : TEXT : PH : vprintline3 = (Ifexists(.name2,.street,.csz))
18 : TEXT : PH : vprintline4 = (Ifexists(.name2,.csz,' '))
19 : NOTE : PH : vaddress =
(.vPrintLine2+(CHAR(013))+.vPrintLine3+(CHAR(013))+.vPrintLine4+(CHAR(013)))
.vaddress is in the report as a Variable Memo with "stretch" clicked on.
When lines 2,3,4 print, everything lines up perfectly. When line 4
prints as blank,
I still have the extra line. This is printing in the break header
which is where I want it.
Ed,
Looking at the expressions, it seems that you have defined all expressions to
be evaluated at Page Header (PH) level. However, you have placed the controls
on Break Header (H0) or (H1), etc.
Change the expression "Section" to H0, or H1, accordingly and see what results
you get.
Hope that gives you some blue's clues ..
Very Best R:egards,
Razzak.
