SSRS – How to Use ‘Not Equal To’ Operator

ssrsssrs-2008-r2

How do I show a message if none of the rows returned have a specific value?

If all of the results in a report have a status of "OK", I want to return a message indicating that there were no warnings.

How can I do that?
Steve

Best Answer

So, the answer was simple, I was using "!=", I needed to use "<>".

Problem solved. Sc

Related Solutions

Sql-server – Exporting SSRS report to Excel

There is some Technet information on the intended behaviour of the export: https://technet.microsoft.com/en-us/library/dd255234(v=sql.105).aspx

Images, charts, sparklines, data bars, maps, gauges, indicators, and lines are positioned within one Excel cell but they sit on top of the cell grid. Lines are rendered as cell borders.

Conditional formatting in SSRS 2008r2

Here's how you hide How to: Hide an Item (Reporting Services)

Here's the expression

=IIF( Fields!yourField1.Value = 0  and Fields!yourField2.Value = 0 
  and Fields!yourField3.Value = 0  , True, False )

Best Answer

Related Solutions

Sql-server – Exporting SSRS report to Excel

Conditional formatting in SSRS 2008r2

Related Question