I have a complex Parent -> 4 child table set. Child table amounts are totaled and inserted in parent record via script (Set Field Value) and an I have a report based on the set. Everything works fine. I changed the parent fields from user enter to calc field (in field rule) with DBSum() to compute the sum of child records. This provides the same result as before. ie each field in child table is totalled and inserted in the appropriate parent field. The problem arises when I try to preview the report.
I get the following errors ( in trace window)
Warning [1]: Error(s) opening rules for field: TOTCHARGES
Warning [2]: Error adding calculated rule to database engine.
Warning [3]: Error(s) opening rules for field: CASH2AGE
Warning [4]: Error adding calculated rule to database engine.
Warning [5]: Error(s) opening rules for field: CHECK2AGE
Warning [6]: Error adding calculated rule to database engine.
When the invoice is created and previewed the first time an error message pops up saying 6 errors see trace window.
However once passed the error message the report previews correctly and prints correctly. Previewing the same invoice a 2nd time does not produce the error. The error occurs on the 1st preview only. The invoice is created without any issue, it's just the 1st preview of every new invoice.
I recreated a new set trying to reproduce the problem but could not reproduce the issue.
Any idea what this type of error message mean?
Warning [1]: Error(s) opening rules for field: XXXX
Warning [2]: Error adding calculated rule to database engine
I get the following errors ( in trace window)
Warning [1]: Error(s) opening rules for field: TOTCHARGES
Warning [2]: Error adding calculated rule to database engine.
Warning [3]: Error(s) opening rules for field: CASH2AGE
Warning [4]: Error adding calculated rule to database engine.
Warning [5]: Error(s) opening rules for field: CHECK2AGE
Warning [6]: Error adding calculated rule to database engine.
When the invoice is created and previewed the first time an error message pops up saying 6 errors see trace window.
However once passed the error message the report previews correctly and prints correctly. Previewing the same invoice a 2nd time does not produce the error. The error occurs on the 1st preview only. The invoice is created without any issue, it's just the 1st preview of every new invoice.
I recreated a new set trying to reproduce the problem but could not reproduce the issue.
Any idea what this type of error message mean?
Warning [1]: Error(s) opening rules for field: XXXX
Warning [2]: Error adding calculated rule to database engine
Comment