Contact US

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

Subreport Field Into Main Report

Subreport Field Into Main Report

Subreport Field Into Main Report

Hi there!
I have googled this and am trying to follow the instructions but I can't get it to work.
My main report is a pricing file, my subreport is the cost file. I need to pull cost from the subreport into the main report so I can calculate the margin.
Can this be done?

RE: Subreport Field Into Main Report

You have to use shared variable(s) to do this. Set the shared variable in the subreport with the value you want. Then use the the shared variable in the main report. The one thing to remember is that the sub-report has to be in a section before where you want to see the values from the sub-report. There should be a lot of information on how to this on the internet.

RE: Subreport Field Into Main Report

There is a lot of help on line but it's not all completely helpful. I have been messing around and got the field from the subreport to show up and I'm sure this is something silly but my end formula is off by a line. I think it has to do w/ the detail b section but I'm not sure what to do. I'm wondering if you would be able to spot what I'm doing wrong w/ the 2 screenshots.

RE: Subreport Field Into Main Report

The sub should be in detail_a and all other fields in detail_b. If you want to show the value from the sub by displaying the sub in alignment with other fields, you would then format Detail_a to “underlay following sections”.

As an alternative, you could leave the sub in detail_a, all else in detail_b, and then pass the value from the sub in a shared variable that you then reference in the main report in a new formula. You would then suppress all sections within the sub (do not suppress the sub directly or the section it is in) and then remove the borders. Format the sub to “suppress blank subreport” (formata->subreport). Then in the section expert format detail_a to suppress blank section.


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