That's what I have already done but.... I don't want a repeat each detail line and it needs to be anchored at a fixed location on the page, which seems to be the hard part.
The required location is to have the MICR line print at 90degrees to the detail lines on the page in a specific location. I can get the rotation part and the font but if I put it in a detail section it repeats which I don't want. If I try to put it in a header or footer, its too big and wont fit when rotated, and if I make it big enough to fit the detail section is in the wrong place. What I seem to need is to have it print as if it were an overlay or watermark independent of the detail data. Mark Lindner Lindner & Associates PC 254 Second Ave Needham MA 02494 781 247 1100 Fax 781 247 1143 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Monday, November 10, 2008 8:01 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Report with rotated fixed location text 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.
