Charles: This is something I have wanted for a long time, being able to print a chart and have a WHERE clause that allows you to select the data on the fly; however, TTBOMK this is not an option at this time. What I do is create a temporary table with the data I need, call the R:Charts plugin, and then delete the temporary table. It happens very fast and there is no noticeable lag in performance. Of course, when designing the chart, you will need to have a non-temporary table as the database cannot be in use when you access it from R:Charts. After your chart is designed and saved, you can delete the permanent table and go back to the temporary table. Another advantage of the temporary table is that different users can be using the same chart with different data. Javier, Javier Valencia, PE Sr. Project Manager Universal Asset Management, L.L.C. 801 Westchester Ave. Harrisonville, MO 64701 Phone: 816-887-4011 Fax: 816-887-1960 Cell: 913-915-3137 _____
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Charles Parks Sent: Friday, January 25, 2008 2:04 PM To: RBASE-L Mailing List Subject: [RBASE-L] - R:Chart Series Where Clause 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?
