|
Re: A report to run on multiple DBs [message #498610 is a reply to message #498528] |
Tue, 17 November 2009 16:30 |
|
Trevor,
If the dbs all return the same columns you could write one and change
the dburl in the before open script of the datasource or use property
binding. You could add a parameter to decide which db. Another option
is to put all three in and reassign the dataset for reportItems in the
beforeFactory event.
To swap the dataset just use code like:
mytable = reportContext.getDesignHandle().findElement("mytable");
mytable.setProperty( "dataSet", "SecondDataSet" );
The table has to be named in the general properties.
For property binding you could add a dburl parameter and put this in the
for the jdbc url under the property binding tree item in the data source
editor
params["dburl"].value
Jason
TREVOR.HIGGINS@FINEOS.COM wrote:
> Hi,
> If I support a number of databases (three in total) and I want to write
> an identical report to run on each one, what is the best way to do this?
>
> 1) Create 3 independent reports with one datasource and dataset in each.
> Create chars/crosstab from the dataset columns. [Alot of repeated work
> as doing this 3 times]
> 2) Create 1 report with 3 datasources and 3 datasets. However, as the
> chart/crosstab are tied to a dataset, is this even possible?
> 3) Other?
>
> thanks for any input
|
|
|
Powered by
FUDForum. Page generated in 0.02631 seconds