Chart Top N

Comments

• gordk St.Catherines On. Canada.

  September 2008 edited 4:05PM

  use a query to supply data
  your sql statement is the key
  ado sample from the main demo addin objects chart1 report.
  
  select TOP 10 * from country order by population desc
• csakis1973 GREECE

  September 2008 edited 4:05PM

  I want in my report to show all the values (sales quantity of items)
  
  for example
  
  item name qty

  ---

  ----
  item 1 400
  item 2 380
  item 3 350
  item 4 300
  item 5 290
  item 6 250
  item 7 230
  item 8 210
  item 9 190
  item 10 180
  
  and i have in my report 100 more records with less values than above.
  I i show them the summarized column in my chart has a value 1800
  is not correctly displayed
  
  
• gordk St.Catherines On. Canada.

  September 2008 edited 4:05PM

  your not making any sense according to your first post.
  i gave you the method for the chart to only display the top 10 values.
  use a different dataset for the report, and don't connect the chart series to that dataset.
  again look at the report i mentioned in the main demo and see how it is connected to the data.