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 <[email protected]>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 > > <[email protected]>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 > >
