Hello Swapnil, If you have formed query in groovy then why are you again doing query in rptdesign file, can you put your open and fetch code here to better understand.
-- Thanks and Regards Santosh Malviya On Thu, Aug 12, 2010 at 1:00 PM, Swapnil Sawant < [email protected]> wrote: > Hi Santosh, > > Thanks for your reply. > > Even if I migrate my logic of 'fetching data and then setting it to report > fields' to groovy layer, I would still need to clear 'open' and 'fetch' > method part from auto-generated code (as during report generation using BIRT > GUI, I must have formed the queries to fetch data in report. Hence, code for > this too would be present in 'open' and 'fetch' method of auto-generated > code) > > > How can I avoid above situation ? i.e I just want that without making even > a single change in 'auto-generated' code I should be able to run that report > from ofbiz code. What settings / tasks I would have to do on BIRT GUI side > to achieve this? > > > > > > > Thanks & Regards, > > Swapnil Sawant > > > -----Original Message----- > From: Santosh Malviya [mailto:[email protected]] > Sent: Thursday, August 12, 2010 12:21 PM > To: [email protected] > Subject: Re: Query regarding ofbiz-BIRT integration > > Hello Swapnil, > > Instead of writing code in open and fetch method of rptdesign, you can use > groovy to fetch data and then just get your data in open from groovy and > set > into fetch method, and groovy is easy to maintain than rptdesign. > > -- > Thanks and Regards > Santosh Malviya > > On Thu, Aug 12, 2010 at 11:03 AM, Swapnil Sawant < > [email protected]> wrote: > > > Hi, > > > > > > I am new to report generation in ofbiz using BIRT GUI. For achieving > report > > generation in ofbiz, I follow below steps : > > > > > > 1. Prepare the report using BIRT GUI (designing format of report, > > assigning entity data to the fields in it) > > > > 2. Generate the code out of it . > > > > 3. Once code is generated, I need to change that auto-generated > code > > from BIRT GUI for some of the following things : > > > > a. Writing ofbiz logic (e.g. fetching data from ofbiz entity using > > delegator.findBy.. )in open and fetch methods > > > > b. Change the entity field names from BIRT GUI format to ofbiz > entity > > fields (e.g. emplId field in ofbiz entity becomes EMPL_ID in BIRT > > auto-generated code) > > > > > > 4. Once above filtration is done then only I can use "rptdesign" > > file in my ofbiz code. > > > > Hence, I wanted to know is there any way by which we can eliminate step - > 3 > > and start using BIRT auto-generated code directly in ofbiz in order to > > achieve following benefits : > > > > > > - Making maintenance of reports very easy > > > > - Reduce the development hours > > > > - Smooth integration of BIRT and ofbiz > > > > > > > > > > Thanks & Regards, > > Swapnil Sawant > > > > ________________________________ > > This Email may contain confidential or privileged information for the > > intended recipient (s) If you are not the intended recipient, please do > not > > use or disseminate the information, notify the sender and delete it from > > your system. > > > > ______________________________________________________________________ > > > ______________________________________________________________________ > > This Email may contain confidential or privileged information for the > intended recipient (s) If you are not the intended recipient, please do not > use or disseminate the information, notify the sender and delete it from > your system. > > ______________________________________________________________________ >
