asked on

Hiding all contents of a group (and details inside) based on group calculated field

Hi. I am wondering if it is possible to take a crystal report (XI) with a group (grouped by person's name) and based on a calculated field on the group footer, hide that group AND THE DETAILS WITHIN IT.

From the pictures that i am adding, you will see that if someone's productivity >50% then it highlights the productivity yellow in the detail section.
On the group footer section, if the weighted productivity is >50% then it highlights red.

Generally, i want to be able to hide any group, including the details within it, if the group footer's weighted productivity is >50% (it is red).

is that possible in crystal reports xi?

The best i have been able to do so far is just hide any group header/footer that is > 50% but the details still show within...
I can then hide the details of the >50% of the detail alone, (so it would still show the yellows, but nothing else about that person's jobs in that instance) but i cant find how to hide the details based on that % in the group footer...

any assistance would be great - and thank you in advance!
Not-over-50.jpg
over-50.jpg

SOLUTION

peter57r

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

CantalUser

ASKER

That's a great idea. However, I tried that but then realized that the weighted productivity (the group %) is actually a formula based off of 2 sum formulas from the details of the report.

i tried this as the group selection formula:
{@Weighted Percentage Per Person Per Day} > 50

here is the code of {@Weighted Percentage Per Person Per Day}:
if (Sum ({@Calculated Hours}, {@Name}) > 0) then
Sum ({@weighted percentage}, {@Name})/Sum ({@Calculated Hours}, {@Name})
else 0

and i get the following:
"This formula cannot be used because it must be evaluated later"
Thank you though - any other thoughts?

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

CantalUser

ASKER

Thank you - this worked well. I just had to make the formula a number [CDbl(Sum(....))], but it worked perfectly after that - thanks for teaching me something new!

CantalUser

ASKER

And thank you, peter57r for putting me on the right track!

CantalUser

ASKER

Yeah if you Wouldn't mind - sorry this is my first post and didn't realize i could split. Thanks, again!

Mike McCracken

Reopened. Just click one of the ACCEPT MULTIPLE SOLUTIONS links and then follow the instructions

mlmcc