Access to subreport totals in main report

[David]

Currently doing an evaluation of Telerik reporting for use in an ASP.NET development.

Really struggling to see how to access the subreport data from the main report. All I want to do is display some totals from the subreports onto the main report. Really easy in SSRS or even Access, can't see a straightforward way in Telerik. Please help.

[KS]

Hi,

Check this - Access Items In Subreport Footer Section From Main Report

- KS

[David]

Thanks KS



I had spotted that article, but was hoping to be able to do it within the report designer. I then just need a report viewer and a bunch of report definition files to deploy. Once I start adding event handlers in this way, I then need (extra) code for all my reports that want to do this.



Pity.



- Dave

[KS]

Well, I dont remember it being a piece of cake ever - stackoverflow. Cannot say for MSAccess. 
The common solution is data oriented and possibly can be used with the enduser designer... Assembly with a model, having all relations (and custom totals). Then bindings to the linking collections - forum link.

The only coding will be the model, but it will be useful elsewhere.

-KS

[Sazan]

Hi David,

I have similar problem in SSRS 2012, I need to access the total page numbers in the subreport from the main report. can you help?

[Frank]

Dave and All,

If you find the solution from report designer, can you share ?

I want to know how to access sub report's item value from master report with in the standard report designer.

TIA

-FK

[Stef]

Hi FK,

Data can be transferred from parent to child element.

Having this into account you can organize data to have it on the main report's level. Then you can bind the sub report to the main report's data - How to bind Sub Report to Main Report's Data.
The idea of this is to have access to the fields in the main report to display aggregates on them.

Depending on the sub report, it can be replaced by a Table item in the main report to ease the data-binding:

• How to Databind to Collection Properties
• Use DataObject as a datasource for nested data items (Table, List, Crosstab, Graph) Steps:

Regards,
Stef
Telerik by Progress

[Frank]

Hi Stef,

I was looking into the other way around.

I want to get access sub report data from Main report.

Please let me know, if I am still missing your suggestion.

Thanks,

FK.

 

[Stef]

Hi FK,

Please check Expression scope. In general, sub reports are considered a content of the main report and their data scope is not accessible in the main report.

The options are to have the data on the main report's level, or to use PageExec function in the main report's PageHeader/Footer section - the function operates with data and items available on the current page.

Regards,
Stef
Telerik by Progress