Hello,

Thank you for your reply.

The OccurrenceDate is the same field. It is my typo.

Let me try working on this and will work with your suggestions.

Thank you for your response, C.Lockhart. I will use your query to test the result.

I made a mistake on posting question. The group like should be ManagerID not...

Thank you very much. That's work great.

Thank you for your reply.

The problem about this is, the query came from the results of the shared dataset.

I tried to search on the Internet regarding...

Thank you very much.

Thank you very much for suggesting the tally table. This prompted me to think of using the 'with cte' statement.

I did not use the tally. But decide to use the...

Thank you very much for your reply and I do apologize for the delays in my response.

The query itself combined three subqueries.

We would like to compare the number of...

Thank you for your reply.

However, I have over 500,000 records in this table and I don't think it will work using the "union all".

Thanks.

Even though I could not write this statement in the SSRS expression, however, I was able to use it in the SQL level and just pull the fields that I...

Thank you very much for posting.

Everything has been implemented.

----------------

However, the team would like to add two (2) date parameters, namely @StartDate and @EndDate. They declare these dates in the...

Thank you very much. This should work as well.