Michael: To add to the current discussion. On item No.1, I have R:Charts and R:Base opened simultaneously and when I need to modify a chart, I DISConnect from the database, work on the chart, close the chart and CONnect to the database again...not a great solution but the best available under the current restrictions...at least you do not have to open and close R:Base. No. 3. Once the chart is created, you no longer need to have R:Charts open; what I do is delete the original table on which the chart is based and then generate a temporary table with the desired data before the charts is called from a form or report. This way your security is implemented at the user level by allowing the user to have/not have access to the code that generates the temporary table and calls the chart, when the session is over the temporary table is gone. No. 2. It sure would be nice to have the capability of passing a WHERE clause as well as other parameters such as titles, axis names, legend, etc preferably through global variables or command line options; in my ideal scenario, charts would be run pretty much the way reports and forms are run:
Chart my_chart WHERE my_condition, order by my_order clause options | all the options R:Charts is still in its infancy so, I believe that these features will be eventually implemented. I have an application in which the chart is located within a form and based on variables selected from drop down and date variables, the temporary tables is generated on the fly whenever a variable changes and the chart refreshed; it works rather well... Javier, Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Michael Moser Sent: Sunday, March 20, 2005 1:59 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: R:Charts Chart based on rows instead of data values Thanks Sami and Esbjorn, I was able to get the charts I wanted using a "group by" view. That works fine. But my objective is to add charts to a system that does have passwords so I am concerned about Esbjorn's experience in that environment. It seems that 3 reasonable enhancements to the basick R:Charts would be: 1. ability to use R:Charts while connected with R:Base (Sami - based on your comments - I am guessing that there is some way to access charts from R:Base once they have been created, I just have not figured that part out yet.) 2. The ability to pass "Where" conditions as part of the chart. 3. The ability to set users to deal with R:Base security implementations. Thanks for your help. If I discover anything I will post. Best regards, Michael Michael Moser EXAQ Micro Services www.exaq.com Phone: 916-966-8313 Fax: 916-966-8313 >> Esbjorn
