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 06:43 Go to next message
Frizz K is currently offline 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);

Re: Use multiple schema in a birt report [message #821032 is a reply to message #820613] Wed, 14 March 2012 17:30 Go to previous messageGo to next message
Jason Weathersby is currently offline 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);
>
>
Re: Use multiple schema in a birt report [message #824102 is a reply to message #821032] Mon, 19 March 2012 05:04 Go to previous message
Frizz K is currently offline Frizz K
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: Sat Aug 30 02:39:39 EDT 2014

Powered by FUDForum. Page generated in 0.01581 seconds