Eclipse Community Forums: BIRT » Use multiple schema in a birt report

Home » Archived » BIRT » Use multiple schema in a birt report

Use multiple schema in a birt report [message #820613]

Wed, 14 March 2012 06:43

Eclipse User

I want change at runtime schema connection dynamically in a stored procedure call, like:

{call SCHEMA_NAME.SPNAME( ?) }

Where SCHEMA_NAME is definited at runtime

PS:
I'm using this code to set database connection:

 
IRunAndRenderTask task = engine.createRunAndRenderTask(design); 	 					  
		
task.getAppContext().put("OdaJDBCDriverPassInConnection", connection);

Re: Use multiple schema in a birt report [message #821032 is a reply to message #820613]

Wed, 14 March 2012 17:30

Eclipse User

Do you have the schema name in a parameter?
If so you could change it with property binding or a data set beforeOpen
script like:

this.queryText =
this.queryText.replaceAll("SCHEMA_NAME",params["myschema"].value"))

Jason

On 3/14/2012 6:43 AM, Frizz K wrote:
> I want change at runtime schema connection dynamically in a stored
> procedure call, like:
>
> {call SCHEMA_NAME.SPNAME( ?) }
> Where SCHEMA_NAME is definited at runtime
>
>
> PS: I'm using this code to set database connection:
>
>
> IRunAndRenderTask task = engine.createRunAndRenderTask(design);
> task.getAppContext().put("OdaJDBCDriverPassInConnection", connection);
>
>

Re: Use multiple schema in a birt report [message #824102 is a reply to message #821032]

Mon, 19 March 2012 05:04

Eclipse User

Ok, thank you very much!!

Previous Topic:	WebViewer.display(String, Browser, Map)
Next Topic:	Is it possible to create "n" GUI tables for "n" records within the database

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Jul 27 16:29:35 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter