Solved

Help with VS2008 reports not Crystal

Posted on 2009-05-14
6
197 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
[X]
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
  • 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
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 

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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

Recently while returning home from work my wife (another .NET developer) was murmuring something. On further poking she said that she has been assigned a task where she has to serialize and deserialize objects and she is afraid of serialization. Wha…
In my previous two articles we discussed Binary Serialization (http://www.experts-exchange.com/A_4362.html) and XML Serialization (http://www.experts-exchange.com/A_4425.html). In this article we will try to know more about SOAP (Simple Object Acces…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

738 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