CRAXDRT 13 Mismatch ???

NickyJP · Nov 10, 2005

Currently have a system which calls from a vb component the Crystal Reports (using 8), data coming back from an SQL database, now having experience of the following error code which occurs intermittently, the error code is

CRAXDRT Error occured on Server. 13. Type Mismatch

anyone help as to why this error is occuring ???

madelca100 · Nov 10, 2005

I've gotten 'data type mismatch' errors (not your exact error) when I was trying to do a calculation on a field that had NULL value. Handling the Null in the calculation made the error go away.

//trap Nulls first
iif (isnull({claim_count_by_adjuster.DTTM_CLOSED}),0,
iif ({@cvtDateClosed2Date} in LastFullMonth,1, 0))

Very few records/rows have Null in this field. That was why, in my case, it was intermittent. (I only got the error when the selection criterion happened to pick a record with a Null value.)

Very frustrating, but happy that I finally resolved it.

mike

NickyJP · Nov 11, 2005

Another error message that appears is

"User Session has expired"

Don't understand this one as only just opened session?? Can anyone help ??

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

CRAXDRT 13 Mismatch ???

NickyJP

Programmer

madelca100

MIS

NickyJP

Programmer

Similar threads

Part and Inventory Search

Sponsor