Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Use multiple schema in a birt report
Use multiple schema in a birt report [message #820613] Wed, 14 March 2012 10:43 Go to next message
Frizz K is currently offline Frizz KFriend
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);

Re: Use multiple schema in a birt report [message #821032 is a reply to message #820613] Wed, 14 March 2012 21:30 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
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);
>
>
Re: Use multiple schema in a birt report [message #824102 is a reply to message #821032] Mon, 19 March 2012 09:04 Go to previous message
Frizz K is currently offline Frizz KFriend
Messages: 18
Registered: March 2010
Junior Member
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:
  


Current Time: Mon Dec 22 06:22:38 GMT 2014

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

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