Chart Implementation

• b_boy

  SSCertifiable

  Points: 5145

  More actions

  August 6, 2008 at 10:56 am

  #382165

  Hello

  I am using the following Query:

  SELECT TOP (5)

  ShipCountry,

  SUM (OrderTotal)as [Total Order],

  SUM (OrderTotalExVat) as [Total Order Excl.VAT],

  AVG(OrderTotal) as [AVG Order value - Inc.VAT],

  AVG(OrderTotalExVat) as [AVG Order Value - Ex.VAT]

  FROM

  T_OrderHeader

  WHERE

  OrderDate BETWEEN GETDATE()-365 AND GETDATE()

  GROUP BY

  ShipCountry

  ORDER BY

  SUM (OrderTotal) DESC,

  ShipCountry ASC

  And I want to implement a chart but cant get my head around it, can anyone help?

• Todd Engen

  SSCrazy Eights

  Points: 9869

  More actions

  August 6, 2008 at 11:30 am

  #854026

  Going under the assumption you're using Reporting Services with SQL 2005.

  1) Create a Dataset based on your query

  2) Add a Chart control to the Layout

  3) From the Dataset, drag the ShipCountry field to the "Drop category fields here" on the Chart.

  4) From the Dataset, drag the remaining fields to the "Drop data fields here"

  5) Change the chart type to Simple Bar.