RBGXE 10.0.2.20126 Single User
Best viewed in font: Courier New
SUMMARY
Report Address Block contents and alignment go all to Hades when the
width of one column within the source table is widened.
BACKGROUND
I'm crafting a simple report to print address blocks on #10 envelopes.
The address block is built within the Report Variable "vAddressBlock",
NOTE data type:
(UNameF_Full + (CHAR(013)) + HolderEntityLABL + (CHAR(013)) +
StreetAddress + (CHAR(013)) + CityStateZip)
... placed within a Variable Memo Control in the Detail Band below Break
Header [0] defined on "UNameF_Full". The control is wide enough to
easily accommodate a sixty-character line.
By configuring to R:azzak's "SuppressEmptyLinesInReports" sample,
address blocks of variable line count align and print perfectly.
The report draws from temp table "Contacts_for_Mailing_List_tt", which
populates with values from several views drawn from tables whose column
widths are equal to or shorter than those in this generated report
source table:
SET ERROR MESSAGE 2038 OFF
DROP TABLE Contacts_for_Mailing_List_tt
SET ERROR MESSAGE 2038 ON
CREATE TEMP TABLE Contacts_for_Mailing_List_tt +
( ListRecordID INTEGER, +
HolderEntityID INTEGER, +
HolderEntClassID INTEGER, +
HolderEntityLABL TEXT (45), +
HolderActive_YN TEXT (1), +
UserEntityID INTEGER, +
UserEntClassID INTEGER, +
UNameF_Roster TEXT (30), +
UNameF_Full TEXT (30), + -- varying the column width produces
anomalous formatting
UNameF_Last TEXT (20), +
UNameR_Full TEXT (25), +
UNameR_First TEXT (25), +
UserActive_YN TEXT (1), + -- Value = 'Y' if contact is to print on
envelope
ContactPrefCODE TEXT (4), + -- Value = 'PRI' to identify PRImary
contact at address
StreetAddress TEXT (50), +
CityStateZip TEXT (50), +
CityNAME TEXT (25), +
StateCODE TEXT (2), +
Plus4ZipCODE TEXT (10) )
(Note: the comments above do not appear in the table creation code)
THE PROBLEM
So long as column UNameF_Full is defined with width=30, the address
block formats as expected and desired. But there are column values
truncated at 30 character width so I need to define a wider UNameF_Full
column.
Widening UNameF_Full, then re-running the report on a regenerated table
produces anomalous formatting. The problem spans an Unload/Reload cycle.
In the examples below, I'm using my address but the anomalous formatting
obtains consistently for ALL address blocks (I've inserted periods in
place of spaces to highlight the offset and bolded the "leakage" from
the UserActive_YN and ContactPrefCODE columns).
Width=35 (Offset=5)
Mr. Bruce Chitiea
SafeSectors, Inc.
.PRI.112 Harvard Ave #272
.....Claremont CA 91711-4716
Width=40 (Offset=10)
Mr. Bruce Chitiea
SafeSectors, Inc.
..Y...PRI.112 Harvard Ave #272
..........Claremont CA 91711-4716
Width=45 (Offset=16)
Mr. Bruce Chitiea
SafeSectors, Inc.
........Y...PRI.112 Harvard Ave #272
................Claremont CA 91711-4716
Width=50 (Offset=20)
Mr. Bruce Chitiea
SafeSectors, Inc.
............Y...PRI.112 Harvard Ave #272
....................Claremont CA 91711-4716
***
It's literally "for the children" (a Rotary event), and I'm stuck.
Any thoughts?
Bruce
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
