Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Help with VS2008 reports not Crystal

Posted on 2009-05-14
6
Medium Priority
?
201 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 500 total points
ID: 24387288
Did you try setting 0 as 0.00 yet?
0
[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

 

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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…
Hello there! As a developer I have modified and refactored the unit tests which was written by fellow developers in the past. On the course, I have gone through various misconceptions and technical challenges when it comes to implementation. I would…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Suggested Courses

564 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