The term is clever. I haven't heard it before either.
Unfortunately changing the variable definitions to H0, the same
as the report lines in discussion, didn't solve it my problem.
When I moved the variable definition, some of the table lookups
failed...probably why I had them in PH in the first place.
Ed
Apr 29, 2009 04:22:53 PM, [email protected] wrote:
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.
