Supressing a field with formula

[ABetha]

I am trying to suppress a few fields if the subtotal values if there is only one entry therefore a subtotal would not be needed for that group.
This is what I have

{@ClaimedVisitSub} = val({@ClaimedVisit})

these formula contents are just summaries

 

[LinPro]

You need to elaborate. What do you mean by only one entry? One entry for each of the fields? Or one entry for all the fields?

What version of Crystal are you using?

L

 

[ABetha]

I am using crystal 2008. I want to suppress a group footer based on a formula
if the totals in my country footeer are equal to the custNo footer then I want to suppress the country footer

 

[LinPro]

So use the if statement in the conditional suppress of the group. Right click on the left, on the group and put that if statement in the Suppress selection - use the X->2 to enter the if statement.

L

 

[ABetha]

I tried that and nothing is suppressed this is the formula that I am using could you tell me if this is wrong.

if Sum ({@ClaimedVisitSub}, {vSerialNo.Country}) =Sum ({@visit}, {vSerialNo.CustNo}) then
true

 

[LinPro]

Did you test each of the formulas separately? Make sure you are getting the results you want. Then add them to the conditional statement.

By the way, is the serialNo the same for both?

L

 

[LinPro]

You don't have to use the whole if statement.

Just put this into the conditional statement. Again, is the vSerialNo.Country = vSerialNo.CustNo?

Sum ({@ClaimedVisitSub}, {vSerialNo.Country}) =Sum ({@visit}, {vSerialNo.CustNo})

Show some of the data from each side.

L

 

[ABetha]

CustNo Group footer
97 1 0 2 3

Country Group Footer
97 1 0 2 3

These numbers are summarized fields. If this country has only one custNo then there is no need to show the subtotal group(country group footer)

 

[LinPro]

Ok I see what you are getting at now.

You don't have to use the comparison formula to suppress. Just do a count on the custno, by country. If you get less then 2 then suppress the group by.

L

 

[ABetha]

Thank you LinPro that worked