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.

Jobs

Passing Value from SubReport to Main Reports HEADER (eg above Subreport). Can this be done???

Passing Value from SubReport to Main Reports HEADER (eg above Subreport). Can this be done???

Passing Value from SubReport to Main Reports HEADER (eg above Subreport). Can this be done???

(OP)
Hi,

So I am trying to work out if there is a way to pass a subreport value to the main report HEADER while the subreport is in the main report FOOTER.

I know in theory you cant pass a value to a spot in the main report above the subreport, but I was hoping there was wealth of knowledge on here that had a way around it......

The subreport has a Count on a field (Total # of Records), which currently displays in the subreport header. I want to put all the subreport headers in the main report to fix an exporting data issue, but then this formula doesnt calculate.

Oh and I'm on Crystal 2016.

Thanks smile

RE: Passing Value from SubReport to Main Reports HEADER (eg above Subreport). Can this be done???

There is no way to do this.
You can add the subreport in twice, with the first one hidden in a thin report header section with all fields in SR suppressed.
You can not suppress the section holding hidden SR but you can make it as thin as possible and then check underlay following section so that it does not impact layout.
Downside is that its an additional overhead on Database

Ian

RE: Passing Value from SubReport to Main Reports HEADER (eg above Subreport). Can this be done???

(OP)
Darn! Thats what I thought. Ah well, will have to manage as it is because I dont think adding a second copy of the SR will work due to the excessive load.

Thanks for your response.

RE: Passing Value from SubReport to Main Reports HEADER (eg above Subreport). Can this be done???

Sometimes a duplicate subreport doesn't increase the load. Usually, when Crystal encounters an identical subreport (no change to the criteria or parameters) it doesn't hit the database a second time. I have used this to my advantage a few times:
http://kenhamady.com/cru/archives/2779

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks
http://www.kenhamady.com/

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!

Resources

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