Eclipse Community Forums: BIRT » How to create subreport within birt report using scripted dataset

Home » Eclipse Projects » BIRT » How to create subreport within birt report using scripted dataset(How to create subreport within birt report using scripted dataset)

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

How to create subreport within birt report using scripted dataset [message #890512]

Fri, 22 June 2012 13:23

Amit akvhbti606@gmail.com

Messages: 4
Registered: June 2012

Junior Member

Hi all,
i am new in birt report.i am creating a subreport using scripted data source(java object).
here i am creating two dataset...one for teams and other for teams detail.
Like
1:Teams(teamId)
2:Reports(Date,Day).

Teams dataset gives the list of team Id ....which is perfectly fine

now i want this teamId should be pass to reports dataset script to calculate the reports(date,day) based on teamId. so this is like subreporting concept...so i implement it like that...

But on binding Reports(Date,Day) table to Teams(teamId) i facing a problem,...

and i also try to handle it in another way in like...
IN REPORTS SCRIPT :
tsmReportClass = new Packages.com.maven.tsm.action.TsmReportAction();
:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
monthName = params['monthName'];
teamId = params['groupId'];{which is i require from Teams dataset's teamId}
unAssignDates = tsmReportClass.getUnAssignProjectsDatesForGroup(teamId,monthName);
totalrows = unAssignDates.size();
currentrow = 0;
:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
method taking two parameter monthName which i got it from UI,
and teamId also got from UI but with value "all" means i want to see the report of all teams...so we have to change it at open script page ..as i m trying to do...

can anybody help me to resolve this problem
i also attached screen of it
thanks in advance

Attachment: issue.odt
(Size: 163.60KB, Downloaded 245 times)

Report message to a moderator

Re: How to create subreport within birt report using scripted dataset [message #890591 is a reply to message #890512]

Fri, 22 June 2012 16:00

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

You can use an input parameter for the scripted data set that is nested.
Take a look at the attached example. Two maps are loaded up in the
before factory for sample data. The nested dataset gets its value from
the outer table and does a lookup in the inner map using an inputParameter.

Jason

On 6/22/2012 9:24 AM, Amit akvhbti606@xxxxxxxx wrote:
> Hi all,
> i am new in birt report.i am creating a subreport using scripted data source(java object).
> here i am creating two dataset...one for teams and other for teams detail.
> Like
> 1:Teams(teamId)
> 2:Reports(Date,Day).
>
> Teams dataset gives the list of team Id ....which is perfectly fine
>
> now i want this teamId should be pass to reports dataset script to calculate the reports(date,day) based on teamId. so this is like subreporting concept...so i implement it like that...
>
> But on binding Reports(Date,Day) table to Teams(teamId) i facing a problem,...
>
> and i also try to handle it in another way in like...
> IN REPORTS SCRIPT :
> tsmReportClass = new Packages.com.maven.tsm.action.TsmReportAction();
> :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
> monthName = params['monthName'];
> teamId = params['groupId'];{which is i require from Teams dataset's teamId}
> unAssignDates = tsmReportClass.getUnAssignProjectsDatesForGroup(teamId,monthName);
> totalrows = unAssignDates.size();
> currentrow = 0;
> :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
> method taking two parameter monthName which i got it from UI,
> and teamId also got from UI but with value "all" means i want to see the report of all teams...so we have to change it at open script page ..as i m trying to do...
>
>
> can anybody help me to resolve this problem
> i also attached screen of it
> thanks in advance
>
>
>
>
>