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 >
