Access to subreport totals in main report

9 posts, 0 answers
  1. David
    David avatar
    2 posts
    Member since:
    Nov 2013

    Posted 16 Jan 2014 Link to this post

    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.





  2. KS
    KS avatar
    165 posts
    Member since:
    Oct 2012
  3. David
    David avatar
    2 posts
    Member since:
    Nov 2013

    Posted 21 Jan 2014 Link to this post

    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

  4. KS
    KS avatar
    165 posts
    Member since:
    Oct 2012

    Posted 24 Jan 2014 Link to this post

    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
  5. Sazan
    Sazan avatar
    1 posts
    Member since:
    Oct 2016

    Posted 12 Oct 2016 in reply to David Link to this post

    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?

  6. Frank
    Frank avatar
    2 posts
    Member since:
    Aug 2015

    Posted 08 Dec 2016 Link to this post

    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

  7. Stef
    Admin
    Stef avatar
    3474 posts

    Posted 12 Dec 2016 Link to this post

    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
  8. Frank
    Frank avatar
    2 posts
    Member since:
    Aug 2015

    Posted 12 Dec 2016 in reply to Stef Link to this post

    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.

     

  9. Stef
    Admin
    Stef avatar
    3474 posts

    Posted 13 Dec 2016 Link to this post

    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
Back to Top