This is a migrated thread and some comments may be shown as answers.

Subreport Carryover & Pagesum

3 Answers 117 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Corey
Top achievements
Rank 1
Corey asked on 30 Mar 2016, 04:19 PM

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.  

3 Answers, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 31 Mar 2016, 05:06 PM
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
0
Corey
Top achievements
Rank 1
answered on 31 Mar 2016, 10:46 PM
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.
0
Stef
Telerik team
answered on 05 Apr 2016, 12:04 PM
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
Tags
General Discussions
Asked by
Corey
Top achievements
Rank 1
Answers by
Stef
Telerik team
Corey
Top achievements
Rank 1
Share this question
or