Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » 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 05:52 Go to next message
Chris  is currently offline 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
Re: Running Report against different copies of a database [message #651518 is a reply to message #651453] Mon, 31 January 2011 14:09 Go to previous messageGo to next message
Richard A. Polunsky is currently offline Richard A. Polunsky
Messages: 199
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.
Re: Running Report against different copies of a database [message #651897 is a reply to message #651518] Tue, 01 February 2011 22:44 Go to previous message
Chris  is currently offline Chris
Messages: 47
Registered: September 2010
Member
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 Sep 21 06:07:50 GMT 2014

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

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