[RBASE-L] - Re: Eliminating Print of Blank Lines in Reports

[Ed Rivkin]

Bill,
Yes, I recall typing many a paper in the day. Carriage return and line feed were typically
a manually induced process hitting the trusty level at the appropriate time on the typewriter.

I tried your suggestion two ways; i.e. defined the vCRLF variable as you suggested in
your previous post and added it to .csz as .csz2 which becomes the 2nd argument in vprintline4.

No change in result from previous.

I also added (CHAR(10) + CHAR(13)) to .csz in the vprintline4 variable with no improvement.
All variables are defined at PH and are in a logical order.

This just isn't my day...for some reason.

Ed

Apr 29, 2009 11:19:01 AM, rbase-l@rbase.com wrote:

Ed,

I don't know if this applies, but traditionally CHAR(13) was the way a computer encoded and stored the equivalent of a "carriage return" (you remember, don't you!? When the "carriage" of the typewritten returned from right to left?), and CHAR(10) was the "line feed" (when you rolled the platen up/forward 1/6 of an inch).  Maybe you are "returning the carriage" without "feeding the line."

I have code similar to yours, that does both, and I have few problems with it:

SET VAR vCRLF = (CHAR(10) + CHAR(13))

On Wed, Apr 29, 2009 at 12:01 PM, Ed Rivkin <erivki...@verizon.net> wrote:

Emmitt,
Thanks. I tried the suggested syntax below and it places the carriage return before printing the .csz
variable so it now prints one line too low.

If I use this syntax for Line 18:
TEXT   : PH : vprintline4 = (Ifexists(.name2,.csz+(CHAR(13)),'  '))     

I still have the previously reported result; i.e. I don't get a space between print line four and the next
print line. I also tried defining a new variable, .csz2 which includes .csz+(CHAR(13)) and making
that the 2nd argument in vprintline4. Finally I varied between (CHAR(13)) and (CHAR(013)) without
any change in the result.

Thanks to Javier as well for the band suggestion. Dynamic Height is highlighted for the Page Header Band.

Sorry to be giving everyone such a challenge but I am really stumped on this one....

Ed

Apr 29, 2009 10:16:59 AM, rbase-l@rbase.com wrote:

Ed,

Move the (CHAR(13)) to the definition of the print line.  What is happening is that even if your line is blank you’re getting a carriage return inserted.

  18  : TEXT   : PH : vprintline4 = (Ifexists(.name2,(CHAR(13))+.csz,'  '))

Emmitt Dove

Manager, Converting Applications Development

Evergreen Packaging, Inc.

emmitt.d...@everpack.com

(203) 214-5683 m

(203) 643-8022 o

(203) 643-8086 f

emmitt.w.d...@comcast.net

From: rbase-l@rbase.com [mailto:rbase-l@rbase.com] On Behalf Of Ed Rivkin
Sent: Wednesday, April 29, 2009 11:00 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Eliminating Print of Blank Lines in Reports

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.

Thanks again,
Ed

Apr 28, 2009 09:32:15 PM, rbase-l@rbase.com wrote:

At 10:05 PM 4/28/2009, Ed Rivkin wrote:

>how does one eliminate the now additional blank lines and
>get the spacing between addresses consistent regardless of
>the number of lines that printed.

Ed,

The best option is to use "Variable Memo" control based on
the _expression_ that handles the blank data.

Once you place the Variable Memo and associate the control
with appropriate variable, you may adjust the height to a
minimum and make sure to allow "stretch".

Example:

vCityStateZip = (City + ','&State&ZipCode)
vPrintLine1 = (FirstName&LastName)
vPrintLine2 = (IFEXISTS(Company,Company,AddressLine1))
vPrintLine3 = (IFEXISTS(Company,AddressLine1,(IFNULL(Company, +
(IFEXISTS(AddressLine2,AddressLine2,.vCityStateZip)),.vCityStateZip))))
vPrintLine4 =
(IFEXISTS(Company,(IFEXISTS(AddressLine2,AddressLine2,.vCityStateZip)), +
(IFNULL(Company,(IFNULL(AddressLine2,' ',.vCityStateZip)),' '))))
vPrintLine5 = (IFEXISTS(Company,(IFEXISTS(AddressLine2,.vCityStateZip,' ')), +
(IFNULL(Company,' ',' '))))

vAddress =
(.vPrintLine1+(CHAR(013))+.vPrintLine2+(CHAR(013))+.vPrintLine3+(CHAR(013))+.vPrintLine14(CHAR(013))+.vPrintLine1+(CHAR(013)))

In this example, the vAddress is defined as "NOTE" and placed as
"Variable Memo"
control with "Stretch" set to true (checked).

Hope that helps!

Very Best R:egards,

Razzak.

P.S. If you need a sample report or label based on this technique, let me know.