2 Subreport Group totals not appearing correctly in Main Report

Posted on 2011-10-20
Last Modified: 2012-05-12
I have 2 groups in a subreport...I need one to show in the Group Header  #1 of the Main Report and the other to show up in the Group Footer #2...

So confused
Question by:Mikeyman_01
    LVL 34

    Expert Comment

    When you say "2 groups in a subreport", do you mean 2 different groups on different fields, or one group with two different values (like you're grouping on a name and there are 2 names)?

     The groups in the subreport aren't the same as the groups in the main report?

     Where is the subreport located in the main report?

     What do you need to see?  Just a couple of totals from the subreport, or something more detailed?


    Author Comment

    Hi James,

    2 groups on the same OrderQty...the groups are the same between the sub and this moment the sub is located in the Grp Header #2.... I need to see GrpHeader /Footer values from both groups on the sub to appear on the GrpHeader / Footer of the corresponding Main Report....The subreport values are obviously subtotals...
    LVL 100

    Assisted Solution

    You have a main report with

    Group Header 1
      Group Header 2   Has subreport
      Group Footer 2
    Group Footer 1

    What you want is

    Group Header 1     subreport
      Group Header 2  
      Group Footer 2     subreport
    Group Footer 1

    How will the subreports differ?

    You can have the subreport inserted twice.
    If you link them the same way
    GH1 - subreport will give summary for entire group 1
    GF2 - subreport will give summary for group 2

    LVL 34

    Accepted Solution

    In theory, you could use formulas in the subreport to save the values in question in variables, and then have formulas in the main report output those variables.  But even if that will work in your situation (and I'm not sure if it would), if there's too much information involved, it can quickly become quite cumbersome.  Saving a few totals would be one thing.  Trying to save a whole set of fields would be another.

     mlmcc's suggestion of a second subreport might be an option, if you could create one subreport for GH1 that produced that values that you want there, and a second subreport for GF2 that produced the values that you want there.  Of course 2 subreports will be less efficient, but if they don't take too long and give you the results that you need, that might be the simplest solution.

    LVL 100

    Expert Comment

    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    Suggested Solutions

    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now