Eclipse Community Forums: BIRT » How to switch datasource using javascript?

Help

Home

Home » Archived » BIRT » How to switch datasource using javascript?

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

How to switch datasource using javascript? [message #1061295]

Fri, 31 May 2013 04:58

Rina Tan

Messages: 4
Registered: May 2013

Junior Member

I have a report using datasources from a library. Now I want to assign datasource for my dataset at runtime based on a parameter. How can I do it using javascript from report design?

Thanks

Report message to a moderator

Re: How to switch datasource using javascript? [message #1061527 is a reply to message #1061295]

Sun, 02 June 2013 03:02

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

Is the other dataSource in the library as well? Can you explain the situation some more?

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: How to switch datasource using javascript? [message #1061775 is a reply to message #1061527]

Mon, 03 June 2013 21:56

Rina Tan

Messages: 4
Registered: May 2013

Junior Member

yes, the othere datasource is in library as well. The report that I am working on has two data sources that added from library. There's a parameter on the report indicates which data source the data set should use at runtime. At begining I thought there should be a java script function 'setDataSource()' or something of data set, but I only found getDataSource(), there's no setDataSource(). Can anyone help me with it?

Thanks

Report message to a moderator

Re: How to switch datasource using javascript? [message #1062494 is a reply to message #1061775]

Sat, 08 June 2013 05:41

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

Try something like this in the beforeOpen of the dataSet:

this.setExtensionProperty("dataSource","otherDataSourceName");

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: How to switch datasource using javascript? [message #1063268 is a reply to message #1062494]

Wed, 12 June 2013 21:22

Rina Tan

Messages: 4
Registered: May 2013

Junior Member

This doesn't work. Any other idea?

Report message to a moderator

Re: How to switch datasource using javascript? [message #1063276 is a reply to message #1063268]

Wed, 12 June 2013 21:53

Rina Tan

Messages: 4
Registered: May 2013

Junior Member

I think I found a solution. In initialize of report add this reportContext.getDesignHandle().getElementByID("idOfDataSetElement").setDataSource("dataSourceName");

Report message to a moderator