Showing a table results in a line graph(SSRS)

• Jnrstevej

  SSCrazy

  Points: 2343

  More actions

  July 25, 2011 at 6:11 am

  #244799

  Hi

  I was wondering if someone could help me with one section of my SSRS i am developing

  Background

  I have a report that contains four section,

  1. The first is the forecast values

  2. The second is the 'difference' (FcstMay10 - History)

  3. The third is the 'accuracy' which is (1+FcstMay10 - History)/History

  4. The last section(Accuracy Graph) is a table derived from the values from the accuracy section which includes a line graph to show the difference for each month.

  Problem

  My problem lies with showing the results of the table(Accuracy Graph) in the line graph as each individual month is calculated within the SSRS report and not the SP. So i cant just drag and drop the values from dataset into the data area of the line chart.

  My Attempts[/u]

  1. Google search, only found solutions where the calculation are done within the SP(I've tried that but not getting the same results as in the SSRS.

  What i want

  I would like to show in the line graph the results in the Accuracy Graph table in the line chart depict in the waterfall chart that i have attached can anyone help me please

  I've attached the Excel document for extra clarity

  Thanks in advance:-)

  __________________________________________________________________________________
  Steve J
  Jnr Developer
  BSc(Hon)

• gsc_dba

  SSCertifiable

  Points: 5407

  More actions

  July 26, 2011 at 5:25 am

  #1358376

  For what its worth (!) - my advice would be to persevere with trying to get the data you want to be shown in the graph from the SP.

  If you post your SQL for the SP here, maybe someone can decipher what you are trying and where you are going with it.

  🙂

  gsc_dba