INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Error: This Field Cannot be Summarized - Crystal 11

Error: This Field Cannot be Summarized - Crystal 11

(OP)
I'm getting the error message "This field cannot be summarized" for a field called {@VOIDEDPROC} in a formula called "Maximum" . The following are my formulas:

VoidedProc
if isnull ({PatientVisitProcs.Voided}) then 1
else
IF {PatientVisitProcs.Voided} = 1 then
(if cdate ({PatientVisitProcs.DateOfEntry}) > {%MinEDIDate} then
if cdate({PatientVisitProcs.DateOfEntry}) <= ({@2nd Filing}) then 0)
Else 1


Maximum
if maximum ({@VOIDEDPROC},{PatientVisit.PatientVisitId})= 0
then "Dirty"
else "Clean"


I used this same type of formula for evaluating some other data in my report with no issues. The formula that I used that works is below:

RCode
if trim({@ReasonCode1}) = "" then 0
else
if trim({@ReasonCode1})in [list of stringvariables]
then 0
else 1

RCodeStatus
if maximum ({@CleanDirty4},{PatientVisit.PatientVisitId})=0
then "Dirty"
else "Clean"

Thank you in advance

RE: Error: This Field Cannot be Summarized - Crystal 11

Almost certainly will be because of {@2nd Filing}. You should post the code for any formula referred to.

Does that formula reference a Running Total, or use Previous or Next functions. If the answer to any of these questions is YES, that will be the cause.

RE: Error: This Field Cannot be Summarized - Crystal 11

(OP)
Sorry about that. Yes {@2nd Filing} uses Previous function. Is there a workaround? Below is the formula for {@2nd Filing}

stringvar ReasonCode;
if RecordNumber=1 then
ReasonCode:= {TransactionDistributions.AdjustmentReasonCode1}
else
(if {PatientVisit.PatientVisitId}=previous ({PatientVisit.PatientVisitId}) and cdate({Transactions.Created})<={%earliesteob} then
ReasonCode := ReasonCode+","+{TransactionDistributions.AdjustmentReasonCode1}
else
if {PatientVisit.PatientVisitId}=previous ({PatientVisit.PatientVisitId}) and cdate({Transactions.Created})>{%earliesteob} then
ReasonCode:= ReasonCode
else
ReasonCode:={TransactionDistributions.AdjustmentReasonCode1});
ReasonCode

The forumula for {%earliesteob} is below:
(
select min ("VisitTransactions"."Created")
from VisitTransactions
where "PatientVisit"."PatientVisitId"="VisitTransactions"."PatientVisitid" and "VisitTransactions"."InsuranceCarriersId" > 0
)

Thank you

RE: Error: This Field Cannot be Summarized - Crystal 11

You would need to use a Variable to look at each detail line, and if any row meets the specified conditions. the entire group (VisitID) is flagged as 'Dirty'.

Something along the following lines should work, based on my understanding of your logic:

Details Section formula (Suppressed):

CODE --> {@VarTEST}

WhilePrintingRecords;
Global StringVar CD;
IF 	{PatientVisitProcs.Voided} = 1 AND
	CDATE({PatientVisitProcs.DateOfEntry}) > {%MinEDIDate} AND
	CDATE({PatientVisitProcs.DateOfEntry}) <= {@2nd Filing} 
THEN	CD := 'Dirty'
ELSE	CD := CD 
Report Header formula (Suppressed):

CODE --> {@VarRESET}

WhilePrintingRecords;
Global StringVar CD := 'Clean' 
Report Footer formula:

CODE --> {@VarDISPLAY

WhilePrintingRecords;
Global StringVar CD 

The solution is untested, but should work based on my limited understanding (or at least get you close to what you need) as long as I haven't messed up the syntax somewhere.

This looks to be the 3rd in a series of questions raised in relation to just one report. I'm not sure there is much more I can do here.

Hope I have been able to assist.

Pete

RE: Error: This Field Cannot be Summarized - Crystal 11

(OP)
Thanks Pete, it is the third question. I'm way over my head on this one, normally I would have had a report this complicated written by a SQL programmer, but we are currently without one. Your solution above works as long as I move all my results down to the footer vs the header.

I appreciate the help.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close