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 mailingl...@antwebsystems.comwrote: 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
RE: Query regarding BIRT report generation in OFBiz
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:mailingl...@antwebsystems.com] Sent: Tuesday, January 19, 2010 12:44 PM To: user@ofbiz.apache.org 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. __
RE: Query regarding BIRT report generation in OFBiz
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:mailingl...@antwebsystems.com] Sent: Tuesday, January 19, 2010 12:44 PM To: user@ofbiz.apache.org 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
Re: Query regarding BIRT report generation in OFBiz
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 mailingl...@antwebsystems.comwrote: 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 mailingl...@antwebsystems.comwrote: 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
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 mailingl...@antwebsystems.comwrote: 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:mailingl...@antwebsystems.com] Sent: Tuesday, January 19, 2010 12:44 PM To: user@ofbiz.apache.org 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
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) dong...@wizitsoft.comwrote: 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 mailingl...@antwebsystems.com 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:mailingl...@antwebsystems.com] Sent: Tuesday, January 19, 2010 12:44 PM To: user@ofbiz.apache.org 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
Re: Query regarding BIRT report generation in OFBiz
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 mailingl...@antwebsystems.comwrote: 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:mailingl...@antwebsystems.com] Sent: Tuesday, January 19, 2010 12:44 PM To: user@ofbiz.apache.org 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
Re: Query regarding BIRT report generation in OFBiz
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) dong...@wizitsoft.comwrote: 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 mailingl...@antwebsystems.com 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:mailingl...@antwebsystems.com] Sent: Tuesday, January 19, 2010 12:44 PM To: user@ofbiz.apache.org 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
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. __
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
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 mailingl...@antwebsystems.comwrote: 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
