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!
  • Students Click Here

*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.

Students Click Here


Error: This Field Cannot be Summarized - Crystal 11

Error: This Field Cannot be Summarized - Crystal 11

Error: This Field Cannot be Summarized - Crystal 11

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:

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

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:

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

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

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}
(if {PatientVisit.PatientVisitId}=previous ({PatientVisit.PatientVisitId}) and cdate({Transactions.Created})<={%earliesteob} then
ReasonCode := ReasonCode+","+{TransactionDistributions.AdjustmentReasonCode1}
if {PatientVisit.PatientVisitId}=previous ({PatientVisit.PatientVisitId}) and cdate({Transactions.Created})>{%earliesteob} then
ReasonCode:= 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}

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

CODE --> {@VarRESET}

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


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.


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

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!

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