please help me.... CR with DSN [RESOLVED]

[satyarao]

Hai...

I have am working with CR8.5, Access2000 and VB6.0...

it is Client/Server project...

I designed.... all reports... based on one system DSN in one of the system... which... represents... D:\Fabric\Fabric.mdb...

my DSN name is "FabricDSN"... while installing my project in another network... how to proceed with the DSN...

while calling the reports... i want to display them by getting the data from required folder.... (here one thing is to be discussed... i am having... multiple databases.... in the server.... like Fabric03.mdb, Fabric04.mdb, Fabric02.mdb... so on)

while working with my project, at the starting i will select my own... firm... , i mean to which database i want to connect...

1. Now what my problem is;... I have to get my reports... by connecting... to the required database.... (since... all databases, tables, fields.... are identical)?

2. How to change the data source of the crystal report.... at runtime... and how to refresh...it at the same time...?

3. is there any way to change the data source of DSN at runtime...from vb?


I think it is clear....

thanks in advance...