SSRS: Not Letting Me Filter Out 0

(0) Share

Report

Posted on by Community Member

Hello:

I'm modifying a copy of the SSRS report for HITB,

And, I'm trying to implement a simple filter saying that cost should not be equal to 0. Now, SSRS is giving me an error saying that it "cannot compare data of types system.decimal and system.double".

Thoughts?

John

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Community Member on at

Like (1)

Report

RE: SSRS: Not Letting Me Filter Out 0

I solved this by making 0 be "=0". Weird.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

RE: SSRS: Not Letting Me Filter Out 0

I am glad to hear that you have solved your problem by yourself. But many students can't solve their problems by themselves. I mean most of them can't write their essay on their own. But now they don't have to worry because you can take help from EduBirdie. You can also read edubirdie review on https://youressayreviews.com/review-of-edubirdie-com-services website which will help you in trusting them.

Was this reply helpful? Yes No
ashleyridley007 5 on at

Like (1)

Report

RE: SSRS: Not Letting Me Filter Out 0

I was also facing the same problem. But it solved by taking the value of 0 as a string that means I took its value "0". You can also try this and reply if it works for you. If not then I have another way to solve this issue. I got this solution from a technology site which is specific to snapchat app, so try and let me know.

Was this reply helpful? Yes No
Suggested answer

SG-16071131-0 6 on at

Like (1)

Report

SSRS: Not Letting Me Filter Out 0

"=0" was helpful! but weird

Was this reply helpful? Yes No