Solved

Help with VS2008 reports not Crystal

Posted on 2009-05-14
6
193 Views
Last Modified: 2013-11-26
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
0
Comment
Question by:JDL129
  • 3
  • 3
6 Comments
 
LVL 9

Expert Comment

by:cdaly33
ID: 24385143
What datatype is the Over90Balance parameter set as?
0
 

Author Comment

by:JDL129
ID: 24386981
cdaly33!!!

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

Thanks again,
Jerry
0
 
LVL 9

Accepted Solution

by:
cdaly33 earned 125 total points
ID: 24387288
Did you try setting 0 as 0.00 yet?
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

Author Comment

by:JDL129
ID: 24389547
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
 
LVL 9

Expert Comment

by:cdaly33
ID: 24390923
out of curiosity what happens if you try:
=!Reports.Over90Balance.value > True
0
 

Author Closing Comment

by:JDL129
ID: 31581452
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

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The object model of .Net can be overwhelming at times – so overwhelming that quite trivial tasks often take hours of research. In this case, the task at hand was to populate the datagrid from SQL Server database in Visual Studio 2008 Windows applica…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
A short film showing how OnPage and Connectwise integration works.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now