Eclipse Community Forums: BIRT » Dynamic data source based on parameter

Help

Home

Home » Archived » BIRT » Dynamic data source based on parameter(Dynamic data source based on parameter)

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

Dynamic data source based on parameter [message #1153412]

Thu, 24 October 2013 15:44

sudheer kumar

Messages: 11
Registered: September 2013

Junior Member

Hi I have two datasets namely in the library and belows are the names for the dataset
1) wesservice dataset 2) Dataset.

Is there is any way that we can call based on parameters i want to call the dataset.

IF i pass pdataset is parameter and if the value is "Web" it has to call "webservice dataset" and if i pass "data" it has call dataset dynamically..

Please let us know if any one have written how to call based on the parameters it has to read different dataset.

How we can achieve the above scenario what methods we can call and pls share some sample of rpt design.

thanks in advance

Report message to a moderator

Re: Dynamic data source based on parameter [message #1164050 is a reply to message #1153412]

Thu, 31 October 2013 11:55

donino donino

Messages: 183
Registered: July 2011

Senior Member

A way to do this would be to drop elements in the report design in the "beforeFactory" event.

For example we create two named tables, each of them bound to their respective dataset, and depending on a parameter value we drop the appropriate one. Something like:

var webservice= reportContext.getReportRunnable().designHandle.getDesignHandle().findElement("webservice");
var simpledataset= reportContext.getReportRunnable().designHandle.getDesignHandle().findElement("simpledataset");

if (params["source"]=="webservice"){
  simpledataset.drop();
}else{
  webservice.drop();
}

Report message to a moderator

Previous Topic:	Localize drill through tooltip text
Next Topic:	can't suppress page breaks

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 25 21:22:55 GMT 2023

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter