SSRS: Not Letting Me Filter Out 0

(0) Share

Report

Posted on by Community Member Microsoft Employee

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:

Administration and Setup

Reporting and BI

Other

All responses (4)

Answers (0)

Suggested answer

SG-16071131-0 on at

Like (1)

Report

SSRS: Not Letting Me Filter Out 0

"=0" was helpful! but weird
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.
Community Member Microsoft Employee 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.
Suggested answer

Community Member Microsoft Employee on at

Like (1)

Report

RE: SSRS: Not Letting Me Filter Out 0

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