Same Report called with different DB's

[cpscdave]

We have a live and devel version of a system thats intergrating with JasperServer.

Thusly we would like to be able to call the reports using either the devel database or the live databases with out having to have 2 versions of the report in JasperServer.

How can this be accomplished?
I tried adding a parameter to sepecify the database in the sql query eg

SELECT * FROM $P{DB}.table1

but it looks like its making the sql SELECT * FROM 'live_db'. and throws errors.

 

How can we get this to work???

Thanks

[cpscdave]

figured it out

by using

$!P(DB) it outputs live_db

if you use

$P{DB} it outputs 'live_db'

 

Post Edited by David Robertson at 11/26/08 23:23

[halfer]

If you want to call reports using an arbitrary connection, this is not supported directly in JasperServer at present. However I discovered a fairly elegant workaround that you may be interested in.