I am looking for a report generator which will do something rather complex, and Telerik reporting looks like it can probably do what is needed, but I'd like to confirm.
For the sake of an example, presume I have a large order, with items that have a price, a quantity, and a line price. The descriptions may be big and there are many pages, perhaps 20 or so in the printout. Each page must have, at the bottom of the page, the sub-total for that page (adding all the line prices). This part is shown in the online invoice demonstration, so is indeed possible.
At the end of the report, the last page(s) should have the page numbers and their values, so:
page 1 $2,000
page 2 $3,202
page 3 $2,039
Now, I think that it should be possible for the page totals to be picked up in the ItemDataBound events, and perhaps added to a list somehow which is then picked up at the end to be fed into the final section of the report. Am I right? Is this viable, or is it pushing it too far? Can a report even have multiple sections so that the last section can be inserted (sort of like two reports in one?).
I appreciate any thoughts anyone might have. Thank you.
1 Answer, 1 is accepted
You can calculate the values for the pages scope with the help of PageExec() function.
However, carrying over the value from the previous pages is not supported.
The Report engine evaluates all the expressions within the report before the paging mechanism is applied - at report processing stage. And after that at rendering stage, the report is paged. You can review Report Life Cycle help article for more detailed information.
On the other hand, you can extend the existing expression engine with your own custom functions - Extending Expressions. Consider the example in Carryover, page sum on top of next page.
Regards,
Katia
Telerik