We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Crystal Reports - Sharing/passing cross tab results accross subreprpots

czarubah
czarubah asked
on
Medium Priority
675 Views
Last Modified: 2012-06-21
I have a crystal report that has a couple of subreports. both subreports use a cross tab to create a set.

In one report, i calculate guest counts by server on the other I calculate items sold group by specific rules. now I need to calculate the ratio of Grouped Items divided by the guest count.

the data is in two different tables (flat dbf files). so the question is can I pass the array (result of the cross tab) from one subreport to the other (or to the main report) so I can do calculations?
Comment
Watch Question

Author

Commented:
I cannot really link the tables as that duplicates the data.
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
No.  A cross tab is just a display method.  The data is not available for sharing.

You could create an array in the first subreport and share it with the second one.  You would have to do the calculations too build the array yourself.

mlmcc

Author

Commented:
i am not sure I know how to pass an array, my array would have to be a two dimensional.
Senior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.