CODEWITHSUNDEEP
reporting-servicesssrs-2008-r2
Eric Klaus
Eric Klaus

Reputation: 955

Where clause in ssrs

Suppose I've a dataset, it has deparment column (sales, marketing...) and many many other columns. I want to create a pie chart which includes info only on sales department. How can i do this? I don't want to change query because I'll do the same thing for marketing departmnet and etc. thanks in advance

Upvotes: 0

Views: 59

Answers (1)

Matt
Matt

Reputation: 835

Create a filter on the data set, by going to dataset properties > filters Add your Department column to the filer and set the text equal to the department you want. Repeat for each department.

Upvotes: 1

Related Questions