[RBASE-L] - Re: R:Charts Plugin Clarification Needed

[Bruce A. Chitiea]

Razzak:

Excellent.  

Much appreciated,

Bruce Chitiea
SafeSectors, Inc.
909.238.9012 cell


-----Original Message-----
From: rbase-l@rbase.com [mailto:rbase-l@rbase.com] On Behalf Of A. Razzak
Memon
Sent: Thursday, February 26, 2015 6:09 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: R:Charts Plugin Clarification Needed

At 04:59 PM 2/26/2015, Bruce A. Chitiea wrote:

>The R:Charts Plugin has an option to change the chart's source table name.
>
>I'm hoping this allows loop-printing a common chart format through an 
>orderly series of source tables.
>
>SERIES_TABLE[n] - Where "n" is a "value" (presumably integer).
>
>The description states: "Change the table name for your chart (based on 
>0 to start)".
>
>Does this imply a series of source tables named literally: [ 0 | 1 | ...
>| n]?
>
>An appendage: [ Humpty_0 | Humpty_1 | ... | Humpty_n ]?
>
>Or is something else at play?


By design, each series used in R:Charts is associated with a source table or
view. The designated table or view is stored with the resulting R:BASE Chart
(.RBC) file.

However, there can be instances where you would like to recycle that cool
chart with exact same column names but a different table or view without
copying or re-designing a whole new chart.

Did you know that you can dynamically change the assigned source table or
view name for a chart already designed in R:Charts 9.5?

Using the latest versions and updates of R:BASE and R:Charts
9.5 for Windows, now you can use the additional parameter of
"SERIES_TABLE[n] tableviewname" to dynamically change the assigned table or
view name for any series used in R:Charts, where [n] represents the specific
table or view listed in the series.

-- Example 01:

The R:Chart file (Quarterly_DonutChart.RBC) is based on a QuarterlySummary
view in RRBYW18. To print this chart on a form, the following command is
used as "On Before Start"
EEP.

-- On Before Start EEP in Forms
    PLUGIN RCharts +
    FILENAME Quarterly_DonutChart.RBC +
    |SAVE_TO_JPG Quarterly_DonutChart.jpg +
    |IMAGE_WIDTH 324 +
    |IMAGE_HEIGHT 244
    SET VAR vImage = 'Quarterly_DonutChart.jpg'
    RETURN

-- Example 02:

To use that exact Quarterly_DonutChart.RBC chart with a different view
QuarterlySummary14 in a different form in RRBYW18, use the following command
as "On Before Start"
EEP.

-- On Before Start EEP in Forms
    PLUGIN RCharts +
    FILENAME Quarterly_DonutChart.RBC +
    |SAVE_TO_JPG Quarterly_DonutChart.jpg +
    |IMAGE_WIDTH 324 +
    |IMAGE_HEIGHT 244 +
    |SERIES_TABLE[0] QuarterlySummary14
    SET VAR vImage = 'Quarterly_DonutChart.jpg'
    RETURN

-- Example 03:

The R:Chart file (Quarterly_BarChart.RBC) is based on a QuarterlySummary
view in RRBYW18. To print this chart in reports, the following command is
used as "Before Generate"
EEP.

-- Before Generate EPP in Reports
    PLUGIN RCharts +
    FILENAME Quarterly_BarChart.RBC +
    |SAVE_TO_JPG Quarterly_BarChart.jpg +
    |IMAGE_WIDTH 324 +
    |IMAGE_HEIGHT 244
    SET VAR vImage = 'Quarterly_BarChart.jpg'
    RETURN

-- Example 04:

To use that exact Quarterly_BarChart.RBC chart with a different view
QuarterlySummary14 in a different report in RRBYW18, use the following
command as "Before Generate"
EEP.

-- On Before Generate EEP in Reports
    PLUGIN RCharts +
    FILENAME Quarterly_BarChart.RBC +
    |SAVE_TO_JPG Quarterly_BarChart.jpg +
    |IMAGE_WIDTH 324 +
    |IMAGE_HEIGHT 244 +
    |SERIES_TABLE[0] QuarterlySummary14
    SET VAR vImage = 'Quarterly_BarChart.jpg'
    RETURN

Hope that helps with the needed clarification you need.

Very Best R:egards,

Razzak.