×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• 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.

# Combining totals from reports/subreports... possible?

## Combining totals from reports/subreports... possible?

(OP)
Hi Folks,

I've got a report which houses a total that I would like to be able to add to the total that is on the subreport.  I'm using version 6.  Is this possible?  How can I accomplish this?

Thank you

### RE: Combining totals from reports/subreports... possible?

If I remember correctly version 6.0 has two functions called storevar and fetchvar. You will need to use the storevar function in the subreport i.e. StoreNumberVar total := {Field.Name}; and then in the primary report you will need to init the varialable name in the RH  i.e. Numbervar total = ({field.name},0). Finally you will need to create a formula to display the value into the desired section i.e. FetchNumberVar Total + {theother.fieldname}. I have not included the exact syntax but this should get you started. NOTE: In version 8.5 all you would have to do is use a function called Shared Numbervar and this will do the same thing. If you plan to upgrade to the recent version of Crystal you will need to do some clean up on the report. This is because Crystal by default does Crystal Decsions is not supporting the StoreVar and Fetchvar functions. I hope this helps

Keith Boyer
Instructor/Consultant
kboyer@dmgrpt.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.

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:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!