How to get data from Stored Procedure in form of two tables?

I have two tables 1. Staff 2. Clients

Each Staff has some Clients. I want to write an Stored Procedure that returns me staff name and its clients name and Clien开发者_开发问答ts address. How can I achieve this?

I want to make a report from the returned result which will be like this:

This staff has three clients and their addresses are being shown respectively. This is just an example.

I can have more than one staff. This report is in simple HTML, I have to make it in SQL Server Reporting Services.

Create a query that joins the Staff and Client tables together, and in SSRS, group by the staff name. It's pretty simple to do.