creating a Pie Chart in SSRS

Question

how can I create the pie chart that displays the Count of columns with filters like ( Active Paths / Courses / Sections /----- this is my column name )from 4 different tables and combined them in one query?

Answer 1

If you add more information on how your schema is structured then we can provide a more specific answer. It's likely you'll want to JOIN your data together into one dataset to consume in your SSRS. Though depending on how your Tables are structured, you may want to UNION it too.

If you're using Microsoft SQL Server, you can use a View, or even better a Stored Procedure (since you'll be filtering and parameters will be helpful here).

Then you need to setup a new SSRS and configure how the filters for your stored procedure's parameters are shown in the report.

Finally you can add a Pie Chart via this Microsoft Tutorial: Add a Pie Chart to Your Report (Report Builder).