Dynamic Database Connection

[czupet]

I have MS Access database report and several dozen MS Access databases, each Database is named like 1234,5678, 4444, all the same layout.

I don't what to copy and maintain the same report for each database, is there a way to create one report and have user enter a number as a parameter and then dynamically create a connection to the database in the report?

 

Thank You

 

Peter

[AnjumAbbas]

Create a parameter to pass in the database name eg  $P{databaseName} then use it in a query for example using the $P!{databaseName} with the exclamation mark which means its a dynamic parameter.

Anjum

[vaibhav.lather]

yes anjumAbbas is right pass parameter . here is example code

        JRDesignQuery query = new JRDesignQuery();
        query.setText("SELECT * FROM Address $P!{OrderByClause}");
        jasperDesign.setQuery(query);
   

or u can set this type of query in query editor.

 

[czupet]

But how do you create the dynamic connection to the database?

for example:

I have 2 DSNs in my ODBC manager both for Access Database

1) DB1234 - It's pointing to C:Databases12345.MDB

2) DB5678 - It's poiting to  C:Databases5678.MDB

Both databases have the same table names and same layout

I have 1 report and I want a user to run the report get a prompt for the number and if user enters 1234 the report will use DB1234 DSN and if user enters 5678 the report will use DB5678 DSN.

Is this possible ?

 

 

[rohit_chawla36]

I am using ireort designer 5.5.0 for generating jasper reports. I am having similar requirements(as user czupet had) where I have to select the database attributes dynamically such as database host name, user id, password etc based on the user input say local DB or dev DB. How this can be acheived using ireport designer? Your suggestions are appreciated.

 

Thanks.