Build a Multi-Step Function in a Report Definition
We are trying to build a report definition to calculate some values to return and be available to another application referencing ours. The issue I am encountering is that I need to take multiple properties to come up with a "sum" to display in the report. I've listed the equation that I would like to create in the report definition, but have not found a way to produce the desired result.
I don't know if calculating all that in the Report Definition directly is the best approach. Would be easiest to run the report get the data back and then launch Declare Expressions for your calculations and finally present all that on a repeating SECTION.
Really appreciate the feedback here. Building the Declare Expression and then calling it based on the reporting details look like it will get us what we need. Good stuff and will make the nice addition to the client's UI that we were looking for.