Hi Santosh,
The 'rptdesign' file is 'auto-generated code using BIRT GUI' .
We are using this 'auto-generated' code in our ofbiz code after doing step 3 as
mentioned in 1st mail of mine.
So when we prepare a report using BIRT GUI tool,in order to test the report, we
assign values to the columns in the report . for example,
In a salary report I would not only design/create a field called Employee name
but I would also specify as to from which table I wld need to feed the data to
this field.
Again to summarize the whole thing, preparing report using BIRT GUI tool
involves following two things :
- designing format of report
- mapping fields from report to fields of entities in database
Hence, after successful testing when we 'auto-generate' the code, inside open
and fetch method of this code we get the code corresponding to "above
assignment of ofbiz entity fields to report fields' . This code we have to
modify. Apart from this modification we have to do modifications as specified
in my first mail's step - 3 .
We are requiring that , we should be able to design and test report on BIRT
GUI,generate the code and directly start using it without any modifications.
Thanks & Regards,
Swapnil Sawant | iLabs | L & T Infotech
Plot no. EL - 200,TTC Electronic Zone,Shil-Mahape road,Navi Mumbai - 400 701
Extn: +91 22 6795 4325
Mail: [email protected]
www.lntinfotech.com
-----Original Message-----
From: Santosh Malviya [mailto:[email protected]]
Sent: Thursday, August 12, 2010 2:04 PM
To: [email protected]
Subject: Re: Query regarding ofbiz-BIRT integration
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.
>
> ______________________________________________________________________
>
______________________________________________________________________
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.
______________________________________________________________________
