>Hi,
>
>Thank for your advise, pls kindly assist me on the following issue below
>
>01) I can't use a PRG as I want the reporting feature to be flexible, so that I just distribute my rpt file and update the main system table with the new rpt filename, I want everything to be in the rpt file, so on runtime, it just pull all the data and show it to my customer.
>
>02) Linking the tables in CR, can I had all the condition and location setting pass to it by parameter, so that it is standalone as a rpt file.

All of this is accessable at runtime. It's pretty easy to change any of this.

>I hope of using ADO recordset to create a single table for reporting but
>it will make my report infexible as different reports had different dbf file
>location. Please kindly advise me on this issue.

I'm not sure what you're asking here.

>
>In short, I refer all the setting in the rpt file, making my report
>as flexible as possible. Please advise me on any thing to look out for
>if I want to implement it this way so that my reporting is flexible and can be use by my ohter customer with minimum customization.
>