|
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 |
|
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 |
|
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 |
|
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 |
|
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
>
>
>
>
>
|
|
|
|
Powered by
FUDForum. Page generated in 0.02923 seconds