Skip to main content


Eclipse Community Forums

      Home
Home » Archived » BIRT » Running Report against different copies of a database(How to register database at run time)
Running Report against different copies of a database [message #651453] Mon, 31 January 2011 00:52 Go to next message
Eclipse UserFriend
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
Re: Running Report against different copies of a database [message #651518 is a reply to message #651453] Mon, 31 January 2011 09:09 Go to previous messageGo to next message
Eclipse UserFriend
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.
Re: Running Report against different copies of a database [message #651897 is a reply to message #651518] Tue, 01 February 2011 17:44 Go to previous message
Eclipse UserFriend
Thanks Richard.
Previous Topic:BIRT update site referencing missing version of org.eclipse.emf.common?
Next Topic:Creating a dynamic start/end time parameter range
Goto Forum:
  


Current Time: Sun Jul 27 10:38:15 EDT 2025

Powered by FUDForum. Page generated in 0.04227 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly