View Filter in SSRS
Ok So I have a report I made using List boxes in 3 groups ...
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!Margi
Now What I want is to place a filter to only view The red ones.. Not sure where to do this..
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!Margi
Now What I want is to place a filter to only view The red ones.. Not sure where to do this..
radcaesar
http://msdn.microsoft.com/en-us/library/ms156270.aspx
ASKER
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
ASKER
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 ..
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.
Or filter the table. Go to the table properties select filter and set it to the margin field.
ASKER
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
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
Ok.. You might want to cast the values ...
Its saying the database is a decimal and it can't be compared to a string...
Its saying the database is a decimal and it can't be compared to a string...
ASKER
Sounds great ! How do I do that!
Try setting a parameter and compare it with that... Make the parameter type decimal.
ASKER
Set it where >> Margin is a calculated dataset.. 
Margin.value > dec(0.5)
Margin.value > dec(0.5)
Also what regional settings are set ? Could be , instead of .
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.
ASKER
P Nuts I tried this but it didnt work
ASKER
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 
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
reposted for more help