×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Summarizing Shared Var

Summarizing Shared Var

Summarizing Shared Var

(OP)
GH2 - Category
GH3 - Contract No
GH4 - Billing Item
GH5 - Project Phase

I have a subreport in the GH5a section pulling in estimated cost at the phase level. I created a shared var and placed it in the report footer. I then placed the shared var in the GH5b section of the main report. I can see the amount. But I can't do anything with it. I need to sum the phases estimate at the Billing Item level(GH4), the Contract No(GH3), and the Category(GH2). I think I need to create another variable that creates a total of the passed shared variable. But I do not know what I am doing.

In the image the purple are my passed shared variables. I left the subreport with a border so you can see where it is. I place yellow highlights where I need the purple to total.

RE: Summarizing Shared Var

So are you saying that you want the value from the sub-report to be passed back up to the beginning of the report? I am not sure if that is possible.

RE: Summarizing Shared Var

(OP)
Yes. My report opens with all Categories summarized, then the user drills down to all the jobs...then the user drills to this area - giving him the items and phase codes within each one.
So the user group(executives) want the estimated totals(which feeds from the sub-report(boxed area) summarized in the group header areas as well.
I now pass the shared variable - but since I need to place them below - I am wondering how I can get the same format/layout/functionality.....

Thanks in advance.

I also seem to be having trouble with my passing of shared var on the division(group2) and Company(group1) level. But I am sure I am placing it wrong, or resetting something wrong, etc... So I am working on that.

But the formatting with using the shared is stumping me.
I almost wonder if I need to have a company level sub-report listing all and then pass the information below. But I would need to suppress the section and I didn't think you could do that either with a whileprintingrecords.

RE: Summarizing Shared Var

Well there is a trick with not suppressing sub-reports while really suppressing them. First off always remember that values from a sub-report are available in sections after the section the sub-report is in. Second to 'suppress' a sub-report. You create a sub-report where all the sections are suppressed. Then in the Format sub-report, Subreport tab, Choose 'Suppress Blank Subreport'. Then in the section the sub-report is in, Suppress Blank Section. Of course any shared variables will be passed via formulas.

RE: Summarizing Shared Var

(OP)
I am still so confused.....
I can not figure out how to keep the format they want , and still pass all the variables.

RE: Summarizing Shared Var

I am not sure it is possible. I would have to do a lot of experimenting.

RE: Summarizing Shared Var

Try this on a renamed master report. Insert a GH2a section and place a copy of your current subreport saved under another name in GH2a. Remove all shared variable formulas from your original subreport in GH5 as that subreport will now just be for display. Link the GH2a subreport on the Grp1 and Grp2 fields. Pass the results from the sub to the GH2b section of the main report via shared variable. If you can insert groups in the GH2a subreport that mirror the ones in the main report, you could set up three kinds of shared variables, one for each group level in the main report. You of course would need reset formulas between groups, etc. If you can't set up the groups in the GH2a report, then you could insert another sub in each of newly inserted a sections of the other two groups. You will be able to make the reports disappear.

This is hard to explain without more detail about the report, etc., but this is worth a try I think.

-LB

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close