General information
Category:
Reports & Report designer
Roleaux,
How is the field with QTY*UnitCost formatted? Try 999999999.999999999 and make the field really wide. Funny things happen when the field isn't wide enough. Once you get something to show, you can adjust back to reality. It's OK for fields to overlap.
One more thing, you can watch values of report variables in the locals or debug windows as you page through the report.
If you still have trouble, re-post with more details.
>I'm have a table with three records for every customer. I want to add the total of the three amounts together and print it out on the report grouping the records on the customer. each record is a different item that was sold to that customer. The QTY ordered field has one decimal place and the unitCost has 2 decimals. When I * the QTY*Unitcost I get an answer like 116.0000 the Sum field on the report Prints only zeros.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only