Help with VS2008 reports not Crystal

I am trying to use the filter in VS reporting.  The syntax I am using is:
!Reports.Over90Balance.value > 0

I get an error that it can't compare different data types.  It thinks that 0 is a boolean so I changed it to dec(0) and that didn't work either.  I know this can't be this hard!!

Thanks in advance,
Jerry
JDL129Asked:
Who is Participating?
 
cdaly33Commented:
Did you try setting 0 as 0.00 yet?
0
 
cdaly33Commented:
What datatype is the Over90Balance parameter set as?
0
 
JDL129Author Commented:
cdaly33!!!

Thanks for the response!!  
The datatype is the Access database is Currency.

Thanks again,
Jerry
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
JDL129Author Commented:
cdaly33!!!

Yes, I tried it about every way I could think of.  I put it in the expresions builder but I don't think I quite understand how that works. =!Reports.Over90Balance.value >0.00 seems to return a boolean.  I put a $ in front and that didn't work either.  All I want is all of the records where the Over90Balance is greater than 0.

Thanks again for the response,
Jerry
0
 
cdaly33Commented:
out of curiosity what happens if you try:
=!Reports.Over90Balance.value > True
0
 
JDL129Author Commented:
cdaly33!!
Sorry I've been so long responding!!!!!!!!!!!  None of the suggestion you gave helped..I finally tried "dec(0)" and that worked.  I'm giving you the points and a good score anyway because you were the only one willing to try to help!!

Thanks again!
Jerry
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.