Thanks for your reply.

But i want the SSRS report, not a SQL query.

Please help me to do above scenario in SSRS.