Subreport Carryover & Pagesum

4 posts, 0 answers
  1. Corey
    Corey avatar
    2 posts
    Member since:
    Oct 2013

    Posted 30 Mar Link to this post

    So I am currently trying to create a report for a client and have run into some issues with carryover on a sub report.  I used the example here(http://www.telerik.com/forums/carryover-page-sum-on-top-of-next-page) to get the report to work but when I inserted it as a subreport I realized that the headers and footers are not included.  I have attached an example of what I need the report to look like.  Are there any other alternatives to accomplish this?  

    If you look a the example you can see that there is a header that I need to appear on every page.  Under that header is a table that has the carryover at the top under the column headers and a running total at the bottom.  Unfortunately I don't have any flexibility on the layout of this report so I cant just make it look different.

    Thank you for any help you can provide.  

  2. Stef
    Admin
    Stef avatar
    3053 posts

    Posted 31 Mar Link to this post

    Hi Corey,

    The PageExec function operates with data in a given page. The approach discussed in Carryover, page sum on top of next page includes custom functions written in code, that can be adjusted based on your custom requirements.

    If the sub report contains only a Table item, you can ease the design by placing the item directly in the main report. Table/List/Crosstab items have their own DataSource properties which allows them to display data different than the main report's one. To filter data with the main report's fields, you can use the ReportItem.Parent.DataObject in expressions.


    I hope this information is helpful.

    Regards,
    Stef
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. DevCraft banner
  4. Corey
    Corey avatar
    2 posts
    Member since:
    Oct 2013

    Posted 31 Mar Link to this post

    Thank you, but I don't believe that solution will work.  The issue I am having is that I need to be able to do pageExec and some other functions in the body of the report, which I know is not possible.  I thought I had solved this issue by creating a sub report and doing the calculation in the header and footer.  Thats when I realized that the sub report doesn't process the header and footer.  So is there a way to do page level calculations outside of the header and footer.  If I had the option to create the report in a different format I would but the client is quite adamant on this design.  I have attached the exact report.  The highlighted areas are the ones that are causing issue.  Thank you for the help.
  5. Stef
    Admin
    Stef avatar
    3053 posts

    Posted 05 Apr Link to this post

    Hi Corey,

    Calculation per page can be executed only in the PageHeader/Footer sections of the main report. Sub reports page sections are not processed (just to confirm).

    If suitable test the following approaches:
    1. Use the Exec function with an aggregate to calculate totals for a report group or a whole data item like Table item (not per page only) - similar to Product Sales.
    2. Move the headers and footers (use TextBox items) in the PageHeader/Footer sections. This will let you display the desired totals. If the document should contain pages with various page sections' sizes, you can combine separate reports into a single document by using a ReportBook.


    Regards,
    Stef
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top