OFBiz › OFBiz - User

Query regarding BIRT report generation in OFBiz

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

11 messages Options

Ashish Tiwari

Query regarding BIRT report generation in OFBiz

Hi Hans,

what I have done so far is:

1. I have generated a .rptdesign file through Birt RCP designer 2_5_1.
2. Now in ofbiz I m trying to display this report file.
3.When I try to display the default .rptdesign file provided in ofbiz i.e. product.rptdesign file it is successfully displayed in ofbiz.
4. But when I try to display the .rptdesign file generated by me in RCP designer I get an error i.e.

Cannot find or process the org.eclipse.birt.report.data.oda.jdbc driver's data source extension configuration.
org.eclipse.birt.report.data.oda.jdbc

5. While trying to resolve this error I compared the two .rptdesign file and found some differences which are:

product.rptdesign(Default file in OFbiz) test.rptdesign(generated in RCP designer)

I) <data-sources> <data-sources>
<script-data-source name="OFBiz" id="8"/> <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
name="Data Source" id="9">

</data-sources>

2) <data-sets>
<script-data-set name="Product" id="9"> <data-sets>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet"
name="Data Set" id="43">

Also in the default file there some code (looks like groovy code)is written to fetch the field values but no such code is there in the file generated in RCP designer.

Please help me out in resolving this problem.

________________________________
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.

______________________________________________________________________

hans_bakker

Re: Query regarding BIRT report generation in OFBiz

I can only advise you to study the existing reports, especially how the
data is retrieved with minilanguage.

Regards,
Hans

On Tue, 2010-01-19 at 12:28 +0530, Ashish Tiwari wrote:

> Hi Hans,
>
> what I have done so far is:
>
> 1. I have generated a .rptdesign file through Birt RCP designer 2_5_1.
> 2. Now in ofbiz I m trying to display this report file.
> 3.When I try to display the default .rptdesign file provided in ofbiz i.e. product.rptdesign file it is successfully displayed in ofbiz.
> 4. But when I try to display the .rptdesign file generated by me in RCP designer I get an error i.e.
>
> Cannot find or process the org.eclipse.birt.report.data.oda.jdbc driver's data source extension configuration.
> org.eclipse.birt.report.data.oda.jdbc
>
> 5. While trying to resolve this error I compared the two .rptdesign file and found some differences which are:
>
> product.rptdesign(Default file in OFbiz) test.rptdesign(generated in RCP designer)
>
> I) <data-sources> <data-sources>
> <script-data-source name="OFBiz" id="8"/> <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
> name="Data Source" id="9">
>
> </data-sources>
>
>
> 2) <data-sets>
> <script-data-set name="Product" id="9"> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet"
> name="Data Set" id="43">
>
> Also in the default file there some code (looks like groovy code)is written to fetch the field values but no such code is there in the file generated in RCP designer.
>
> Please help me out in resolving this problem.
>
>
>
> ________________________________
> 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.
>
> ______________________________________________________________________

--
Antwebsystems.com: Quality OFBiz services for competitive rates

Michael Xu (xudong)

Re: Query regarding BIRT report generation in OFBiz

hi Hans,

A quick question. Is it feasible to implement ad hoc report on top of birt
in ofbiz?

--
Regards,
Michael Xu (xudong)
www.wizitsoft.com | Office: (8610) 6267 0615 ext 806 | Mobile: (86) 135 0135
9807 | Fax: (8610) 62670096

On Tue, Jan 19, 2010 at 3:14 PM, Hans Bakker
<[hidden email]>wrote:

> I can only advise you to study the existing reports, especially how the
> data is retrieved with minilanguage.
>
> Regards,
> Hans
>
> On Tue, 2010-01-19 at 12:28 +0530, Ashish Tiwari wrote:
> > Hi Hans,
> >
> > what I have done so far is:
> >
> > 1. I have generated a .rptdesign file through Birt RCP designer 2_5_1.
> > 2. Now in ofbiz I m trying to display this report file.
> > 3.When I try to display the default .rptdesign file provided in ofbiz
> i.e. product.rptdesign file it is successfully displayed in ofbiz.
> > 4. But when I try to display the .rptdesign file generated by me in RCP
> designer I get an error i.e.
> >
> > Cannot find or process the org.eclipse.birt.report.data.oda.jdbc
> driver's data source extension configuration.
> > org.eclipse.birt.report.data.oda.jdbc
> >
> > 5. While trying to resolve this error I compared the two .rptdesign file
> and found some differences which are:
> >
> > product.rptdesign(Default file in OFbiz)
> test.rptdesign(generated
> in RCP designer)
> >
> > I) <data-sources> <data-sources>
> > <script-data-source name="OFBiz" id="8"/> <oda-data-source
> extensionID="org.eclipse.birt.report.data.oda.jdbc"
> >
> name="Data Source" id="9">
> >
> > </data-sources>
> >
> >
> > 2) <data-sets>
> > <script-data-set name="Product" id="9"> <data-sets>
> > <oda-data-set
> >
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet"
> >
> name="Data Set" id="43">
> >
> > Also in the default file there some code (looks like groovy code)is
> written to fetch the field values but no such code is there in the file
> generated in RCP designer.
> >
> > Please help me out in resolving this problem.
> >
> >
> >
> > ________________________________
> > 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.
> >
> > ______________________________________________________________________
> --
> Antwebsystems.com: Quality OFBiz services for competitive rates
>
>

hans_bakker

Re: Query regarding BIRT report generation in OFBiz

Probably sure that can be done, however remember that currently the
report is prepared outside ofbiz, within eclipse and imported into
OFBiz.

This means that a simple version of the report preparation function
should be duplicated within the ofbiz environment which does not really
sound as an easy task.

Regards,
Hans

On Tue, 2010-01-19 at 15:43 +0800, Michael Xu (xudong) wrote:

> hi Hans,
>
> A quick question. Is it feasible to implement ad hoc report on top of birt
> in ofbiz?
>
> --
> Regards,
> Michael Xu (xudong)
> www.wizitsoft.com | Office: (8610) 6267 0615 ext 806 | Mobile: (86) 135 0135
> 9807 | Fax: (8610) 62670096
>
>
> On Tue, Jan 19, 2010 at 3:14 PM, Hans Bakker
> <[hidden email]>wrote:
>
> > I can only advise you to study the existing reports, especially how the
> > data is retrieved with minilanguage.
> >
> > Regards,
> > Hans
> >
> > On Tue, 2010-01-19 at 12:28 +0530, Ashish Tiwari wrote:
> > > Hi Hans,
> > >
> > > what I have done so far is:
> > >
> > > 1. I have generated a .rptdesign file through Birt RCP designer 2_5_1.
> > > 2. Now in ofbiz I m trying to display this report file.
> > > 3.When I try to display the default .rptdesign file provided in ofbiz
> > i.e. product.rptdesign file it is successfully displayed in ofbiz.
> > > 4. But when I try to display the .rptdesign file generated by me in RCP
> > designer I get an error i.e.
> > >
> > > Cannot find or process the org.eclipse.birt.report.data.oda.jdbc
> > driver's data source extension configuration.
> > > org.eclipse.birt.report.data.oda.jdbc
> > >
> > > 5. While trying to resolve this error I compared the two .rptdesign file
> > and found some differences which are:
> > >
> > > product.rptdesign(Default file in OFbiz)
> > test.rptdesign(generated
> > in RCP designer)
> > >
> > > I) <data-sources> <data-sources>
> > > <script-data-source name="OFBiz" id="8"/> <oda-data-source
> > extensionID="org.eclipse.birt.report.data.oda.jdbc"
> > >
> > name="Data Source" id="9">
> > >
> > > </data-sources>
> > >
> > >
> > > 2) <data-sets>
> > > <script-data-set name="Product" id="9"> <data-sets>
> > > <oda-data-set
> > >
> > extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet"
> > >
> > name="Data Set" id="43">
> > >
> > > Also in the default file there some code (looks like groovy code)is
> > written to fetch the field values but no such code is there in the file
> > generated in RCP designer.
> > >
> > > Please help me out in resolving this problem.
> > >
> > >
> > >
> > > ________________________________
> > > 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.
> > >
> > > ______________________________________________________________________
> > --
> > Antwebsystems.com: Quality OFBiz services for competitive rates
> >
> >

--
Antwebsystems.com: Quality OFBiz services for competitive rates

Ashish Tiwari

RE: Query regarding BIRT report generation in OFBiz

In reply to this post by hans_bakker

hi hans,
I have studied the existing reports that's is why I have shown the comparison between the report file providede in ofbiz and the one I genenrated in RCP designer please go through my previous mail once again and help me to solve the problem

-----Original Message-----
From: Hans Bakker [mailto:[hidden email]]
Sent: Tuesday, January 19, 2010 12:44 PM
To: [hidden email]
Subject: Re: Query regarding BIRT report generation in OFBiz

I can only advise you to study the existing reports, especially how the
data is retrieved with minilanguage.

Regards,
Hans

On Tue, 2010-01-19 at 12:28 +0530, Ashish Tiwari wrote:

--
Antwebsystems.com: Quality OFBiz services for competitive rates

______________________________________________________________________

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.

______________________________________________________________________

Michael Xu (xudong)

Re: Query regarding BIRT report generation in OFBiz

In reply to this post by hans_bakker

hi Hans,

Thanks. I tried pentaho and found the ad hoc report is really useful. With
such a feature, then end user can design report through web UI.

--
Regards,
Michael Xu (xudong)
www.wizitsoft.com | Office: (8610) 6267 0615 ext 806 | Mobile: (86) 135 0135
9807 | Fax: (8610) 62670096

On Tue, Jan 19, 2010 at 4:25 PM, Hans Bakker
<[hidden email]>wrote:

> Probably sure that can be done, however remember that currently the
> report is prepared outside ofbiz, within eclipse and imported into
> OFBiz.
>
> This means that a simple version of the report preparation function
> should be duplicated within the ofbiz environment which does not really
> sound as an easy task.
>
> Regards,
> Hans
>
> On Tue, 2010-01-19 at 15:43 +0800, Michael Xu (xudong) wrote:
> > hi Hans,
> >
> > A quick question. Is it feasible to implement ad hoc report on top of
> birt
> > in ofbiz?
> >
> > --
> > Regards,
> > Michael Xu (xudong)
> > www.wizitsoft.com | Office: (8610) 6267 0615 ext 806 | Mobile: (86) 135
> 0135
> > 9807 | Fax: (8610) 62670096
> >
> >
> > On Tue, Jan 19, 2010 at 3:14 PM, Hans Bakker
> > <[hidden email]>wrote:
> >
> > > I can only advise you to study the existing reports, especially how the
> > > data is retrieved with minilanguage.
> > >
> > > Regards,
> > > Hans
> > >
> > > On Tue, 2010-01-19 at 12:28 +0530, Ashish Tiwari wrote:
> > > > Hi Hans,
> > > >
> > > > what I have done so far is:
> > > >
> > > > 1. I have generated a .rptdesign file through Birt RCP designer
> 2_5_1.
> > > > 2. Now in ofbiz I m trying to display this report file.
> > > > 3.When I try to display the default .rptdesign file provided in ofbiz
> > > i.e. product.rptdesign file it is successfully displayed in ofbiz.
> > > > 4. But when I try to display the .rptdesign file generated by me in
> RCP
> > > designer I get an error i.e.
> > > >
> > > > Cannot find or process the
> org.eclipse.birt.report.data.oda.jdbc
> > > driver's data source extension configuration.
> > > > org.eclipse.birt.report.data.oda.jdbc
> > > >
> > > > 5. While trying to resolve this error I compared the two .rptdesign
> file
> > > and found some differences which are:
> > > >
> > > > product.rptdesign(Default file in OFbiz)
> > >
> test.rptdesign(generated
> > > in RCP designer)
> > > >
> > > > I) <data-sources>
> <data-sources>
> > > > <script-data-source name="OFBiz" id="8"/> <oda-data-source
> > > extensionID="org.eclipse.birt.report.data.oda.jdbc"
> > > >
> > > name="Data Source" id="9">
> > > >
> > > > </data-sources>
> > > >
> > > >
> > > > 2) <data-sets>
> > > > <script-data-set name="Product" id="9"> <data-sets>
> > > > <oda-data-set
> > > >
> > > extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet"
> > > >
> > > name="Data Set" id="43">
> > > >
> > > > Also in the default file there some code (looks like groovy code)is
> > > written to fetch the field values but no such code is there in the file
> > > generated in RCP designer.
> > > >
> > > > Please help me out in resolving this problem.
> > > >
> > > >
> > > >
> > > > ________________________________
> > > > 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.
> > > >
> > > >
> ______________________________________________________________________
> > > --
> > > Antwebsystems.com: Quality OFBiz services for competitive rates
> > >
> > >
> --
> Antwebsystems.com: Quality OFBiz services for competitive rates
>
>

hans_bakker

RE: Query regarding BIRT report generation in OFBiz

In reply to this post by Ashish Tiwari

Look at the data source, we are using minilanguage which is using the
delegator. You want to talk directly to the jdbc driver....

We are not in favor of that and never used this route. We can only
advise you to use the delegator either with minilanguage of
groovyscript.

Regards,
Hans

On Tue, 2010-01-19 at 13:58 +0530, Ashish Tiwari wrote:

> hi hans,
> I have studied the existing reports that's is why I have shown the comparison between the report file providede in ofbiz and the one I genenrated in RCP designer please go through my previous mail once again and help me to solve the problem
>
> -----Original Message-----
> From: Hans Bakker [mailto:[hidden email]]
> Sent: Tuesday, January 19, 2010 12:44 PM
> To: [hidden email]
> Subject: Re: Query regarding BIRT report generation in OFBiz
>
> I can only advise you to study the existing reports, especially how the
> data is retrieved with minilanguage.
>
> Regards,
> Hans
>
> On Tue, 2010-01-19 at 12:28 +0530, Ashish Tiwari wrote:
> > Hi Hans,
> >
> > what I have done so far is:
> >
> > 1. I have generated a .rptdesign file through Birt RCP designer 2_5_1.
> > 2. Now in ofbiz I m trying to display this report file.
> > 3.When I try to display the default .rptdesign file provided in ofbiz i.e. product.rptdesign file it is successfully displayed in ofbiz.
> > 4. But when I try to display the .rptdesign file generated by me in RCP designer I get an error i.e.
> >
> > Cannot find or process the org.eclipse.birt.report.data.oda.jdbc driver's data source extension configuration.
> > org.eclipse.birt.report.data.oda.jdbc
> >
> > 5. While trying to resolve this error I compared the two .rptdesign file and found some differences which are:
> >
> > product.rptdesign(Default file in OFbiz) test.rptdesign(generated in RCP designer)
> >
> > I) <data-sources> <data-sources>
> > <script-data-source name="OFBiz" id="8"/> <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
> > name="Data Source" id="9">
> >
> > </data-sources>
> >
> >
> > 2) <data-sets>
> > <script-data-set name="Product" id="9"> <data-sets>
> > <oda-data-set
> > extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet"
> > name="Data Set" id="43">
> >
> > Also in the default file there some code (looks like groovy code)is written to fetch the field values but no such code is there in the file generated in RCP designer.
> >
> > Please help me out in resolving this problem.
> >
> >
> >
> > ________________________________
> > 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.
> >
> > ______________________________________________________________________
> --
> Antwebsystems.com: Quality OFBiz services for competitive rates
>
>
> ______________________________________________________________________
>
> 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.
>
> ______________________________________________________________________

--
Antwebsystems.com: Quality OFBiz services for competitive rates

Michael Xu (xudong)

Re: Query regarding BIRT report generation in OFBiz

hi Hans,

What is the advantages of using delegator?

What I can think of is that we can reuse existing logic (maybe for access
control and other purpose). Any other advantages?

--
Regards,
Michael Xu (xudong)
www.wizitsoft.com | Office: (8610) 6267 0615 ext 806 | Mobile: (86) 135 0135
9807 | Fax: (8610) 62670096

On Tue, Jan 19, 2010 at 4:32 PM, Hans Bakker
<[hidden email]>wrote:

> Look at the data source, we are using minilanguage which is using the
> delegator. You want to talk directly to the jdbc driver....
>
> We are not in favor of that and never used this route. We can only
> advise you to use the delegator either with minilanguage of
> groovyscript.
>
> Regards,
> Hans
>
> On Tue, 2010-01-19 at 13:58 +0530, Ashish Tiwari wrote:
> > hi hans,
> > I have studied the existing reports that's is why I have shown the
> comparison between the report file providede in ofbiz and the one I
> genenrated in RCP designer please go through my previous mail once again and
> help me to solve the problem
> >
> > -----Original Message-----
> > From: Hans Bakker [mailto:[hidden email]]
> > Sent: Tuesday, January 19, 2010 12:44 PM
> > To: [hidden email]
> > Subject: Re: Query regarding BIRT report generation in OFBiz
> >
> > I can only advise you to study the existing reports, especially how the
> > data is retrieved with minilanguage.
> >
> > Regards,
> > Hans
> >
> > On Tue, 2010-01-19 at 12:28 +0530, Ashish Tiwari wrote:
> > > Hi Hans,
> > >
> > > what I have done so far is:
> > >
> > > 1. I have generated a .rptdesign file through Birt RCP designer 2_5_1.
> > > 2. Now in ofbiz I m trying to display this report file.
> > > 3.When I try to display the default .rptdesign file provided in ofbiz
> i.e. product.rptdesign file it is successfully displayed in ofbiz.
> > > 4. But when I try to display the .rptdesign file generated by me in RCP
> designer I get an error i.e.
> > >
> > > Cannot find or process the org.eclipse.birt.report.data.oda.jdbc
> driver's data source extension configuration.
> > > org.eclipse.birt.report.data.oda.jdbc
> > >
> > > 5. While trying to resolve this error I compared the two .rptdesign
> file and found some differences which are:
> > >
> > > product.rptdesign(Default file in OFbiz)
>
> test.rptdesign(generated in RCP designer)
> > >
> > > I) <data-sources>
> <data-sources>
> > > <script-data-source name="OFBiz" id="8"/> <oda-data-source
> extensionID="org.eclipse.birt.report.data.oda.jdbc"
> > >
> name="Data Source" id="9">
> > >
> > > </data-sources>
> > >
> > >
> > > 2) <data-sets>
> > > <script-data-set name="Product" id="9"> <data-sets>
> > > <oda-data-set
> > >
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet"
> > >
> name="Data Set" id="43">
> > >
> > > Also in the default file there some code (looks like groovy code)is
> written to fetch the field values but no such code is there in the file
> generated in RCP designer.
> > >
> > > Please help me out in resolving this problem.
> > >
> > >
> > >
> > > ________________________________
> > > 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.
> > >
> > > ______________________________________________________________________
> > --
> > Antwebsystems.com: Quality OFBiz services for competitive rates
> >
> >
> > ______________________________________________________________________
> >
> > 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.
> >
> > ______________________________________________________________________
> --
> Antwebsystems.com: Quality OFBiz services for competitive rates
>
>

Michael Xu (xudong)

Re: Query regarding BIRT report generation in OFBiz

hi Hans,

Another quick question: is it feasible to embed birt list report or chart in
portlet? I can see you contribute a lot in the two components. Any advice?

--
Regards,
Michael Xu (xudong)
www.wizitsoft.com | Office: (8610) 6267 0615 ext 806 | Mobile: (86) 135 0135
9807 | Fax: (8610) 62670096

On Tue, Jan 19, 2010 at 4:37 PM, Michael Xu (xudong)
<[hidden email]>wrote:

> hi Hans,
>
> What is the advantages of using delegator?
>
> What I can think of is that we can reuse existing logic (maybe for access
> control and other purpose). Any other advantages?
>
> --
> Regards,
> Michael Xu (xudong)
> www.wizitsoft.com | Office: (8610) 6267 0615 ext 806 | Mobile: (86) 135
> 0135 9807 | Fax: (8610) 62670096
>
>
> On Tue, Jan 19, 2010 at 4:32 PM, Hans Bakker <
> [hidden email]> wrote:
>
>> Look at the data source, we are using minilanguage which is using the
>> delegator. You want to talk directly to the jdbc driver....
>>
>> We are not in favor of that and never used this route. We can only
>> advise you to use the delegator either with minilanguage of
>> groovyscript.
>>
>> Regards,
>> Hans
>>
>> On Tue, 2010-01-19 at 13:58 +0530, Ashish Tiwari wrote:
>> > hi hans,
>> > I have studied the existing reports that's is why I have shown the
>> comparison between the report file providede in ofbiz and the one I
>> genenrated in RCP designer please go through my previous mail once again and
>> help me to solve the problem
>> >
>> > -----Original Message-----
>> > From: Hans Bakker [mailto:[hidden email]]
>> > Sent: Tuesday, January 19, 2010 12:44 PM
>> > To: [hidden email]
>> > Subject: Re: Query regarding BIRT report generation in OFBiz
>> >
>> > I can only advise you to study the existing reports, especially how the
>> > data is retrieved with minilanguage.
>> >
>> > Regards,
>> > Hans
>> >
>> > On Tue, 2010-01-19 at 12:28 +0530, Ashish Tiwari wrote:
>> > > Hi Hans,
>> > >
>> > > what I have done so far is:
>> > >
>> > > 1. I have generated a .rptdesign file through Birt RCP designer 2_5_1.
>> > > 2. Now in ofbiz I m trying to display this report file.
>> > > 3.When I try to display the default .rptdesign file provided in ofbiz
>> i.e. product.rptdesign file it is successfully displayed in ofbiz.
>> > > 4. But when I try to display the .rptdesign file generated by me in
>> RCP designer I get an error i.e.
>> > >
>> > > Cannot find or process the
>> org.eclipse.birt.report.data.oda.jdbc driver's data source extension
>> configuration.
>> > > org.eclipse.birt.report.data.oda.jdbc
>> > >
>> > > 5. While trying to resolve this error I compared the two .rptdesign
>> file and found some differences which are:
>> > >
>> > > product.rptdesign(Default file in OFbiz)
>>
>> test.rptdesign(generated in RCP designer)
>> > >
>> > > I) <data-sources>
>> <data-sources>
>> > > <script-data-source name="OFBiz" id="8"/> <oda-data-source
>> extensionID="org.eclipse.birt.report.data.oda.jdbc"
>> > >
>> name="Data Source" id="9">
>> > >
>> > > </data-sources>
>> > >
>> > >
>> > > 2) <data-sets>
>> > > <script-data-set name="Product" id="9"> <data-sets>
>> > > <oda-data-set
>> > >
>> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet"
>> > >
>> name="Data Set" id="43">
>> > >
>> > > Also in the default file there some code (looks like groovy code)is
>> written to fetch the field values but no such code is there in the file
>> generated in RCP designer.
>> > >
>> > > Please help me out in resolving this problem.
>> > >
>> > >
>> > >
>> > > ________________________________
>> > > 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.
>> > >
>> > > ______________________________________________________________________
>> > --
>> > Antwebsystems.com: Quality OFBiz services for competitive rates
>> >
>> >
>> > ______________________________________________________________________
>> >
>> > 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.
>> >
>> > ______________________________________________________________________
>> --
>> Antwebsystems.com: Quality OFBiz services for competitive rates
>>
>>
>

hans_bakker

Re: Query regarding BIRT report generation in OFBiz

In reply to this post by Michael Xu (xudong)

using the delegator makes you independent on the database.

we develop here on derby and run production on postgres or whatever the
customer wants.

Regards,
Hans

On Tue, 2010-01-19 at 16:37 +0800, Michael Xu (xudong) wrote:

> hi Hans,
>
> What is the advantages of using delegator?
>
> What I can think of is that we can reuse existing logic (maybe for access
> control and other purpose). Any other advantages?
>
> --
> Regards,
> Michael Xu (xudong)
> www.wizitsoft.com | Office: (8610) 6267 0615 ext 806 | Mobile: (86) 135 0135
> 9807 | Fax: (8610) 62670096
>
>
> On Tue, Jan 19, 2010 at 4:32 PM, Hans Bakker
> <[hidden email]>wrote:
>
> > Look at the data source, we are using minilanguage which is using the
> > delegator. You want to talk directly to the jdbc driver....
> >
> > We are not in favor of that and never used this route. We can only
> > advise you to use the delegator either with minilanguage of
> > groovyscript.
> >
> > Regards,
> > Hans
> >
> > On Tue, 2010-01-19 at 13:58 +0530, Ashish Tiwari wrote:
> > > hi hans,
> > > I have studied the existing reports that's is why I have shown the
> > comparison between the report file providede in ofbiz and the one I
> > genenrated in RCP designer please go through my previous mail once again and
> > help me to solve the problem
> > >
> > > -----Original Message-----
> > > From: Hans Bakker [mailto:[hidden email]]
> > > Sent: Tuesday, January 19, 2010 12:44 PM
> > > To: [hidden email]
> > > Subject: Re: Query regarding BIRT report generation in OFBiz
> > >
> > > I can only advise you to study the existing reports, especially how the
> > > data is retrieved with minilanguage.
> > >
> > > Regards,
> > > Hans
> > >
> > > On Tue, 2010-01-19 at 12:28 +0530, Ashish Tiwari wrote:
> > > > Hi Hans,
> > > >
> > > > what I have done so far is:
> > > >
> > > > 1. I have generated a .rptdesign file through Birt RCP designer 2_5_1.
> > > > 2. Now in ofbiz I m trying to display this report file.
> > > > 3.When I try to display the default .rptdesign file provided in ofbiz
> > i.e. product.rptdesign file it is successfully displayed in ofbiz.
> > > > 4. But when I try to display the .rptdesign file generated by me in RCP
> > designer I get an error i.e.
> > > >
> > > > Cannot find or process the org.eclipse.birt.report.data.oda.jdbc
> > driver's data source extension configuration.
> > > > org.eclipse.birt.report.data.oda.jdbc
> > > >
> > > > 5. While trying to resolve this error I compared the two .rptdesign
> > file and found some differences which are:
> > > >
> > > > product.rptdesign(Default file in OFbiz)
> >
> > test.rptdesign(generated in RCP designer)
> > > >
> > > > I) <data-sources>
> > <data-sources>
> > > > <script-data-source name="OFBiz" id="8"/> <oda-data-source
> > extensionID="org.eclipse.birt.report.data.oda.jdbc"
> > > >
> > name="Data Source" id="9">
> > > >
> > > > </data-sources>
> > > >
> > > >
> > > > 2) <data-sets>
> > > > <script-data-set name="Product" id="9"> <data-sets>
> > > > <oda-data-set
> > > >
> > extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet"
> > > >
> > name="Data Set" id="43">
> > > >
> > > > Also in the default file there some code (looks like groovy code)is
> > written to fetch the field values but no such code is there in the file
> > generated in RCP designer.
> > > >
> > > > Please help me out in resolving this problem.
> > > >
> > > >
> > > >
> > > > ________________________________
> > > > 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.
> > > >
> > > > ______________________________________________________________________
> > > --
> > > Antwebsystems.com: Quality OFBiz services for competitive rates
> > >
> > >
> > > ______________________________________________________________________
> > >
> > > 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.
> > >
> > > ______________________________________________________________________
> > --
> > Antwebsystems.com: Quality OFBiz services for competitive rates
> >
> >

--
Antwebsystems.com: Quality OFBiz services for competitive rates

hans_bakker

Re: Query regarding BIRT report generation in OFBiz

In reply to this post by Michael Xu (xudong)

Sure, i think you can put anything that is displayed within ofbiz in a
portlet....

On Tue, 2010-01-19 at 16:38 +0800, Michael Xu (xudong) wrote:

> hi Hans,
>
> Another quick question: is it feasible to embed birt list report or chart in
> portlet? I can see you contribute a lot in the two components. Any advice?
>
> --
> Regards,
> Michael Xu (xudong)
> www.wizitsoft.com | Office: (8610) 6267 0615 ext 806 | Mobile: (86) 135 0135
> 9807 | Fax: (8610) 62670096
>
>
> On Tue, Jan 19, 2010 at 4:37 PM, Michael Xu (xudong)
> <[hidden email]>wrote:
>
> > hi Hans,
> >
> > What is the advantages of using delegator?
> >
> > What I can think of is that we can reuse existing logic (maybe for access
> > control and other purpose). Any other advantages?
> >
> > --
> > Regards,
> > Michael Xu (xudong)
> > www.wizitsoft.com | Office: (8610) 6267 0615 ext 806 | Mobile: (86) 135
> > 0135 9807 | Fax: (8610) 62670096
> >
> >
> > On Tue, Jan 19, 2010 at 4:32 PM, Hans Bakker <
> > [hidden email]> wrote:
> >
> >> Look at the data source, we are using minilanguage which is using the
> >> delegator. You want to talk directly to the jdbc driver....
> >>
> >> We are not in favor of that and never used this route. We can only
> >> advise you to use the delegator either with minilanguage of
> >> groovyscript.
> >>
> >> Regards,
> >> Hans
> >>
> >> On Tue, 2010-01-19 at 13:58 +0530, Ashish Tiwari wrote:
> >> > hi hans,
> >> > I have studied the existing reports that's is why I have shown the
> >> comparison between the report file providede in ofbiz and the one I
> >> genenrated in RCP designer please go through my previous mail once again and
> >> help me to solve the problem
> >> >
> >> > -----Original Message-----
> >> > From: Hans Bakker [mailto:[hidden email]]
> >> > Sent: Tuesday, January 19, 2010 12:44 PM
> >> > To: [hidden email]
> >> > Subject: Re: Query regarding BIRT report generation in OFBiz
> >> >
> >> > I can only advise you to study the existing reports, especially how the
> >> > data is retrieved with minilanguage.
> >> >
> >> > Regards,
> >> > Hans
> >> >
> >> > On Tue, 2010-01-19 at 12:28 +0530, Ashish Tiwari wrote:
> >> > > Hi Hans,
> >> > >
> >> > > what I have done so far is:
> >> > >
> >> > > 1. I have generated a .rptdesign file through Birt RCP designer 2_5_1.
> >> > > 2. Now in ofbiz I m trying to display this report file.
> >> > > 3.When I try to display the default .rptdesign file provided in ofbiz
> >> i.e. product.rptdesign file it is successfully displayed in ofbiz.
> >> > > 4. But when I try to display the .rptdesign file generated by me in
> >> RCP designer I get an error i.e.
> >> > >
> >> > > Cannot find or process the
> >> org.eclipse.birt.report.data.oda.jdbc driver's data source extension
> >> configuration.
> >> > > org.eclipse.birt.report.data.oda.jdbc
> >> > >
> >> > > 5. While trying to resolve this error I compared the two .rptdesign
> >> file and found some differences which are:
> >> > >
> >> > > product.rptdesign(Default file in OFbiz)
> >>
> >> test.rptdesign(generated in RCP designer)
> >> > >
> >> > > I) <data-sources>
> >> <data-sources>
> >> > > <script-data-source name="OFBiz" id="8"/> <oda-data-source
> >> extensionID="org.eclipse.birt.report.data.oda.jdbc"
> >> > >
> >> name="Data Source" id="9">
> >> > >
> >> > > </data-sources>
> >> > >
> >> > >
> >> > > 2) <data-sets>
> >> > > <script-data-set name="Product" id="9"> <data-sets>
> >> > > <oda-data-set
> >> > >
> >> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet"
> >> > >
> >> name="Data Set" id="43">
> >> > >
> >> > > Also in the default file there some code (looks like groovy code)is
> >> written to fetch the field values but no such code is there in the file
> >> generated in RCP designer.
> >> > >
> >> > > Please help me out in resolving this problem.
> >> > >
> >> > >
> >> > >
> >> > > ________________________________
> >> > > 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.
> >> > >
> >> > > ______________________________________________________________________
> >> > --
> >> > Antwebsystems.com: Quality OFBiz services for competitive rates
> >> >
> >> >
> >> > ______________________________________________________________________
> >> >
> >> > 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.
> >> >
> >> > ______________________________________________________________________
> >> --
> >> Antwebsystems.com: Quality OFBiz services for competitive rates
> >>
> >>
> >

--
Antwebsystems.com: Quality OFBiz services for competitive rates