how to do group and subgroup in FOP report?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
48 messages Options
123
Reply | Threaded
Open this post in threaded view
|

how to do group and subgroup in FOP report?

edward wang
Hi Folks,

I am going to generate PDF report using FOP, but from all examples in ofbiz,
i don't see group or subgroup examples.
I need for each orderId and party name as a group, its product name, qty
,and unit price as a subgroup.
  Could you tell me some examples? or links?
Thank you !

  Chwang
Reply | Threaded
Open this post in threaded view
|

Re: how to do group and subgroup in FOP report?

hans_bakker
How about using Birt for this?

On Mon, 2010-05-24 at 17:25 -0600, edward wang wrote:

> Hi Folks,
>
> I am going to generate PDF report using FOP, but from all examples in ofbiz,
> i don't see group or subgroup examples.
> I need for each orderId and party name as a group, its product name, qty
> ,and unit price as a subgroup.
>   Could you tell me some examples? or links?
> Thank you !
>
>   Chwang

--
Ofbiz on twitter: http://twitter.com/apache_ofbiz
Myself on twitter: http://twitter.com/hansbak
Antwebsystems.com: Quality services for competitive rates.

Reply | Threaded
Open this post in threaded view
|

Re: how to do group and subgroup in FOP report?

edward wang
thank you. I don't know much about BIRT.

Is FOP not powerful as BIRT?
Please Help.

Chwang

On Mon, May 24, 2010 at 7:01 PM, Hans Bakker
<[hidden email]>wrote:

> How about using Birt for this?
>
> On Mon, 2010-05-24 at 17:25 -0600, edward wang wrote:
> > Hi Folks,
> >
> > I am going to generate PDF report using FOP, but from all examples in
> ofbiz,
> > i don't see group or subgroup examples.
> > I need for each orderId and party name as a group, its product name, qty
> > ,and unit price as a subgroup.
> >   Could you tell me some examples? or links?
> > Thank you !
> >
> >   Chwang
>
> --
> Ofbiz on twitter: http://twitter.com/apache_ofbiz
> Myself on twitter: http://twitter.com/hansbak
> Antwebsystems.com: Quality services for competitive rates.
>
>
Reply | Threaded
Open this post in threaded view
|

Re: how to do group and subgroup in FOP report?

hans_bakker
MUCH more powerfull, but yes sorry you have to invest some learning
time.......


On Mon, 2010-05-24 at 21:04 -0600, edward wang wrote:

> thank you. I don't know much about BIRT.
>
> Is FOP not powerful as BIRT?
> Please Help.
>
> Chwang
>
> On Mon, May 24, 2010 at 7:01 PM, Hans Bakker
> <[hidden email]>wrote:
>
> > How about using Birt for this?
> >
> > On Mon, 2010-05-24 at 17:25 -0600, edward wang wrote:
> > > Hi Folks,
> > >
> > > I am going to generate PDF report using FOP, but from all examples in
> > ofbiz,
> > > i don't see group or subgroup examples.
> > > I need for each orderId and party name as a group, its product name, qty
> > > ,and unit price as a subgroup.
> > >   Could you tell me some examples? or links?
> > > Thank you !
> > >
> > >   Chwang
> >
> > --
> > Ofbiz on twitter: http://twitter.com/apache_ofbiz
> > Myself on twitter: http://twitter.com/hansbak
> > Antwebsystems.com: Quality services for competitive rates.
> >
> >

--
Ofbiz on twitter: http://twitter.com/apache_ofbiz
Myself on twitter: http://twitter.com/hansbak
Antwebsystems.com: Quality services for competitive rates.

Reply | Threaded
Open this post in threaded view
|

Re: how to do group and subgroup in FOP report?

james_sg
In reply to this post by edward wang
Have you look at those FOP reports from applications like Order, Accounting etc?

chaohua wang wrote
Hi Folks,

I am going to generate PDF report using FOP, but from all examples in ofbiz,
i don't see group or subgroup examples.
I need for each orderId and party name as a group, its product name, qty
,and unit price as a subgroup.
  Could you tell me some examples? or links?
Thank you !

  Chwang
Reply | Threaded
Open this post in threaded view
|

Re: how to do group and subgroup in FOP report?

edward wang
In reply to this post by hans_bakker
thanks,
I just learned birt, got an idea how to generate a report using Birt. but
not sure how offbiz to call birt to generate  report.
could you tell me some examples to connect ofbiz to birt?

chwang

On Mon, May 24, 2010 at 9:21 PM, Hans Bakker
<[hidden email]>wrote:

> MUCH more powerfull, but yes sorry you have to invest some learning
> time.......
>
>
> On Mon, 2010-05-24 at 21:04 -0600, edward wang wrote:
> > thank you. I don't know much about BIRT.
> >
> > Is FOP not powerful as BIRT?
> > Please Help.
> >
> > Chwang
> >
> > On Mon, May 24, 2010 at 7:01 PM, Hans Bakker
> > <[hidden email]>wrote:
> >
> > > How about using Birt for this?
> > >
> > > On Mon, 2010-05-24 at 17:25 -0600, edward wang wrote:
> > > > Hi Folks,
> > > >
> > > > I am going to generate PDF report using FOP, but from all examples in
> > > ofbiz,
> > > > i don't see group or subgroup examples.
> > > > I need for each orderId and party name as a group, its product name,
> qty
> > > > ,and unit price as a subgroup.
> > > >   Could you tell me some examples? or links?
> > > > Thank you !
> > > >
> > > >   Chwang
> > >
> > > --
> > > Ofbiz on twitter: http://twitter.com/apache_ofbiz
> > > Myself on twitter: http://twitter.com/hansbak
> > > Antwebsystems.com: Quality services for competitive rates.
> > >
> > >
>
> --
> Ofbiz on twitter: http://twitter.com/apache_ofbiz
> Myself on twitter: http://twitter.com/hansbak
> Antwebsystems.com: Quality services for competitive rates.
>
>
Reply | Threaded
Open this post in threaded view
|

Re: how to do group and subgroup in FOP report?

Deyan Tsvetanov-3
Birt uses a servlet to generate the .PDF files from a .rptdesign file.

Create web application, register the BIRT servlet in web.inf and invoke
it from a web browser as shown in the BIRT examples.

If you need security you should configure a servlet filter that handles
it.

Regards,
Deyan

On Mon, 2010-05-24 at 21:55 -0600, edward wang wrote:

> thanks,
> I just learned birt, got an idea how to generate a report using Birt. but
> not sure how offbiz to call birt to generate  report.
> could you tell me some examples to connect ofbiz to birt?
>
> chwang
>
> On Mon, May 24, 2010 at 9:21 PM, Hans Bakker
> <[hidden email]>wrote:
>
> > MUCH more powerfull, but yes sorry you have to invest some learning
> > time.......
> >
> >
> > On Mon, 2010-05-24 at 21:04 -0600, edward wang wrote:
> > > thank you. I don't know much about BIRT.
> > >
> > > Is FOP not powerful as BIRT?
> > > Please Help.
> > >
> > > Chwang
> > >
> > > On Mon, May 24, 2010 at 7:01 PM, Hans Bakker
> > > <[hidden email]>wrote:
> > >
> > > > How about using Birt for this?
> > > >
> > > > On Mon, 2010-05-24 at 17:25 -0600, edward wang wrote:
> > > > > Hi Folks,
> > > > >
> > > > > I am going to generate PDF report using FOP, but from all examples in
> > > > ofbiz,
> > > > > i don't see group or subgroup examples.
> > > > > I need for each orderId and party name as a group, its product name,
> > qty
> > > > > ,and unit price as a subgroup.
> > > > >   Could you tell me some examples? or links?
> > > > > Thank you !
> > > > >
> > > > >   Chwang
> > > >
> > > > --
> > > > Ofbiz on twitter: http://twitter.com/apache_ofbiz
> > > > Myself on twitter: http://twitter.com/hansbak
> > > > Antwebsystems.com: Quality services for competitive rates.
> > > >
> > > >
> >
> > --
> > Ofbiz on twitter: http://twitter.com/apache_ofbiz
> > Myself on twitter: http://twitter.com/hansbak
> > Antwebsystems.com: Quality services for competitive rates.
> >
> >


Reply | Threaded
Open this post in threaded view
|

Re: how to do group and subgroup in FOP report?

hans_bakker
no need to do that, all is already in OFBiz

for a further explanation look at:

http://demo-trunk.ofbiz.apache.org/cmssite/cms/APACHE_OFBIZ_HTML#N234CB

wbe patient because it is a big page.....the same info is also in the
helpscreens of the birt screen in the example component.

Regards,
Hans

--
Ofbiz on twitter: http://twitter.com/apache_ofbiz
Myself on twitter: http://twitter.com/hansbak
Antwebsystems.com: Quality services for competitive rates.

On Tue, 2010-05-25 at 07:04 +0300, Deyan Tsvetanov wrote:

> Birt uses a servlet to generate the .PDF files from a .rptdesign file.
>
> Create web application, register the BIRT servlet in web.inf and invoke
> it from a web browser as shown in the BIRT examples.
>
> If you need security you should configure a servlet filter that handles
> it.
>
> Regards,
> Deyan
>
> On Mon, 2010-05-24 at 21:55 -0600, edward wang wrote:
> > thanks,
> > I just learned birt, got an idea how to generate a report using Birt. but
> > not sure how offbiz to call birt to generate  report.
> > could you tell me some examples to connect ofbiz to birt?
> >
> > chwang
> >
> > On Mon, May 24, 2010 at 9:21 PM, Hans Bakker
> > <[hidden email]>wrote:
> >
> > > MUCH more powerfull, but yes sorry you have to invest some learning
> > > time.......
> > >
> > >
> > > On Mon, 2010-05-24 at 21:04 -0600, edward wang wrote:
> > > > thank you. I don't know much about BIRT.
> > > >
> > > > Is FOP not powerful as BIRT?
> > > > Please Help.
> > > >
> > > > Chwang
> > > >
> > > > On Mon, May 24, 2010 at 7:01 PM, Hans Bakker
> > > > <[hidden email]>wrote:
> > > >
> > > > > How about using Birt for this?
> > > > >
> > > > > On Mon, 2010-05-24 at 17:25 -0600, edward wang wrote:
> > > > > > Hi Folks,
> > > > > >
> > > > > > I am going to generate PDF report using FOP, but from all examples in
> > > > > ofbiz,
> > > > > > i don't see group or subgroup examples.
> > > > > > I need for each orderId and party name as a group, its product name,
> > > qty
> > > > > > ,and unit price as a subgroup.
> > > > > >   Could you tell me some examples? or links?
> > > > > > Thank you !
> > > > > >
> > > > > >   Chwang
> > > > >
> > > > > --
> > > > > Ofbiz on twitter: http://twitter.com/apache_ofbiz
> > > > > Myself on twitter: http://twitter.com/hansbak
> > > > > Antwebsystems.com: Quality services for competitive rates.
> > > > >
> > > > >
> > >
> > > --
> > > Ofbiz on twitter: http://twitter.com/apache_ofbiz
> > > Myself on twitter: http://twitter.com/hansbak
> > > Antwebsystems.com: Quality services for competitive rates.
> > >
> > >
>
>



Reply | Threaded
Open this post in threaded view
|

Re: how to do group and subgroup in FOP report?

Deyan Tsvetanov-3
In reply to this post by Deyan Tsvetanov-3
web.inf = web.xml
:)



On Tue, 2010-05-25 at 07:04 +0300, Deyan Tsvetanov wrote:

> Birt uses a servlet to generate the .PDF files from a .rptdesign file.
>
> Create web application, register the BIRT servlet in web.inf and invoke
> it from a web browser as shown in the BIRT examples.
>
> If you need security you should configure a servlet filter that handles
> it.
>
> Regards,
> Deyan
>
> On Mon, 2010-05-24 at 21:55 -0600, edward wang wrote:
> > thanks,
> > I just learned birt, got an idea how to generate a report using Birt. but
> > not sure how offbiz to call birt to generate  report.
> > could you tell me some examples to connect ofbiz to birt?
> >
> > chwang
> >
> > On Mon, May 24, 2010 at 9:21 PM, Hans Bakker
> > <[hidden email]>wrote:
> >
> > > MUCH more powerfull, but yes sorry you have to invest some learning
> > > time.......
> > >
> > >
> > > On Mon, 2010-05-24 at 21:04 -0600, edward wang wrote:
> > > > thank you. I don't know much about BIRT.
> > > >
> > > > Is FOP not powerful as BIRT?
> > > > Please Help.
> > > >
> > > > Chwang
> > > >
> > > > On Mon, May 24, 2010 at 7:01 PM, Hans Bakker
> > > > <[hidden email]>wrote:
> > > >
> > > > > How about using Birt for this?
> > > > >
> > > > > On Mon, 2010-05-24 at 17:25 -0600, edward wang wrote:
> > > > > > Hi Folks,
> > > > > >
> > > > > > I am going to generate PDF report using FOP, but from all examples in
> > > > > ofbiz,
> > > > > > i don't see group or subgroup examples.
> > > > > > I need for each orderId and party name as a group, its product name,
> > > qty
> > > > > > ,and unit price as a subgroup.
> > > > > >   Could you tell me some examples? or links?
> > > > > > Thank you !
> > > > > >
> > > > > >   Chwang
> > > > >
> > > > > --
> > > > > Ofbiz on twitter: http://twitter.com/apache_ofbiz
> > > > > Myself on twitter: http://twitter.com/hansbak
> > > > > Antwebsystems.com: Quality services for competitive rates.
> > > > >
> > > > >
> > >
> > > --
> > > Ofbiz on twitter: http://twitter.com/apache_ofbiz
> > > Myself on twitter: http://twitter.com/hansbak
> > > Antwebsystems.com: Quality services for competitive rates.
> > >
> > >
>
>


Reply | Threaded
Open this post in threaded view
|

Postgresql errors with trunk, any ideas?

Matt Warnock
In reply to this post by hans_bakker
Trying to get trunk working with postgresql 8.3 under Debian stable, sun
java 1.6.0_12-b04, and I get several similar errors in the logs:

---- exception report
----------------------------------------------------------
Could not convert field value for the field:
[newEntity.accountingQuantityDiff] to the [BigDecimal] type for the
value [0]: org.ofbiz.base.util.GeneralException: Conversion from
java.lang.String to BigDecimal not currently supported

---- exception report
----------------------------------------------------------
Exception: java.lang.ClassNotFoundException
Message: No converter found for java.math.BigDecimal->java.lang.Long

Exception: org.ofbiz.base.util.GeneralException
Message: Conversion from java.lang.String to BigDecimal not currently
supported

Is there something I need to do to add the needed library?

I also get errors like the following:

---- exception report
----------------------------------------------------------
Error storing value
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception occurred on commit (Commit can not be set while
enrolled in a transaction)
---- cause
---------------------------------------------------------------------
Exception: java.sql.SQLException
Message: Commit can not be set while enrolled in a transaction

This last one sounds like "Auto-Commit can not be set while in a
transaction", which would make sense if auto-commit was not being turned
off properly, but how could that be?

Alternatively, is this somehow related to the nested transactions issue
we found with Mysql last week?


Anybody have any ideas, or at least have trunk working with Postgresql?


--
Matt Warnock <[hidden email]>
RidgeCrest Herbals, Inc.



Reply | Threaded
Open this post in threaded view
|

Re: Postgresql errors with trunk, any ideas?

Deyan Tsvetanov-3
Which driver version are you using ?



On Tue, 2010-05-25 at 00:10 -0600, Matt Warnock wrote:

> Trying to get trunk working with postgresql 8.3 under Debian stable, sun
> java 1.6.0_12-b04, and I get several similar errors in the logs:
>
> ---- exception report
> ----------------------------------------------------------
> Could not convert field value for the field:
> [newEntity.accountingQuantityDiff] to the [BigDecimal] type for the
> value [0]: org.ofbiz.base.util.GeneralException: Conversion from
> java.lang.String to BigDecimal not currently supported
>
> ---- exception report
> ----------------------------------------------------------
> Exception: java.lang.ClassNotFoundException
> Message: No converter found for java.math.BigDecimal->java.lang.Long
>
> Exception: org.ofbiz.base.util.GeneralException
> Message: Conversion from java.lang.String to BigDecimal not currently
> supported
>
> Is there something I need to do to add the needed library?
>
> I also get errors like the following:
>
> ---- exception report
> ----------------------------------------------------------
> Error storing value
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception occurred on commit (Commit can not be set while
> enrolled in a transaction)
> ---- cause
> ---------------------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
>
> This last one sounds like "Auto-Commit can not be set while in a
> transaction", which would make sense if auto-commit was not being turned
> off properly, but how could that be?
>
> Alternatively, is this somehow related to the nested transactions issue
> we found with Mysql last week?
>
>
> Anybody have any ideas, or at least have trunk working with Postgresql?
>
>


Reply | Threaded
Open this post in threaded view
|

Re: Postgresql errors with trunk, any ideas?

Deepak Dixit-2
In reply to this post by Matt Warnock
Hi Matt,

Have you used latest version of ant (1.7.1)?

try to build application using internal ant (./ant)

Regards
--
Deepak Dixit
HotWax Media Pvt. Ltd.
Website :- www.hotwaxmedia.com
Contact :- +91-98267-54548
Skype Id :- deepakdixit


Matt Warnock wrote:

> Trying to get trunk working with postgresql 8.3 under Debian stable, sun
> java 1.6.0_12-b04, and I get several similar errors in the logs:
>
> ---- exception report
> ----------------------------------------------------------
> Could not convert field value for the field:
> [newEntity.accountingQuantityDiff] to the [BigDecimal] type for the
> value [0]: org.ofbiz.base.util.GeneralException: Conversion from
> java.lang.String to BigDecimal not currently supported
>
> ---- exception report
> ----------------------------------------------------------
> Exception: java.lang.ClassNotFoundException
> Message: No converter found for java.math.BigDecimal->java.lang.Long
>
> Exception: org.ofbiz.base.util.GeneralException
> Message: Conversion from java.lang.String to BigDecimal not currently
> supported
>
> Is there something I need to do to add the needed library?
>
> I also get errors like the following:
>
> ---- exception report
> ----------------------------------------------------------
> Error storing value
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception occurred on commit (Commit can not be set while
> enrolled in a transaction)
> ---- cause
> ---------------------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
>
> This last one sounds like "Auto-Commit can not be set while in a
> transaction", which would make sense if auto-commit was not being turned
> off properly, but how could that be?
>
> Alternatively, is this somehow related to the nested transactions issue
> we found with Mysql last week?
>
>
> Anybody have any ideas, or at least have trunk working with Postgresql?
>
>
>  


Reply | Threaded
Open this post in threaded view
|

Re: Postgresql errors with trunk, any ideas?

BJ Freeman
In reply to this post by hans_bakker
running trunk 930580
using postgresql 8.1
CentOS Linux 5.4
OpenJDK  Runtime Environment (build 1.6.0-b09)


=========================
BJ Freeman
http://bjfreeman.elance.com
Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=93>
Specialtymarket.com <http://www.specialtymarket.com/>

Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man
Linkedin
<http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro>


Matt Warnock sent the following on 5/24/2010 11:10 PM:

> Trying to get trunk working with postgresql 8.3 under Debian stable, sun
> java 1.6.0_12-b04, and I get several similar errors in the logs:
>
> ---- exception report
> ----------------------------------------------------------
> Could not convert field value for the field:
> [newEntity.accountingQuantityDiff] to the [BigDecimal] type for the
> value [0]: org.ofbiz.base.util.GeneralException: Conversion from
> java.lang.String to BigDecimal not currently supported
>
> ---- exception report
> ----------------------------------------------------------
> Exception: java.lang.ClassNotFoundException
> Message: No converter found for java.math.BigDecimal->java.lang.Long
>
> Exception: org.ofbiz.base.util.GeneralException
> Message: Conversion from java.lang.String to BigDecimal not currently
> supported
>
> Is there something I need to do to add the needed library?
>
> I also get errors like the following:
>
> ---- exception report
> ----------------------------------------------------------
> Error storing value
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception occurred on commit (Commit can not be set while
> enrolled in a transaction)
> ---- cause
> ---------------------------------------------------------------------
> Exception: java.sql.SQLException
> Message: Commit can not be set while enrolled in a transaction
>
> This last one sounds like "Auto-Commit can not be set while in a
> transaction", which would make sense if auto-commit was not being turned
> off properly, but how could that be?
>
> Alternatively, is this somehow related to the nested transactions issue
> we found with Mysql last week?
>
>
> Anybody have any ideas, or at least have trunk working with Postgresql?
>
>


Reply | Threaded
Open this post in threaded view
|

Re: Postgresql errors with trunk, any ideas?

Matt Warnock
In reply to this post by Deyan Tsvetanov-3
I am using 8.4-701, the target downloaded by "ant download-PG-JDBC".
According to http://jdbc.postgresql.org/download.html, it should be good
for Java 1.4 and newer, and PG 7.2 and newer.
--
Matt Warnock <[hidden email]>
RidgeCrest Herbals, Inc.

On Tue, 2010-05-25 at 09:14 +0300, Deyan Tsvetanov wrote:

> Which driver version are you using ?
>
>
>
> On Tue, 2010-05-25 at 00:10 -0600, Matt Warnock wrote:
> > Trying to get trunk working with postgresql 8.3 under Debian stable, sun
> > java 1.6.0_12-b04, and I get several similar errors in the logs:
> >
> > ---- exception report
> > ----------------------------------------------------------
> > Could not convert field value for the field:
> > [newEntity.accountingQuantityDiff] to the [BigDecimal] type for the
> > value [0]: org.ofbiz.base.util.GeneralException: Conversion from
> > java.lang.String to BigDecimal not currently supported
> >
> > ---- exception report
> > ----------------------------------------------------------
> > Exception: java.lang.ClassNotFoundException
> > Message: No converter found for java.math.BigDecimal->java.lang.Long
> >
> > Exception: org.ofbiz.base.util.GeneralException
> > Message: Conversion from java.lang.String to BigDecimal not currently
> > supported
> >
> > Is there something I need to do to add the needed library?
> >
> > I also get errors like the following:
> >
> > ---- exception report
> > ----------------------------------------------------------
> > Error storing value
> > Exception: org.ofbiz.entity.GenericDataSourceException
> > Message: SQL Exception occurred on commit (Commit can not be set while
> > enrolled in a transaction)
> > ---- cause
> > ---------------------------------------------------------------------
> > Exception: java.sql.SQLException
> > Message: Commit can not be set while enrolled in a transaction
> >
> > This last one sounds like "Auto-Commit can not be set while in a
> > transaction", which would make sense if auto-commit was not being turned
> > off properly, but how could that be?
> >
> > Alternatively, is this somehow related to the nested transactions issue
> > we found with Mysql last week?
> >
> >
> > Anybody have any ideas, or at least have trunk working with Postgresql?
> >
> >
>

Reply | Threaded
Open this post in threaded view
|

Re: Postgresql errors with trunk, any ideas?

Matt Warnock
In reply to this post by Deepak Dixit-2
That seems to have solved that issue.  Thanks Deepak!

Debian uses ant 1.7.0.  I must have forgotten the ./ant.  I notice that
the internal ant shell script is much simpler than the one Debian uses,
do they both just call java with the right jar file?

--
Matt Warnock <[hidden email]>
RidgeCrest Herbals, Inc.

On Tue, 2010-05-25 at 11:45 +0530, Deepak Dixit wrote:
> Hi Matt,
>
> Have you used latest version of ant (1.7.1)?
>
> try to build application using internal ant (./ant)
>
> Regards

Reply | Threaded
Open this post in threaded view
|

Re: how to do group and subgroup in FOP report?

edward wang
In reply to this post by james_sg
James,

Thank you, Yes.  But not sure if they use group or subgroup in report. Could
you tell me these reports are using them?

Chwang

On Mon, May 24, 2010 at 9:34 PM, james_sg <[hidden email]> wrote:

>
> Have you look at those FOP reports from applications like Order, Accounting
> etc?
>
>
> chaohua wang wrote:
> >
> > Hi Folks,
> >
> > I am going to generate PDF report using FOP, but from all examples in
> > ofbiz,
> > i don't see group or subgroup examples.
> > I need for each orderId and party name as a group, its product name, qty
> > ,and unit price as a subgroup.
> >   Could you tell me some examples? or links?
> > Thank you !
> >
> >   Chwang
> >
> >
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/how-to-do-group-and-subgroup-in-FOP-report-tp2229348p2229471.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
Reply | Threaded
Open this post in threaded view
|

demo-trunk error changing Company address

Matt Warnock
Trying to update address of Company profile in trunk, I get this error:

Error trying to begin transaction, could not process method: The current
transaction is marked for rollback, not beginning a new transaction and
aborting current operation; the rollbackOnly was caused by: Service
[updateEftAccount] threw an unexpected
exception/errororg.ofbiz.service.ServiceValidationException: The
following required parameter is missing:
[updateEftAccount.nameOnAccount] (The following required parameter is
missing: [updateEftAccount.nameOnAccount])

demo-trunk shows same behavior.  Any suggestions?
--
Matt Warnock <[hidden email]>
RidgeCrest Herbals, Inc.



Reply | Threaded
Open this post in threaded view
|

Re: demo-trunk error changing Company address

BJ Freeman
In reply to this post by edward wang
here is the log just before the error to pinpoint the error.
2010-05-25 18:27:32,176 (TP-Processor36) [ ServiceEcaRule.java:151:INFO
] Running Service ECA Service: updatePaymentMethodAddress, triggered by
rule on Service: updatePostalAddress
2010-05-25 18:27:32,199 (TP-Processor36)
[ServiceEcaCondition.java:155:WARN ] From Field (expMonth) is not found
in context for updateCreditCard, defaulting to null.
2010-05-25 18:27:32,200 (TP-Processor36) [ ServiceEcaRule.java:134:INFO
] For Service ECA [updateCreditCard] on [in-validate] got false for
condition: [expMonth][is-not-empty][true][String]
2010-05-25 18:27:32,261 (TP-Processor36) [ ServiceEcaRule.java:151:INFO
] Running Service ECA Service: verifyCreditCard, triggered by rule on
Service: updateCreditCard
2010-05-25 18:27:32,262 (TP-Processor36)
[PaymentGatewayServices.java:3144:INFO ] Running verifyCreditCard [
10002] for store: null
2010-05-25 18:27:32,264 (TP-Processor36)
[PaymentGatewayServices.java:3160:INFO ] Running credit card
verification [10002] (0) : payment.properties : UPDATE
2010-05-25 18:27:32,264 (TP-Processor36) [
ServiceDispatcher.java:599:INFO ] Sync service
[partymgr/updateCreditCard] finished in [65] milliseconds


=========================
BJ Freeman
http://bjfreeman.elance.com
Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=93>
Specialtymarket.com <http://www.specialtymarket.com/>

Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man
Linkedin
<http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro>


Matt Warnock sent the following on 5/25/2010 10:26 AM:

> Trying to update address of Company profile in trunk, I get this error:
>
> Error trying to begin transaction, could not process method: The current
> transaction is marked for rollback, not beginning a new transaction and
> aborting current operation; the rollbackOnly was caused by: Service
> [updateEftAccount] threw an unexpected
> exception/errororg.ofbiz.service.ServiceValidationException: The
> following required parameter is missing:
> [updateEftAccount.nameOnAccount] (The following required parameter is
> missing: [updateEftAccount.nameOnAccount])
>
> demo-trunk shows same behavior.  Any suggestions?


Reply | Threaded
Open this post in threaded view
|

Re: demo-trunk error changing Company address

Matt Warnock
Thanks BJ.  

Looks like it already has a Jira issue, but it isn't fixed yet.  
https://issues.apache.org/jira/browse/OFBIZ-3485

Anybody know a workaround?

Why do we call updatePaymentMethodAddress if only a PostalAddress is
involved?  I haven't set up any payment methods yet, though maybe some
are already in the demo data.
--
Matt Warnock <[hidden email]>
RidgeCrest Herbals, Inc.

On Tue, 2010-05-25 at 10:52 -0700, BJ Freeman wrote:

> here is the log just before the error to pinpoint the error.
> 2010-05-25 18:27:32,176 (TP-Processor36) [ ServiceEcaRule.java:151:INFO
> ] Running Service ECA Service: updatePaymentMethodAddress, triggered by
> rule on Service: updatePostalAddress
> 2010-05-25 18:27:32,199 (TP-Processor36)
> [ServiceEcaCondition.java:155:WARN ] From Field (expMonth) is not found
> in context for updateCreditCard, defaulting to null.
> 2010-05-25 18:27:32,200 (TP-Processor36) [ ServiceEcaRule.java:134:INFO
> ] For Service ECA [updateCreditCard] on [in-validate] got false for
> condition: [expMonth][is-not-empty][true][String]
> 2010-05-25 18:27:32,261 (TP-Processor36) [ ServiceEcaRule.java:151:INFO
> ] Running Service ECA Service: verifyCreditCard, triggered by rule on
> Service: updateCreditCard
> 2010-05-25 18:27:32,262 (TP-Processor36)
> [PaymentGatewayServices.java:3144:INFO ] Running verifyCreditCard [
> 10002] for store: null
> 2010-05-25 18:27:32,264 (TP-Processor36)
> [PaymentGatewayServices.java:3160:INFO ] Running credit card
> verification [10002] (0) : payment.properties : UPDATE
> 2010-05-25 18:27:32,264 (TP-Processor36) [
> ServiceDispatcher.java:599:INFO ] Sync service
> [partymgr/updateCreditCard] finished in [65] milliseconds
>
>
> =========================
> BJ Freeman
> http://bjfreeman.elance.com
> Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=93>
> Specialtymarket.com <http://www.specialtymarket.com/>
>
> Systems Integrator-- Glad to Assist
>
> Chat  Y! messenger: bjfr33man
> Linkedin
> <http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro>
>
>
> Matt Warnock sent the following on 5/25/2010 10:26 AM:
> > Trying to update address of Company profile in trunk, I get this error:
> >
> > Error trying to begin transaction, could not process method: The current
> > transaction is marked for rollback, not beginning a new transaction and
> > aborting current operation; the rollbackOnly was caused by: Service
> > [updateEftAccount] threw an unexpected
> > exception/errororg.ofbiz.service.ServiceValidationException: The
> > following required parameter is missing:
> > [updateEftAccount.nameOnAccount] (The following required parameter is
> > missing: [updateEftAccount.nameOnAccount])
> >
> > demo-trunk shows same behavior.  Any suggestions?
>

Reply | Threaded
Open this post in threaded view
|

Re: demo-trunk error changing Company address

BJ Freeman
In reply to this post by BJ Freeman
I agree with you that the postal address must first be varified that it
matches then update.
most CC have and address component that needs update if you change the
contact mech address.
I think an reviews should go back to if the contact mech address is
linked to the cc entity. this way if that contact mech is updated none
of that is necessary.


=========================
BJ Freeman
http://bjfreeman.elance.com
Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=93>
Specialtymarket.com <http://www.specialtymarket.com/>

Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man
Linkedin
<http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro>


Matt Warnock sent the following on 5/25/2010 1:09 PM:

> Thanks BJ.  
>
> Looks like it already has a Jira issue, but it isn't fixed yet.  
> https://issues.apache.org/jira/browse/OFBIZ-3485
>
> Anybody know a workaround?
>
> Why do we call updatePaymentMethodAddress if only a PostalAddress is
> involved?  I haven't set up any payment methods yet, though maybe some
> are already in the demo data.


123