Database Connector Error: value exceeding max length

[DJWheezyWeez]

I'm using CR XI.

I looked at thread766-1569891 but it didn't seem to help me any. I checked if the database was up to date but other than that, I don't know why this is happening. The report works fine until I drag on {sfc.comment}. Since I don't know what part of my report could be causing this, I'm going to try to describe everything.

The report is grouped by {sfec.JobCode}. The detail section has fields {sfec.shiftcode} and {sfec.press}. It also has 5 formulas:

DateTimeValue (32874+({sfec.starttime}/86400))

[code@EndDateTime]DateTimeValue (32874+({sfec.endtime}/86400))[/code]

if {sfec.statcode}="100"     //statcode 100 is the statcode for Make Ready
then ({sfec.elapsetime}/60)/60
else 0

if {sfec.statcode}="361"     //statcode 361 is the statcode for Wash Up
then ({sfec.elapsetime}/60)/60
else 0

if not ({sfec.statcode} in ["100", "200", "361"])
then ({sfec.elapsetime}/60)/60
else 0

@MakeReadyHours, @WashUpHours, and @AllOtherHours are all summed by {sfec.JobCode}. My selection formula is:

{sfec.press} = {?Press} and
{@StartDateTime} >= {?StartDateTime} and
{@EndDateTime} <= {?EndDateTime}

I don't know what could be causing that error. I've never had it before. Any help is appreciated and I can give more information if needed. Thanks.

-DJWW

 

[fisheromacse]

what type of field is {sfc.comment}?
I believe crystal has a limit of just over 65000 characters for string data.

 

[DJWheezyWeez]

It's a string. When I show field type, it says string[400]. I'm assuming that means it will hold 400 characters for the string. Would the error mean that there is over 400 characters in at least one of the comments?