Joined: 25 Jun 2010
Location: India
Online Status: Offline
Posts: 12
Topic: Dynamic Database Connection Posted: 07 Jul 2010 at 8:43pm
Hi,
I need to develop a report which firstly uses a query the result of which is the name of a database.Based on the result, the report will connect to that database and fetch tables.
I dont know how to implement this feature.Please help me out.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Posted: 08 Jul 2010 at 3:13am
you can't in CR...
CR only reads data, it does not act on what it has read to fetch more data. You can accomplish the same thing, if you have an application to call the report by having the application get the data from the correct source and pushing it to the report, or you can have your use alter the DSN to point to the correct datasource, but CR can't do it for you.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum