Razzak, Thank you for utilizing this enhancement request. Being able to create very polished reports is always helpful.
Jan -----Original Message----- From: "A. Razzak Memon" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Tue, 19 Apr 2011 00:45:41 -0400 Subject: [RBASE-L] - Tip of the Day - Using BRUSH_STYLE and PEN_STYLE Properties inReports Tuesday, April 19, 2011 Tip of the Day - Using BRUSH_STYLE and PEN_STYLE Properties in Reports Product: R:BASE eXtreme 9.1 (32/64) Update.: 3 Build..: 9.1.3.10414 or higher http://www.rupdates.com Section: Report PROPERTY Commands Object.: Shape While in Report Designer, when placing a Shape Object, you may also customize the Shape Type, Fill Color, Line Color, Line Thickness, and Line Style. Did you know that using the new PROPERTY commands you may dynamically change the Shape Style and Pen Style as well? Here's how: Syntax: PROPERTY <ShapeObjectCompID> BRUSH_STYLE 'value' Supported Values: SOLID CLEAR HORIZONTAL VERTICAL F_DIAGONAL B_DIAGONAL CROSS DIAG_CROSS PROPERTY <ShapeObjectCompID> PEN_STYLE 'value' Supported Values: SOLID DASH DASH_DOT DASH_DOT_DOT CLEAR INSIDE_FRAME USER_STYLE ALTERNATE You may dynamically change BRUSH_STYLE and PEN_STYLE Properties as On Before Generate Report Action or conditionally as On Before Generate Action on any Report Band, as you wish. -- Example 01 -- Database: RRBYW17 -- Report: InvoiceSummary_Brush_Style_Pen_Style -- Using New BRUSH_STYLE and PEN_STYLE Properties for Shape Control -- Action: Report Header [Before Generate] -- Cover Page Shapes PROPERTY CoverPage_Shape_01 BRUSH_STYLE 'HORIZONTAL' PROPERTY CoverPage_Shape_01 PEN_STYLE 'SOLID' PROPERTY CoverPage_Shape_02 BRUSH_STYLE 'VERTICAL' PROPERTY CoverPage_Shape_02 PEN_STYLE 'DASH' PROPERTY CoverPage_Shape_03 BRUSH_STYLE 'F_DIAGONAL' PROPERTY CoverPage_Shape_03 PEN_STYLE 'DASH_DOT' PROPERTY CoverPage_Shape_04 BRUSH_STYLE 'B_DIAGONAL' PROPERTY CoverPage_Shape_04 PEN_STYLE 'DASH_DOT_DOT' RETURN -- Action: Page Header [Before Generate] -- Page Header Shapes PROPERTY PageHeader_Shape_01 BRUSH_STYLE 'CROSS' PROPERTY PageHeader_Shape_01 PEN_STYLE 'INSIDE_FRAME' PROPERTY PageHeader_Shape_01 BRUSH_STYLE 'DIAG_CROSS' PROPERTY PageHeader_Shape_01 PEN_STYLE 'ALTERNATE' RETURN -- Action: Break Footer 0 [Before Generate] -- Break Footer Shape PROPERTY BreakFooter_Shape_01 BRUSH_STYLE 'B_DIAGONAL' PROPERTY BreakFooter_Shape_01 PEN_STYLE 'DASH_DOT_DOT' RETURN -- Action: Report Footer [Before Generate] -- Report Footer Shape PROPERTY ReportFooter_Shape_01 BRUSH_STYLE 'SOLID' PROPERTY ReportFooter_Shape_01 PEN_STYLE 'DASH_DOT' RETURN For your viewing pleasure, here is a report that illustrates the use of new BRUSH_STYLE and PEN_STYLE properties of Shape control. http://www.razzak.com/tips/InvoiceSummary_Brush_Style_Pen_Style.pdf In addition, notice the feature of designing a custom "Cover Page" and Page Header and Page Footer options, not to mention the compact size of PDF document using R:BASE eXtreme 9.1. Have fun implementing BRUSH_STYLE/PEN_STYLE properties in Reports! Very Best R:egards, Razzak.
