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
