You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Al Byers <by...@automationgroups.com> on 2010/07/29 02:00:03 UTC
OFBiz data sources for BIRT
I do not want to use SQL to define my reports in BIRT as I do not
think I can get the performance that I need. Are there other options
that are more OFBiz-centric than writing Mysql stored procedures.
Thanks,
-Al
Re: OFBiz data sources for BIRT
Posted by Santosh Malviya <sa...@gmail.com>.
Hello Byers,
I didn't try it but if you want to pass a list then you have to put the list
into the birtParameters and then iterate that list in fetch method of
rptdesign.
--
Thanks and Regards
Santosh Malviya
On Thu, Jul 29, 2010 at 11:29 AM, Al Byers <by...@automationgroups.com>wrote:
> Santosh,
>
> Thank you, that was extremely helpful. Do you think the concept can be
> extended to passing in a list of rows as birtParameters?
>
> -Al
>
> On Wed, Jul 28, 2010 at 11:45 PM, Santosh Malviya
> <sa...@gmail.com> wrote:
> > Hello Byers,
> >
> > Inline.............
> >
> > On Thu, Jul 29, 2010 at 10:11 AM, Al Byers <byersa@automationgroups.com
> >wrote:
> >
> >> Thanks Santosh and Hans. Please see questions below.
> >>
> >> On Wed, Jul 28, 2010 at 9:57 PM, Santosh Malviya
> >> <sa...@gmail.com> wrote:
> >> > Hello Byers,
> >> >
> >> > You can also use groovy for retrieving data and put them in
> >> birtParameters
> >> > map and pass the map to rptdesign or else you can get data in
> rptdesign
> >> > itself.
> >>
> >> I am familiar with setting birtParameters as input to sql query
> >> statements, but you are saying that I could pass in entire datasets?
> >> Could you direct me to anything that explains how to tell birt to use
> >> that parameter for the dataset?
> >>
> >
> > Consider following example: -
> > If I want to show firstName and lastName in rptdesign then I'll do
> following
> > in groovy
> > birtParameters = [];
> > person = delegator.findOne("Person", [partyId : partyId], false);
> > firstName = person.firstName;
> > lastName = person.lastName;
> >
> > birtParameters.firstName = firstName;
> > birtParameters.lastName = lastName;
> > request.setAttribute("birtParameters", birtParameters);
> >
> > In rptdesign I have to do following:
> >
> > in open method: -
> >
> > firstName = params["firstName"].value;
> > lastName = params["lastName"].value;
> >
> > in fetch method: -
> >
> > row["firstName"] = firstName;
> > row["lastName"] = lastName;
> >
> > make sure datasets are same as firstName and lastName.
> >
> > HTH
> >
> >>
> >> >
> >> > --
> >> > Thanks and Regards
> >> > Santosh Malviya
> >> >
> >> > On Thu, Jul 29, 2010 at 6:35 AM, Hans Bakker
> >> > <ma...@antwebsystems.com>wrote:
> >> >
> >> >> You can retrieve the data with minilanguage....
> >> >> examples in the system.
> >>
> >> Are you saying that there are examples in the system of where the
> >> minilanguage is used to retrieve data and that data is then passed to
> >> a birt report? If that is the case can anyone help me find those
> >> examples; I looked for all instances of "birt" but not sure that would
> >> have helped me find it.
> >>
> >> >>
> >> >> or look in the ofbiz help index, there is a chapter on birt.
> >>
> >> I had found a chapter on how to set up birt and how to setup a SQL
> >> based data source. Do you know if there is help content that talks
> >> about using other data sources or was that probably the chapter you
> >> were thinking of?
> >>
> >> Thanks again,
> >>
> >> -Al
> >>
> >> >>
> >> >> Regards,
> >> >> Hans
> >> >>
> >> >>
> >> >> --
> >> >> Ofbiz on twitter: http://twitter.com/apache_ofbiz
> >> >> Myself on twitter: http://twitter.com/hansbak
> >> >> Antwebsystems.com <http://twitter.com/hansbak%0AAntwebsystems.com>:
> >> >> Quality services for competitive rates.
> >> >>
> >> >> On Wed, 2010-07-28 at 18:00 -0600, Al Byers wrote:
> >> >> > I do not want to use SQL to define my reports in BIRT as I do not
> >> >> > think I can get the performance that I need. Are there other
> options
> >> >> > that are more OFBiz-centric than writing Mysql stored procedures.
> >> >> >
> >> >> > Thanks,
> >> >> >
> >> >> > -Al
> >> >>
> >> >> --
> >> >> Ofbiz on twitter: http://twitter.com/apache_ofbiz
> >> >> Myself on twitter: http://twitter.com/hansbak
> >> >> Antwebsystems.com <http://twitter.com/hansbak%0AAntwebsystems.com>:
> >> >> Quality services for competitive rates.
> >> >>
> >> >>
> >> >
> >>
> >
> >
> >
> > --
> > Thanks and Regards
> > Santosh Malviya
> >
>
Re: OFBiz data sources for BIRT
Posted by Al Byers <by...@automationgroups.com>.
Santosh,
Thank you, that was extremely helpful. Do you think the concept can be
extended to passing in a list of rows as birtParameters?
-Al
On Wed, Jul 28, 2010 at 11:45 PM, Santosh Malviya
<sa...@gmail.com> wrote:
> Hello Byers,
>
> Inline.............
>
> On Thu, Jul 29, 2010 at 10:11 AM, Al Byers <by...@automationgroups.com>wrote:
>
>> Thanks Santosh and Hans. Please see questions below.
>>
>> On Wed, Jul 28, 2010 at 9:57 PM, Santosh Malviya
>> <sa...@gmail.com> wrote:
>> > Hello Byers,
>> >
>> > You can also use groovy for retrieving data and put them in
>> birtParameters
>> > map and pass the map to rptdesign or else you can get data in rptdesign
>> > itself.
>>
>> I am familiar with setting birtParameters as input to sql query
>> statements, but you are saying that I could pass in entire datasets?
>> Could you direct me to anything that explains how to tell birt to use
>> that parameter for the dataset?
>>
>
> Consider following example: -
> If I want to show firstName and lastName in rptdesign then I'll do following
> in groovy
> birtParameters = [];
> person = delegator.findOne("Person", [partyId : partyId], false);
> firstName = person.firstName;
> lastName = person.lastName;
>
> birtParameters.firstName = firstName;
> birtParameters.lastName = lastName;
> request.setAttribute("birtParameters", birtParameters);
>
> In rptdesign I have to do following:
>
> in open method: -
>
> firstName = params["firstName"].value;
> lastName = params["lastName"].value;
>
> in fetch method: -
>
> row["firstName"] = firstName;
> row["lastName"] = lastName;
>
> make sure datasets are same as firstName and lastName.
>
> HTH
>
>>
>> >
>> > --
>> > Thanks and Regards
>> > Santosh Malviya
>> >
>> > On Thu, Jul 29, 2010 at 6:35 AM, Hans Bakker
>> > <ma...@antwebsystems.com>wrote:
>> >
>> >> You can retrieve the data with minilanguage....
>> >> examples in the system.
>>
>> Are you saying that there are examples in the system of where the
>> minilanguage is used to retrieve data and that data is then passed to
>> a birt report? If that is the case can anyone help me find those
>> examples; I looked for all instances of "birt" but not sure that would
>> have helped me find it.
>>
>> >>
>> >> or look in the ofbiz help index, there is a chapter on birt.
>>
>> I had found a chapter on how to set up birt and how to setup a SQL
>> based data source. Do you know if there is help content that talks
>> about using other data sources or was that probably the chapter you
>> were thinking of?
>>
>> Thanks again,
>>
>> -Al
>>
>> >>
>> >> Regards,
>> >> Hans
>> >>
>> >>
>> >> --
>> >> Ofbiz on twitter: http://twitter.com/apache_ofbiz
>> >> Myself on twitter: http://twitter.com/hansbak
>> >> Antwebsystems.com <http://twitter.com/hansbak%0AAntwebsystems.com>:
>> >> Quality services for competitive rates.
>> >>
>> >> On Wed, 2010-07-28 at 18:00 -0600, Al Byers wrote:
>> >> > I do not want to use SQL to define my reports in BIRT as I do not
>> >> > think I can get the performance that I need. Are there other options
>> >> > that are more OFBiz-centric than writing Mysql stored procedures.
>> >> >
>> >> > Thanks,
>> >> >
>> >> > -Al
>> >>
>> >> --
>> >> Ofbiz on twitter: http://twitter.com/apache_ofbiz
>> >> Myself on twitter: http://twitter.com/hansbak
>> >> Antwebsystems.com <http://twitter.com/hansbak%0AAntwebsystems.com>:
>> >> Quality services for competitive rates.
>> >>
>> >>
>> >
>>
>
>
>
> --
> Thanks and Regards
> Santosh Malviya
>
Re: OFBiz data sources for BIRT
Posted by Santosh Malviya <sa...@gmail.com>.
Hello Byers,
Inline.............
On Thu, Jul 29, 2010 at 10:11 AM, Al Byers <by...@automationgroups.com>wrote:
> Thanks Santosh and Hans. Please see questions below.
>
> On Wed, Jul 28, 2010 at 9:57 PM, Santosh Malviya
> <sa...@gmail.com> wrote:
> > Hello Byers,
> >
> > You can also use groovy for retrieving data and put them in
> birtParameters
> > map and pass the map to rptdesign or else you can get data in rptdesign
> > itself.
>
> I am familiar with setting birtParameters as input to sql query
> statements, but you are saying that I could pass in entire datasets?
> Could you direct me to anything that explains how to tell birt to use
> that parameter for the dataset?
>
Consider following example: -
If I want to show firstName and lastName in rptdesign then I'll do following
in groovy
birtParameters = [];
person = delegator.findOne("Person", [partyId : partyId], false);
firstName = person.firstName;
lastName = person.lastName;
birtParameters.firstName = firstName;
birtParameters.lastName = lastName;
request.setAttribute("birtParameters", birtParameters);
In rptdesign I have to do following:
in open method: -
firstName = params["firstName"].value;
lastName = params["lastName"].value;
in fetch method: -
row["firstName"] = firstName;
row["lastName"] = lastName;
make sure datasets are same as firstName and lastName.
HTH
>
> >
> > --
> > Thanks and Regards
> > Santosh Malviya
> >
> > On Thu, Jul 29, 2010 at 6:35 AM, Hans Bakker
> > <ma...@antwebsystems.com>wrote:
> >
> >> You can retrieve the data with minilanguage....
> >> examples in the system.
>
> Are you saying that there are examples in the system of where the
> minilanguage is used to retrieve data and that data is then passed to
> a birt report? If that is the case can anyone help me find those
> examples; I looked for all instances of "birt" but not sure that would
> have helped me find it.
>
> >>
> >> or look in the ofbiz help index, there is a chapter on birt.
>
> I had found a chapter on how to set up birt and how to setup a SQL
> based data source. Do you know if there is help content that talks
> about using other data sources or was that probably the chapter you
> were thinking of?
>
> Thanks again,
>
> -Al
>
> >>
> >> Regards,
> >> Hans
> >>
> >>
> >> --
> >> Ofbiz on twitter: http://twitter.com/apache_ofbiz
> >> Myself on twitter: http://twitter.com/hansbak
> >> Antwebsystems.com <http://twitter.com/hansbak%0AAntwebsystems.com>:
> >> Quality services for competitive rates.
> >>
> >> On Wed, 2010-07-28 at 18:00 -0600, Al Byers wrote:
> >> > I do not want to use SQL to define my reports in BIRT as I do not
> >> > think I can get the performance that I need. Are there other options
> >> > that are more OFBiz-centric than writing Mysql stored procedures.
> >> >
> >> > Thanks,
> >> >
> >> > -Al
> >>
> >> --
> >> Ofbiz on twitter: http://twitter.com/apache_ofbiz
> >> Myself on twitter: http://twitter.com/hansbak
> >> Antwebsystems.com <http://twitter.com/hansbak%0AAntwebsystems.com>:
> >> Quality services for competitive rates.
> >>
> >>
> >
>
--
Thanks and Regards
Santosh Malviya
Re: OFBiz data sources for BIRT
Posted by Al Byers <by...@automationgroups.com>.
Thanks Santosh and Hans. Please see questions below.
On Wed, Jul 28, 2010 at 9:57 PM, Santosh Malviya
<sa...@gmail.com> wrote:
> Hello Byers,
>
> You can also use groovy for retrieving data and put them in birtParameters
> map and pass the map to rptdesign or else you can get data in rptdesign
> itself.
I am familiar with setting birtParameters as input to sql query
statements, but you are saying that I could pass in entire datasets?
Could you direct me to anything that explains how to tell birt to use
that parameter for the dataset?
>
> --
> Thanks and Regards
> Santosh Malviya
>
> On Thu, Jul 29, 2010 at 6:35 AM, Hans Bakker
> <ma...@antwebsystems.com>wrote:
>
>> You can retrieve the data with minilanguage....
>> examples in the system.
Are you saying that there are examples in the system of where the
minilanguage is used to retrieve data and that data is then passed to
a birt report? If that is the case can anyone help me find those
examples; I looked for all instances of "birt" but not sure that would
have helped me find it.
>>
>> or look in the ofbiz help index, there is a chapter on birt.
I had found a chapter on how to set up birt and how to setup a SQL
based data source. Do you know if there is help content that talks
about using other data sources or was that probably the chapter you
were thinking of?
Thanks again,
-Al
>>
>> Regards,
>> Hans
>>
>>
>> --
>> Ofbiz on twitter: http://twitter.com/apache_ofbiz
>> Myself on twitter: http://twitter.com/hansbak
>> Antwebsystems.com <http://twitter.com/hansbak%0AAntwebsystems.com>:
>> Quality services for competitive rates.
>>
>> On Wed, 2010-07-28 at 18:00 -0600, Al Byers wrote:
>> > I do not want to use SQL to define my reports in BIRT as I do not
>> > think I can get the performance that I need. Are there other options
>> > that are more OFBiz-centric than writing Mysql stored procedures.
>> >
>> > Thanks,
>> >
>> > -Al
>>
>> --
>> Ofbiz on twitter: http://twitter.com/apache_ofbiz
>> Myself on twitter: http://twitter.com/hansbak
>> Antwebsystems.com <http://twitter.com/hansbak%0AAntwebsystems.com>:
>> Quality services for competitive rates.
>>
>>
>
Re: OFBiz data sources for BIRT
Posted by Santosh Malviya <sa...@gmail.com>.
Hello Byers,
You can also use groovy for retrieving data and put them in birtParameters
map and pass the map to rptdesign or else you can get data in rptdesign
itself.
--
Thanks and Regards
Santosh Malviya
On Thu, Jul 29, 2010 at 6:35 AM, Hans Bakker
<ma...@antwebsystems.com>wrote:
> You can retrieve the data with minilanguage....
> examples in the system.
>
> or look in the ofbiz help index, there is a chapter on birt.
>
> Regards,
> Hans
>
>
> --
> Ofbiz on twitter: http://twitter.com/apache_ofbiz
> Myself on twitter: http://twitter.com/hansbak
> Antwebsystems.com <http://twitter.com/hansbak%0AAntwebsystems.com>:
> Quality services for competitive rates.
>
> On Wed, 2010-07-28 at 18:00 -0600, Al Byers wrote:
> > I do not want to use SQL to define my reports in BIRT as I do not
> > think I can get the performance that I need. Are there other options
> > that are more OFBiz-centric than writing Mysql stored procedures.
> >
> > Thanks,
> >
> > -Al
>
> --
> Ofbiz on twitter: http://twitter.com/apache_ofbiz
> Myself on twitter: http://twitter.com/hansbak
> Antwebsystems.com <http://twitter.com/hansbak%0AAntwebsystems.com>:
> Quality services for competitive rates.
>
>
Re: OFBiz data sources for BIRT
Posted by Hans Bakker <ma...@antwebsystems.com>.
You can retrieve the data with minilanguage....
examples in the system.
or look in the ofbiz help index, there is a chapter on birt.
Regards,
Hans
--
Ofbiz on twitter: http://twitter.com/apache_ofbiz
Myself on twitter: http://twitter.com/hansbak
Antwebsystems.com: Quality services for competitive rates.
On Wed, 2010-07-28 at 18:00 -0600, Al Byers wrote:
> I do not want to use SQL to define my reports in BIRT as I do not
> think I can get the performance that I need. Are there other options
> that are more OFBiz-centric than writing Mysql stored procedures.
>
> Thanks,
>
> -Al
--
Ofbiz on twitter: http://twitter.com/apache_ofbiz
Myself on twitter: http://twitter.com/hansbak
Antwebsystems.com: Quality services for competitive rates.