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.