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
<santosh.of...@gmail.com> wrote:
> Hello Byers,
>
> Inline.............
>
> On Thu, Jul 29, 2010 at 10:11 AM, Al Byers <bye...@automationgroups.com>wrote:
>
>> Thanks Santosh and Hans. Please see questions below.
>>
>> On Wed, Jul 28, 2010 at 9:57 PM, Santosh Malviya
>> <santosh.of...@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
>> > <mailingl...@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
>
