I have a hierarchy of related tables and many values are calculated based on values in parent tables. The formulas are complex and are hosted in data pages.
My reports all have calculated fields as results fields, otherwise the reports would be showing 'old' 'table' values. Each record is modified in the reports' details form pages. This means that the actual records are only updated when the user opens the details page and then save it. With a large volume of records, this is not practical.
The user may think all values are up to date as reports show the calculated values, but the underlying tables carry other values.
Question:
1. I need a way to update all table fields, based on the formulas in the reports, when user loads a report. How can this be done?
2. What is the best practice for keeping records up to date when adjacent table values change? Is there a better way to show updated values in the report results page? It seems I can't perform the recalculation and write to the actual fields in the report results page, the report can only show a table value or perform a calculation that is not stored in the table.
3. One option could be Triggered Action, but it is like developing a shadow app. Since my formulas are data page-based, and triggered actions work on table level, this might not work even if I took the time. Are there techniques I don't know about for how to use TA's to do this?
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
KG360
Hi,
I have a hierarchy of related tables and many values are calculated based on values in parent tables. The formulas are complex and are hosted in data pages.
My reports all have calculated fields as results fields, otherwise the reports would be showing 'old' 'table' values. Each record is modified in the reports' details form pages. This means that the actual records are only updated when the user opens the details page and then save it. With a large volume of records, this is not practical.
The user may think all values are up to date as reports show the calculated values, but the underlying tables carry other values.
Question:
1. I need a way to update all table fields, based on the formulas in the reports, when user loads a report. How can this be done?
2. What is the best practice for keeping records up to date when adjacent table values change? Is there a better way to show updated values in the report results page? It seems I can't perform the recalculation and write to the actual fields in the report results page, the report can only show a table value or perform a calculation that is not stored in the table.
3. One option could be Triggered Action, but it is like developing a shadow app. Since my formulas are data page-based, and triggered actions work on table level, this might not work even if I took the time. Are there techniques I don't know about for how to use TA's to do this?
/G
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.