Expression box vs. text box for calculations

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KLaw - 14 Jul 2006 16:31 GMT

I have a form for Purchase Orders and I have a repeating table with items to
be ordered. I would like to have an order total and have read every thread
about doing this. My dilemma is that in order to calculate the total
correctly, it seems that I need to use an expression box, but I want to store
the calculated value in my database; therefore it seems that I need to have
the total in a text box. The problem with a text box is that I can't seem to
get the calculation to work (I get a binding error that says "You have chosen
to bind a non-repeating control to a repeating field or group...". Then it
will only display the first item's extended cost instead of the desired
sum(@ExtendedCost). What am I doing wrong? Anyone?

Reply to this Message

Greg Collins [InfoPath MVP] - 17 Jul 2006 19:06 GMT

The error should give indication of what you need to do.

You have your field in a repeating group, yet on the form, you are placing the field by itself (not in a repeating group). Since it's not repeating in the view, it can only display one value (which in this case is the first value). To fix the issue, either make the group not repeating (probably not an option) or place the field in a repeating section/table in the view.

As a side note, since you want to store the calculated value, you definitely want text box and not expression box.

Signature

Greg Collins [Microsoft MVP]
Visit Brain Trove ( http://www.BrainTrove.com )
Visit InfoPathDev ( http://www.InfoPathDev.com )

Reply to this Message

KLaw - 19 Jul 2006 20:16 GMT

Thanks - it's always the obvious that I overlook!

> The error should give indication of what you need to do.
>
> You have your field in a repeating group, yet on the form, you are placing the field by itself (not in a repeating group). Since it's not repeating in the view, it can only display one value (which in this case is the first value). To fix the issue, either make the group not repeating (probably not an option) or place the field in a repeating section/table in the view.
>
> As a side note, since you want to store the calculated value, you definitely want text box and not expression box.

Reply to this Message