sql server reporting services: Hi

How do I count Null and non null values in reporting services....????

Thanks

Carlos Antonio

This will count all rows where the value of the X-field is not null:
=Count(Fields!X.Value)

You may also want to check the CountDistinct(...) aggregate function.

-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]

You can also do counts via the SUM function with a nested IIF like
this:

// This counts NOT NULL values
=SUM(IIF(Fields!MyField.Value = Nothing, 1, 0))

// This counts NULL values
=SUM(IIF(Fields!MyField.Value = Nothing, 0, 1))

Lance
http://www.lance-hunt.net

Sorry, my comments are backwards....

// This counts NULL values
=SUM(IIF(Fields!MyField.Value = Nothing, 1, 0))

// This counts NOT NULL values
=SUM(IIF(Fields!MyField.Value = Nothing, 0, 1))