At 06:28 PM 11/10/2008, Mark Lindner wrote:
I am trying to code a report to create a standard commercial bank
deposit slip. The basic layout is easy but I need to place the
bank MICR code numbers along the margin oriented at 90degrees to
the main text in a fixed location.
I can create the numbers and have the fonts for the MICR but how
do I put a rotated label in a fixed position on such a report, it
seems like it has to extend over the various bands.
Mark,
Here's how:
01. Start R:BASE 7.6, Turbo V-8 or R:BASE eXtreme (v9.0) and
CONNECT to appropriate database.
02. Open the appropriate report in Report Designer
03. While in Report Designer, define a variable as expression in
Report Expression Builder
Example:
Name: vResult
Type: TEXT
Expression = (colname)
Calculate On: [D]
Click on [Add] to add expression
Click on [Apply] to save expression
Click on [Close] to close expression builder
04. Place a "Rotated Label" control (part of Standard Controls)
on appropriate band of the report
05. Right-click on "Rotated Label" control for speed menu options
and select "Angle...". Type 90 for required value to Rotate.
Now adjust the width and height of the control as you wish.
06. Right-click on "Rotated Label" control for speed menu options
and select "Component ID" and assign a unique Component ID,
such as "RotatedLabel".
07. Use the following code as "Before Generate Custom EEP" for
appropriate band:
PROPERTY RotatedLabel CAPTION .vResult
RETURN
This will dynamically change the value for Rotated Label for
each individual record (if placed on Detail band).
That's all there is to it!
Take a look at the sample "UsingAdvancedPropertiesInReports"
report bundled with Running R:BASE Your Way! (Part 16) - included
with 2009 SAT Applications. http://www.rupdates.com/sat2009/
Very Best R:egards,
Razzak.
