Group Problem

[chrisppppp]

Crystal XI

i have a formula field in the details section like below;

if {tblPolicySplit.IntermediaryID} = "UWNET" and {tblPolicySplit.AccountID} <> Maximum ({@Account ID}, {tblPolicySplit.PolicyID}) then {tblPolicySplit.AccountID}

It should only bring through one result in the details section and everything else will be null. How can i get this summarised onto my Group PolicyID? Basically so it will sit on the group line so that i can then suppress the details section?

(By the way the result of the above formula will be a string)

 

[CrystalizeCanada]

You could amend the formula to put the value into a variable. This variable would be available in the group footer (not the header) however you could move your group heading info into the footer instead.

So:
StringVar X;
if {tblPolicySplit.IntermediaryID} = "UWNET" and {tblPolicySplit.AccountID} <> Maximum ({@Account ID}, {tblPolicySplit.PolicyID}) then X:={tblPolicySplit.AccountID}

Then create a formula placed into the group footer that displays the value of X;
WhileprintingRecords;
StringVar X

Gordon BOCP
Crystalize

 

[chrisppppp]

Wonderful, cheers mate