CODEWITHSUNDEEP
sql-server-2008reporting-services
Fraz Sundal
Fraz Sundal

Reputation: 10448

How to generate multiple chart in sql server report

I have a scenario in which user select multiple products and select multiple locations now if user select 2 products and 2 locations i want to generate 2 X 2 = 4. 4 charts and show each product particular location daily prices in chart? Daily prices of products per locations are saved in database. I want to know can i generate charts like this and how?

enter image description here

for example If this is the data, I want to generate Apple location F chart then Apple location M chart then Mango Location M chart and last Mango location F chart. I am using sql server 2008 R2 with C#

Upvotes: 0

Views: 1295

Answers (1)

jimconstable
jimconstable

Reputation: 2388

Use a tablix with locations as the row group and product as the column group. Then put a chart in the data cell. The tablix will slice up your data and the chart can then have date as the category axis and price as the data.

Upvotes: 1

Related Questions