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

Access to subreport totals in main report

8 Answers 276 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
David
Top achievements
Rank 1
David asked on 16 Jan 2014, 05:49 PM

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.





8 Answers, 1 is accepted

Sort by
0
KS
Top achievements
Rank 1
answered on 21 Jan 2014, 01:48 PM
0
David
Top achievements
Rank 1
answered on 21 Jan 2014, 04:43 PM

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

0
KS
Top achievements
Rank 1
answered on 24 Jan 2014, 03:50 PM
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
0
Sazan
Top achievements
Rank 1
answered on 13 Oct 2016, 12:10 AM

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?

0
Frank
Top achievements
Rank 1
answered on 08 Dec 2016, 10:16 PM

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

0
Stef
Telerik team
answered on 12 Dec 2016, 02:31 PM
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:

Regards,
Stef
Telerik by Progress
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
Frank
Top achievements
Rank 1
answered on 12 Dec 2016, 03:55 PM

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.

 

0
Stef
Telerik team
answered on 13 Dec 2016, 03:31 PM
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
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
Report Designer (standalone)
Asked by
David
Top achievements
Rank 1
Answers by
KS
Top achievements
Rank 1
David
Top achievements
Rank 1
Sazan
Top achievements
Rank 1
Frank
Top achievements
Rank 1
Stef
Telerik team
Share this question
or