We help IT Professionals succeed at work.

View Filter in SSRS

Medium Priority
363 Views
Last Modified: 2012-05-11
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..  
Comment
Watch Question

Author

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  

Author

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 ..
CERTIFIED EXPERT

Commented:
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.

Author

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
CERTIFIED EXPERT

Commented:
Ok.. You might want to cast the values ...

Its saying the database is a decimal and it can't be compared  to a string...

Author

Commented:
Sounds great !  How do I do that!
CERTIFIED EXPERT

Commented:
Try setting a parameter and compare it with that... Make the parameter type decimal.

Author

Commented:
Set it where >> Margin is a calculated dataset..    4
CERTIFIED EXPERT

Commented:
Margin.value > dec(0.5)
CERTIFIED EXPERT

Commented:
Margin.value > dec(0.5)
CERTIFIED EXPERT

Commented:
Also what regional settings are set ? Could be , instead of .

Alpesh PatelSolution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)
CERTIFIED EXPERT

Commented:
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.

Author

Commented:
P Nuts   I tried this but it didnt work

 1

Author

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
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
reposted for more help
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.