Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » How to create subreport within birt report using scripted dataset(How to create subreport within birt report using scripted dataset)
How to create subreport within birt report using scripted dataset [message #890512] Fri, 22 June 2012 13:23 Go to next message
Amit akvhbti606@gmail.com is currently offline Amit akvhbti606@gmail.comFriend
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 113 times)
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 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
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
>
>
>
>
>
Re: How to create subreport within birt report using scripted dataset [message #890595 is a reply to message #890512] Fri, 22 June 2012 16:00 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
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
>
>
>
>
>
Re: How to create subreport within birt report using scripted dataset [message #890598 is a reply to message #890512] Fri, 22 June 2012 16:00 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
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
>
>
>
>
>
Re: How to create subreport within birt report using scripted dataset [message #890601 is a reply to message #890512] Fri, 22 June 2012 16:00 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
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
>
>
>
>
>
Re: How to create subreport within birt report using scripted dataset [message #891507 is a reply to message #890601] Mon, 25 June 2012 06:19 Go to previous message
Amit akvhbti606@gmail.com is currently offline Amit akvhbti606@gmail.comFriend
Messages: 4
Registered: June 2012
Junior Member
Thanks a lot "JASON"

Now i resolved the problem from your help...
Previous Topic:How to hide the first line in cross table
Next Topic:Security access
Goto Forum:
  


Current Time: Mon Dec 22 16:31:25 GMT 2014

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

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