Eclipse Community Forums: BIRT » Running Report against different copies of a database

Home » Archived » BIRT » Running Report against different copies of a database(How to register database at run time)

Show: Today's Messages :: Show Polls :: Message Navigator

Running Report against different copies of a database [message #651453]

Mon, 31 January 2011 05:52

Chris

Messages: 47
Registered: September 2010

Member

Hi,
I need to create reports where in development a development database is used. When deployed to production the database name (only) will be differant. I need to deploy the same report to both differant machines and/ or differant environments. We have the situation where each client has their own copies of the database - a development, a test, a support and production each of which have unique names. eg AJAX_dev, AJAX_test, AJAX_support and AJAX_prod for comany AJAX and a similar set for ACME say. All of these on the same server.

How do you set the report up so that as you run the report it selects the database? All reports are run via run-time BIRT to PDF. There is no database name field etc here

Thanks in advance
Chris

Report message to a moderator

Re: Running Report against different copies of a database [message #651518 is a reply to message #651453]

Mon, 31 January 2011 14:09

Richard A. Polunsky

Messages: 212
Registered: July 2009
Location: Houston TX

Senior Member

That's the classic case of using a RPTLIBRARY file. Define the database connection in the RPTLIBRARY file, then within your report USE the RPTLIBRARY file and insert the database connection from there.

In your two environments (DEV and PROD), modify the RPTLIBRARY file to point to the correct database. That way the same RPTDESIGN file will just look at the RPTLIBRARY connection and wind up going to the correct database server.

Report message to a moderator