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

Help

Home

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

Show: Today's Messages :: Show Polls :: Message Navigator

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

Wed, 14 March 2012 10:43

Frizz K

Messages: 18
Registered: March 2010

Junior Member

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);

Report message to a moderator

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

Wed, 14 March 2012 21:30

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

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);
>
>

Report message to a moderator