Liveware Publishing Support Forum

I am a new user and wondering about a few things with the reporting engine. ____First, is there a way to develop an exported report where the user only clicks on a file and the report exports? As far as I can tell, I must open the report in report designer and choose export then edit the export type and make sure to include the correct path to the file I want to export to. This is an awefull lot of steps for something someone does on demand several times a day. I know I can set up the scheduler to do the exports at designated times, but we need some on demand reports as well. With the process I set down above there is always the potential for an end-user to overwrite some critical data on the network. Additionally, I would like to set up data exports to be a part of a larger overall process that can happen with no user interaction. Please provide a solution or where I can find the information I need if possible. ______Second, the reporting engine works off a basic query to format the data. Sure R&R can do calculations at the report level...but what about the query level? What about sub-queries. Ok...I know I am asking a lot. We are using a third party application whose underlying data dictionary is foxpro. Unfortunately there is no query tool at all into that database. So I am using R&R to export the tables into Access format so I can then interact with them (ODBC is not an option for stability reasons). Often the use of subqueries is neccessary if you are trying to lay new or recoded variables into datasets and then report on what you find...then there is the notorious sorting and grouping that must be done once...and a calculation performed and then sorted and grouped again. These things don^t seem to be possible with R&R unless you set up an export procedure and then another report based on the export...then you have to do that the number of times you would need a sub-query. What a mess. Is there something I am missing here? I understand it^s a reporting engine and not RDBMS just want to make sure I am clear on it^s full functionality.____Thank you for any replies.

You can set up a runtime shortcut to do a one click export.__You need to create a text file with the values:__RI_REPORT=C: est estreport.rrw__RI_PRINTER=CSV__RI_OUTFILE=C: estoutput.csv____Then create a shortcut that passes the name of this text file to the runtime executable using the /T command switch.____C:R&RRRWRUN.EXE /TC:c: estinput.txt____If input.txt contains the above lines, the report testreport.rrw will be run and its output will be sent to the text data file output.csv____The only gotcha is that for band oriented exports (like text data and DBF/WKS) you cannot select the band to export via the text file. The default will be whatever was selected as the band type when the report was saved or if no explicit selection was made, a record band will be used.____For the second question, R&R does not support explicit sub-queries but there may be other ways to get what you want. If you could give me a real world example of a report you are trying to create, I could give you a better idea of the possibilities.______Kathleen__R&R Support