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.
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.

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.

>You have a couple of options.
>
>1) Use a PRG to link them, then output to one table. Base the report on the single table.
>2) Link the tables in Crystal Reports, then set the Location property of the Table object.
>
>The article on my website shows how to do this.
>
>
>>Hi,
>>
>>My application need to be flexible so that I can just distribute my
>>rpt file to my customer.
>>
>>However, my source file are all in *.dbf format which I had encountering some difficult in linking them using the smart link. In this case, I had two different dbf files in different location, how do I link them together.
>>
>>Plus, each dbf of the above file need to link to each other by three fields, but CR don't allow me to link them together.
>>
>>So, how do I link them together without hardcoding my database location, (so I think of using ODBC)
>>
>>Please kindly advise and help. thank you