Hi,

Could you help me on this area as I having problem in pulling the required
data from different location consisting of dbf files. I want all the pulling
of data done either by passing it as recordset to the rpt file or using
sql query to pull all the data using ODBC visual foxpro drive, but had problem in this area. I don't want to restrict my pulling of data using
a PRG file else each rpt file need to had 01 PRG file, I want a generic
way to pull data where all rpt file can use to generate the data.

>Virusim -
>you should be able to take that system table and make changes to it for your clients - maybe have an admin function built into your app to manage this. You shouldn't have to recompile your app - just make your report picker completely data driven based on what's in the system table. This was your RPT filenames are NOT coded into the application, but instead reside only in an external table. Should be pretty straightforward la.
>
>I would suggest you have your CR files external - this way you can always add more or update your existing ones without a recompile of vfp app.
>>Hi,
>>
>>In order to implement flexible reporting option in my application,
>>I decide that I will only distribute these file to my customer side.
>>
>>01) rpt reporting files,
>>02) a system table to indicate my query and rpt filename
>>03) a query file to query all the data from my individual dbf file need by individual report file.
>>
>>On runtime, I only had a form with the CRviewer control which will
>>point to my rpt and query file to generate out the report selected by my customer.
>>
>>Is there a better way to implement the feature that I indicate above
>>as I don't want to code my rpt file into my application, hence making
>>my report flexible and adding of new report will be easy.
>>Can the above be done using RDC control ?
>>
>>Anyone had better ideal or way to achieve similar flexible report, please kindly advise me. Thank a lot.