How to use where condition in SSRS Expression

Vilas 101 Reputation points
2022-04-25T12:12:53.53+00:00

Hi
Need help in SSRS Expression. Please refer attached image. The table is overall compliant status for all servers (auto and manual collection). I want compliant status for manual servers only. Please help SSRS statement where Collection_name = "Manual Server"

196128-2022-04-25-17-40-01-patch-compliance-2022-all-wind.png

Community Center | Not monitored
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Vilas 101 Reputation points
    2022-04-25T12:13:56.593+00:00

    Current expression statement is

    =Count(Fields!Compliant_Status.Value) / Count(Fields!Compliant_Status.Value, "Tablix9")

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.