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 <[email protected]>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 > <[email protected]> wrote: > > Hello Byers, > > > > Inline............. > > > > On Thu, Jul 29, 2010 at 10:11 AM, Al Byers <[email protected] > >wrote: > > > >> Thanks Santosh and Hans. Please see questions below. > >> > >> On Wed, Jul 28, 2010 at 9:57 PM, Santosh Malviya > >> <[email protected]> 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 > >> > <[email protected]>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 > > >
