Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 329
  • Last Modified:

2 Subreport Group totals not appearing correctly in Main Report

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
0
Mikeyman_01
Asked:
Mikeyman_01
  • 2
  • 2
2 Solutions
 
James0628Commented:
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?

 James
0
 
Mikeyman_01Author Commented:
Hi James,

2 groups on the same OrderQty...the groups are the same between the sub and main...at 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...
0
 
mlmccCommented:
You have a main report with

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

What you want is

Group Header 1     subreport
  Group Header 2  
     Details
  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

mlmcc
0
 
James0628Commented:
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.

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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now