Hi all,
I have a report with a nested report. On my computer in the development environment, when I run the report, I get the correct information. But when my customer runs the report (compiled in a pbd), he gets the wrong value for one of the fields.
In the invoice table, there 4 fields extracted: invoice_nbr, lab_total, taxable_total, and tax_rate. On the report there's a computed field cf_tax.
When customer runs the report, the values in the database are:
invoice_nbr: 200027140
lab_totall: 2860.00
taxable_total: 2860.00
tax_rate: 0.065
cf_tax: 185.90
But the report is showing the taxable_total as 0.07 ... even though that's not what's in the database. And the taxable total is showing correctly on the report, 185.90. I triple checked to make sure the taxable_total was indeed the field that was displaying.
Any ideas? I fixed it by adding a computed field, cf_taxable_total that is just round(taxable_total, 2). But still would like to know why this happened?
TIA,
~~~Tracy
~~~Tracy