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.
