|
| Re: Pojo's and a scripted subreport [message #84988 is a reply to message #84940] |
Thu, 27 October 2005 20:47   |
|
Tom,
When you put
j = pojo.getEmployees().iterator()
in the data set 2 open, did you make pojo global?
pojo = i.next();
in dataset 1?
This looks like it should work.
Jason Weathersby
BIRT PMC
"Tom Stave" <tstave@bmtcarhaul.com> wrote in message
news:djraau$q97$1@news.eclipse.org...
>I am trying to create a sub-report using a scripted data source. I am
>having
> trouble understanding how I should write the scripts of my sub-report so
> that the data in my sub-report relates to the parent report.
>
> I am getting my scripted POJO but when I generate the report, I'm getting
> the same sub-report data with each parent entry.
>
> I am currently creating a table for the parent report with two detail
> lines.
> In the second detail line I create a second table for my sub-report. For
> sake of example and to keep it simple, lets say my POJO looks like this:
>
> public class Pojo {
> private String company ;
> private Set employees ;
>
> public String getCompany() {
> return company ;
> }
> public Set getEmployees() {
> return employees;
> }
> }
>
> I have two data sets, scriptSet1 and scriptSet2. The parent report Table
> is
> tied to scriptSet1 and the sub-report is tied to scriptSet2. In scriptSet1
> I
> have defined scripts for open and fetch.
>
> The open looks like this:
>
> df = new Packages.my.package.com.DataFactory();
> pojoSet = df.getPojoSet() ;
> i = pojoSet.iterator();
>
> The fetch looks like this:
>
> if ( !i.hasNext() ){
> return false ;
> }
> var pojo = i.next();
> row["Company"] = pojo.getCompany() ;
> j = pojo.getEmployees().iterator() ; // I have tried this in the open of
> scriptSet2 but have the same result.
> return true ;
>
> My scriptSet2 has a fetch statement that looks as follows:
>
> if ( !j.hasNext() ){
> return false ;
> }
> employee = j.next();
> row["Name"] = employee.getName() ;
> return true ;
>
> When executing this report, I will get the employees for my last Company
> printed for all companies. I am assuming I've overlooked some basic
> concept.
> Any suggestions would be appreciated.
> Thanks
>
>
|
|
|
|
| Re: Pojo's and a scripted subreport [message #85187 is a reply to message #85003] |
Fri, 28 October 2005 12:25 |
 Tom Stave
Messages: 14
Registered: July 2009 |
Junior Member |
|
|
In my haste to leave work yesterday, I should have looked at my data closer.
I still have the same problem.
I've ran several test on my POJO access and the data appears to returning
correctly, however, I am still getting the same sub-report data for each
main report item.
"Tom Stave" <tstave@bmtcarhaul.com> wrote in message
news:djrfjp$1na$1@news.eclipse.org...
> That did the trick -- Thanks
>
> "Jason Weathersby" <jweathersby@actuate.com> wrote in message
> news:djreca$vqt$1@news.eclipse.org...
> > Tom,
> >
> > When you put
> > j = pojo.getEmployees().iterator()
> > in the data set 2 open, did you make pojo global?
> > pojo = i.next();
> > in dataset 1?
> > This looks like it should work.
> >
> > Jason Weathersby
> > BIRT PMC
> >
> >
> >
> > "Tom Stave" <tstave@bmtcarhaul.com> wrote in message
> > news:djraau$q97$1@news.eclipse.org...
> > >I am trying to create a sub-report using a scripted data source. I am
> > >having
> > > trouble understanding how I should write the scripts of my sub-report
so
> > > that the data in my sub-report relates to the parent report.
> > >
> > > I am getting my scripted POJO but when I generate the report, I'm
> getting
> > > the same sub-report data with each parent entry.
> > >
> > > I am currently creating a table for the parent report with two detail
> > > lines.
> > > In the second detail line I create a second table for my sub-report.
For
> > > sake of example and to keep it simple, lets say my POJO looks like
this:
> > >
> > > public class Pojo {
> > > private String company ;
> > > private Set employees ;
> > >
> > > public String getCompany() {
> > > return company ;
> > > }
> > > public Set getEmployees() {
> > > return employees;
> > > }
> > > }
> > >
> > > I have two data sets, scriptSet1 and scriptSet2. The parent report
Table
> > > is
> > > tied to scriptSet1 and the sub-report is tied to scriptSet2. In
> scriptSet1
> > > I
> > > have defined scripts for open and fetch.
> > >
> > > The open looks like this:
> > >
> > > df = new Packages.my.package.com.DataFactory();
> > > pojoSet = df.getPojoSet() ;
> > > i = pojoSet.iterator();
> > >
> > > The fetch looks like this:
> > >
> > > if ( !i.hasNext() ){
> > > return false ;
> > > }
> > > var pojo = i.next();
> > > row["Company"] = pojo.getCompany() ;
> > > j = pojo.getEmployees().iterator() ; // I have tried this in the open
of
> > > scriptSet2 but have the same result.
> > > return true ;
> > >
> > > My scriptSet2 has a fetch statement that looks as follows:
> > >
> > > if ( !j.hasNext() ){
> > > return false ;
> > > }
> > > employee = j.next();
> > > row["Name"] = employee.getName() ;
> > > return true ;
> > >
> > > When executing this report, I will get the employees for my last
Company
> > > printed for all companies. I am assuming I've overlooked some basic
> > > concept.
> > > Any suggestions would be appreciated.
> > > Thanks
> > >
> > >
> >
> >
>
>
|
|
|
|
| Re: Pojo's and a scripted subreport [message #85310 is a reply to message #84940] |
Fri, 28 October 2005 15:39 |
|
Tom,
I did a little more digging on this one.
This isssue is that Data Set1 gets read completely before doing Data Set 2.
So this line j = pojo.getEmployees().iterator() will alway return the last
one.
What would be ideal to do is have a method in the pojo that accepts the
company name as a parameter and returns a Set. Then in the outer table in
one of the data controls set its value to something like this in the
expression builder for a data control.
tmptest = row["companyname"];
row["companyname"];
This will display the company name and set the tmptest variable to the
company name.
Then in the open method of Data Set 2 make your call like.
j = pojo.getEmplyforCompany(tmptest).iterator();
I am attaching an example that does something similar with two scripted ds.
Look at open and fetch on both DS. Also look at the Expression builder for
the data control under OuterCount.
Hope this helps
Jason Weathersby
BIRT PMC
"Tom Stave" <tstave@bmtcarhaul.com> wrote in message
news:djraau$q97$1@news.eclipse.org...
>I am trying to create a sub-report using a scripted data source. I am
>having
> trouble understanding how I should write the scripts of my sub-report so
> that the data in my sub-report relates to the parent report.
>
> I am getting my scripted POJO but when I generate the report, I'm getting
> the same sub-report data with each parent entry.
>
> I am currently creating a table for the parent report with two detail
> lines.
> In the second detail line I create a second table for my sub-report. For
> sake of example and to keep it simple, lets say my POJO looks like this:
>
> public class Pojo {
> private String company ;
> private Set employees ;
>
> public String getCompany() {
> return company ;
> }
> public Set getEmployees() {
> return employees;
> }
> }
>
> I have two data sets, scriptSet1 and scriptSet2. The parent report Table
> is
> tied to scriptSet1 and the sub-report is tied to scriptSet2. In scriptSet1
> I
> have defined scripts for open and fetch.
>
> The open looks like this:
>
> df = new Packages.my.package.com.DataFactory();
> pojoSet = df.getPojoSet() ;
> i = pojoSet.iterator();
>
> The fetch looks like this:
>
> if ( !i.hasNext() ){
> return false ;
> }
> var pojo = i.next();
> row["Company"] = pojo.getCompany() ;
> j = pojo.getEmployees().iterator() ; // I have tried this in the open of
> scriptSet2 but have the same result.
> return true ;
>
> My scriptSet2 has a fetch statement that looks as follows:
>
> if ( !j.hasNext() ){
> return false ;
> }
> employee = j.next();
> row["Name"] = employee.getName() ;
> return true ;
>
> When executing this report, I will get the employees for my last Company
> printed for all companies. I am assuming I've overlooked some basic
> concept.
> Any suggestions would be appreciated.
> Thanks
>
>
|
|
|
| Re: Pojo's and a scripted subreport [message #85415 is a reply to message #85310] |
Fri, 28 October 2005 17:30 |
Tom Stave
Messages: 14
Registered: July 2009 |
Junior Member |
|
|
Thanks Jason!
Using a variation of your comments and my earlier example I came up with the
following which seems to work.
I created a new output variable in my scriptSet1 of type ANY and named
"StoreSet". I only use it for storage, I won't display it.
I kept my open for scriptSet1 the same, but I added the following to the
fetch statement:
row["StoreSet"] = pojo.getEmployees() ;
So the fetch looks like this:
if ( !i.hasNext() ){
return false ;
}
var pojo = i.next();
row["StoreSet"] = pojo.getEmployees() ;
row["Company"] = pojo.getCompany() ;
return true ;
When displaying my company name, using expression builder I added the
following:
empSet = row["StoreSet"];
row["companyname"];
My scriptSet2 fetch remains the same, but the open looks like this:
j=empSet.iterator() ;
This appears to work. But if I've thought that before. So if you see
anything I missed please let me know. If not, I hope this helps someone
else.
Thanks again.
"Jason Weathersby" <jweathersby@actuate.com> wrote in message
news:djtgmh$fen$1@news.eclipse.org...
> Tom,
> I did a little more digging on this one.
> This isssue is that Data Set1 gets read completely before doing Data Set
2.
> So this line j = pojo.getEmployees().iterator() will alway return the
last
> one.
> What would be ideal to do is have a method in the pojo that accepts the
> company name as a parameter and returns a Set. Then in the outer table in
> one of the data controls set its value to something like this in the
> expression builder for a data control.
>
> tmptest = row["companyname"];
> row["companyname"];
>
> This will display the company name and set the tmptest variable to the
> company name.
> Then in the open method of Data Set 2 make your call like.
>
> j = pojo.getEmplyforCompany(tmptest).iterator();
>
> I am attaching an example that does something similar with two scripted
ds.
> Look at open and fetch on both DS. Also look at the Expression builder
for
> the data control under OuterCount.
>
> Hope this helps
>
> Jason Weathersby
> BIRT PMC
>
>
>
>
>
> "Tom Stave" <tstave@bmtcarhaul.com> wrote in message
> news:djraau$q97$1@news.eclipse.org...
> >I am trying to create a sub-report using a scripted data source. I am
> >having
> > trouble understanding how I should write the scripts of my sub-report so
> > that the data in my sub-report relates to the parent report.
> >
> > I am getting my scripted POJO but when I generate the report, I'm
getting
> > the same sub-report data with each parent entry.
> >
> > I am currently creating a table for the parent report with two detail
> > lines.
> > In the second detail line I create a second table for my sub-report. For
> > sake of example and to keep it simple, lets say my POJO looks like this:
> >
> > public class Pojo {
> > private String company ;
> > private Set employees ;
> >
> > public String getCompany() {
> > return company ;
> > }
> > public Set getEmployees() {
> > return employees;
> > }
> > }
> >
> > I have two data sets, scriptSet1 and scriptSet2. The parent report Table
> > is
> > tied to scriptSet1 and the sub-report is tied to scriptSet2. In
scriptSet1
> > I
> > have defined scripts for open and fetch.
> >
> > The open looks like this:
> >
> > df = new Packages.my.package.com.DataFactory();
> > pojoSet = df.getPojoSet() ;
> > i = pojoSet.iterator();
> >
> > The fetch looks like this:
> >
> > if ( !i.hasNext() ){
> > return false ;
> > }
> > var pojo = i.next();
> > row["Company"] = pojo.getCompany() ;
> > j = pojo.getEmployees().iterator() ; // I have tried this in the open of
> > scriptSet2 but have the same result.
> > return true ;
> >
> > My scriptSet2 has a fetch statement that looks as follows:
> >
> > if ( !j.hasNext() ){
> > return false ;
> > }
> > employee = j.next();
> > row["Name"] = employee.getName() ;
> > return true ;
> >
> > When executing this report, I will get the employees for my last Company
> > printed for all companies. I am assuming I've overlooked some basic
> > concept.
> > Any suggestions would be appreciated.
> > Thanks
> >
> >
>
>
>
|
|
|
Powered by
FUDForum. Page generated in 0.04066 seconds
] 
Search
Help
Register
Login
Home
