View Filter in SSRS

Ok So I have a report I made using List boxes in 3 groups ...
 1
Now I have a if Statment on my format so show the lines in red If margin is off. (WORKS wELL)

=IIF(Fields!Margin.Value > 0.5,"red",IIF(Fields!Margin.Value < .00,"red",Fields!Margin.Value))

 2
Now What I want is to place a filter to only view The red ones.. Not sure where to do this..  
gotti777Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
gotti777Connect With a Mentor Author Commented:
Any thoughts yet?
0
 
gotti777Author Commented:
Man I don’t like when people just send me to other web sites.  I assume I know how to use Google.   This questions is a less straight forward. I was hoping you would ask some question before sending me off.  Now I have to repost to get someone  else attention  
0
Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

 
gotti777Author Commented:
I more or less need to know if i need an if statement .. If so I need help writing it. And or if where exacaly do I need to add the filter on what i need to show up ..
0
 
p_nutsCommented:
Its easy. You can put a filter on the dataset by changing the query to filter on the margin ...

Or filter the table. Go to the table properties select filter and set it to the margin field.
0
 
gotti777Author Commented:
Cant use dataset the margin calculated in the layout

Its not a table its a group of 3 list boxes .. and i tried to filter in all 3 already and i get and error  3 4
0
 
p_nutsCommented:
Ok.. You might want to cast the values ...

Its saying the database is a decimal and it can't be compared  to a string...
0
 
gotti777Author Commented:
Sounds great !  How do I do that!
0
 
p_nutsCommented:
Try setting a parameter and compare it with that... Make the parameter type decimal.
0
 
gotti777Author Commented:
Set it where >> Margin is a calculated dataset..    4
0
 
p_nutsCommented:
Margin.value > dec(0.5)
0
 
p_nutsCommented:
Margin.value > dec(0.5)
0
 
p_nutsCommented:
Also what regional settings are set ? Could be , instead of .

0
 
Alpesh PatelAssistant ConsultantCommented:
As you have done the Text Red, Also set the one flag based on the Text REd. and use the Flag to show or hide the row using Row Visibility expression.
0
 
gotti777Author Commented:
P Nuts   I tried this but it didnt work

 1
0
 
gotti777Author Commented:
PatelAlpesh:  I think i know what you mean but how do i flag and where to I put the Row Visibility expression.. in list properties 2
0
 
gotti777Author Commented:
reposted for more help
0
All Courses

From novice to tech pro — start learning today.