Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Help with VS2008 reports not Crystal

Posted on 2009-05-14
6
195 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
How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

 

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

Suggested Solutions

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…
This article describes relatively difficult and non-obvious issues that are likely to arise when creating COM class in Visual Studio and deploying it by professional MSI-authoring tools. It is assumed that the reader is already familiar with the cla…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

856 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