DrewAllen wrote:



Very many thanks, although I'm still stuck.

I've created the above formula as a field object called "Copy Count" which I can get to sum, but it sums all values in all records., So, thinking that I know roughly what I'm doing (bad assumption) I've created another field object that is intended to perform a sum function on this field, if the value in the address attribute description field is for this particular mailing.

Hence, the formula that I've come up with using the Sum (Fld, CondFld, Cond) argument is:

Sum ({@Copy Count},{CnAdrPrfAtrCat_1.CnAdrPrfAtrCat_1_Description} , "On Campus")

however this is returning an error that the summary / running total field could not be created.

Am I barking up the wrong tree here, or ??

As a side note, I do have record select on, where the records & fields on the labels are based off the {CnAdrPrfAtrCat_1.CnAdrPrfAtrCat_1_Description} = "On Campus"

cheers & thanks

Rob

RobertWild wrote:


The Sum(Fld, CondFld, Cond) function isn't appropriate here. In order to use either Sum(Fld, CondFld) or Sum(Fld, CondFld, Cond), you have to have a group on CondFld. In addition, the Sum(Fld, CondFld, Cond) version is only applicable to Date, DateTime, or Boolean Fields and is used to specify the particular level of change (such as monthly or weekly) in the CondFld.

What you probably want to do instead is use IF...THEN...ELSE in your conversion formula. So you probably want something like

IF {CnAdrPrfAtrCat_1.CnAdrPrfAtrCat_1_Description} = "On Campus"
THEN CDbl(<your attribute comment field here>)
ELSE 0

Then you would want to use the standard summary features of Crystal to get the total.

Much of this is contained in the Crystal Help files. If you're not sure what a formula does, check the help files. You should also think about getting training.

Drew

Many thanks for the info Drew, and I am looking at gettign training, however there seems to be nobody in my state (South Australia) that does Crystal Reports training... it seems that the nearest thing is BB from the Sydney office, and that isn't a distance I'm prepared to travel simply for training.

There are plenty of con$ultants that wll do the job for me, however I want the skill set for myself for the flexibility, rather than outsourcing everything.

cheers

Rob