What cause the "Data type mismatch in criterial expression error" in Crystal Reports?

Question

0.00/5 (No votes)

See more:

I'm working on an old VB6 project and I'm modifiying a crystal report. Every time I try to view the report it gives me an error "Data type mismatch in Criteria expression". I even tried removing all the parameters and Formula fileds I created but it still gives the same erorr. How do I fix that??

Posted 7-Jul-11 15:08pm

obhasha07

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

fjdiewornncalwe · Answer 1 · 2011-07-07T15:21:00

Read some of these posts, they may give you an idea of what is going wrong. Without you providing some relevant code snippets, it's the best I can do for you right now.

http://www.andreavb.com/forum/viewtopic_1379.html[^]
http://www.dreamincode.net/forums/topic/48673-error-message-data-type-mismatch-in-criteria-expression/[^]
http://www.vbforums.com/showthread.php?t=461948[^]
http://www.xtremevbtalk.com/showthread.php?t=139130[^]

If found all of these with 1 google search: data type mismatch in criteria expression VB6

walterhevedeich · Answer 2 · 2011-07-07T15:31:00

Solution 2

One possible reason is that you might be passing a numerical field as a character field. Take a look at this for instance. If intValue is a numerical field, this will definitely throw an exception.

SELECT * FROM tblTable WHERE intValue = '1'

My advise would be for you to take a look at your queries first.

Posted 7-Jul-11 15:31pm

walterhevedeich

Comments

obhasha07 8-Jul-11 1:39am

you're right. There is something wrong in the query. But sadly, I can't check or change the query because crystal reports gives me an error saying "A number is required here" when I try to view the query. Any ideas?

walterhevedeich 8-Jul-11 2:00am

Why aren't you able to change the queries? Isn't the queries done on the VB6 code?

obhasha07 8-Jul-11 2:04am

no, I don't pass a data set or run a query from vb. The query in in the crystal report. It's automatically created as we add database fields to the report