At 03:03 PM 1/25/2008, Charles Parks wrote:
Is there a way to add a where clause for each series or do they
each need a different view?
I have a table structure
TodayDate
DaysInRange (Values: -14, 60, 180, 365)
Qty
I would like each DaysInRange value to be a different series
with the labels:TodayDate, x:TodayDate, y:Qty.
Would this take 4 views or is there a different way?
Charlie,
Technically, each series included in a single chart (.RBC) can
be associated with individual table or view.
Using the currently available versions of R:Charts 7.6 and 8.0.
you may dynamically change the associated table/view on demand,
using the additional parameter of "SERIES_TABLE[n] tableviewname".
-- Example 01:
The R:Chart file (Quarterly_DonutChart.RBC) is based on a
QuarterlySummary view in RRBYW14. To print this chart on a form,
the following command is used as "On Before Start" EEP.
-- On Before Start EEP in Forms
PLUGIN RCharts76.RBL +
FILENAME Quarterly_DonutChart.RBC +
|SAVE_TO_JPG Quarterly_DonutChart.jpg +
|IMAGE_WIDTH 324 +
|IMAGE_HEIGHT 244
SET VAR vImage = 'Quarterly_DonutChart.jpg'
RETURN
The results are displayed as:
http://www.rbase.com/rbg76/RChartsInForm_01.jpg
-- Example 02:
To use that exact Quarterly_DonutChart.RBC chart with a
different view QuarterlySummary07 in a different form in
RRBYW14, use the following command as "On Before Start" EEP.
-- On Before Start EEP in Forms
PLUGIN RCharts76.RBL +
FILENAME Quarterly_DonutChart.RBC +
|SAVE_TO_JPG Quarterly_DonutChart.jpg +
|IMAGE_WIDTH 324 +
|IMAGE_HEIGHT 244 +
|SERIES_TABLE[0] QuarterlySummary07
SET VAR vImage = 'Quarterly_DonutChart.jpg'
RETURN
The results are displayed as:
http://www.rbase.com/rbg76/RChartsInForm_02.jpg
-- Example 03:
The R:Chart file (Quarterly_BarChart.RBC) is based on a
QuarterlySummary view in RRBYW14. To print this chart in
reports, the following command is used as "Before Generate" EEP.
-- Before Generate EPP in Reports
PLUGIN RCharts76.RBL +
FILENAME Quarterly_BarChart.RBC +
|SAVE_TO_JPG Quarterly_BarChart.jpg +
|IMAGE_WIDTH 324 +
|IMAGE_HEIGHT 244
SET VAR vImage = 'Quarterly_BarChart.jpg'
RETURN
The results are displayed as:
http://www.rbase.com/rbg76/RChartsInReports01.pdf
-- Example 04:
To use that exact Quarterly_BarChart.RBC chart with a
different view QuarterlySummary07 in a different report
in RRBYW14, use the following command as "Before Generate"
EEP.
-- On Before Generate EEP in Reports
PLUGIN RCharts76.RBL +
FILENAME Quarterly_BarChart.RBC +
|SAVE_TO_JPG Quarterly_BarChart.jpg +
|IMAGE_WIDTH 324 +
|IMAGE_HEIGHT 244 +
|SERIES_TABLE[0] QuarterlySummary07
SET VAR vImage = 'Quarterly_BarChart.jpg'
RETURN
The results are displayed as:
http://www.rbase.com/rbg76/RChartsInReports02.pdf
Using the R:Chars 7.6 (Build: 7.6.3.30214) or R:Charts 8.0
(Build: 7.6.3.30214) you also have an added option to use
WHERE clause for any given series.
Imagine the possibilities!
Very Best R:egards,
Razzak.
