Wednesday, April 4, 2007

Tip of the Day: Customizing CrossTab Grid Color in Reports

Supported Versions:

. R:BASE 7.6 for Windows (Build: 7.6.1.30404 or higher)
. R:BASE C/S:I 7.6 for Windows (Build: 7.6.1.30404 or higher)
. R:BASE Turbo V-8 for Windows (Build: 8.0.15.30404 or higher)

Did you know that you can customize the grid color of CrossTab
control in Reports?

In addition to customizing the CrossTab column and row titles,
now you may also customize the CrossTab grid color, if you wish.

Here's how:

01. Start RBG76, RBG76 (C/S:I) or RBG8.

02. CONNECT RRBYW10, RRBYW12 or RRBYW14.

03. Database Explorer | Reports | CrossTabReport | Design

04. Report Designer | Right-Click on CrossTabReport control
    and select Grid Color ...

    Select your favorite color and click on [OK] button.

05. Click on [Report Preview] option to preview report while
    in Report Designer.

06. Save the report and close Report Designer.

You may also use the PROPERTY command to dynamically change
the CrossTab grid color on demand.

    Syntax:

    PROPERTY CrossTabCompID GRIDCOLOR ColorName

    -- Example 01:
    PROPERTY CrossTab GRIDCOLOR 'MAROON'
    RETURN

    -- Example 02:
    PROPERTY CrossTab GRIDCOLOR 'GREEN'
    RETURN

Make sure to use above PROPERTY command as "Before Generate"
action in reports

Here's an example of Customized CrossTab Report in RRBYW14:
http://www.rbase.com/rbg76/CustomCrossTabReports.pdf

Enjoy!

Very Best R:egards,

Razzak.

Reply via email to