Report with Differents between years

• ericverleg

  Old Hand

  Points: 300

  More actions

  September 9, 2008 at 4:03 am

  #197916

  Hi All,

  I new in the SQL Server business and I'm working on a report in SSRS. In this report I create a list with the following Layout:

  Planned Sold Conversion

  This Year 100 75 75%

  Last Year 100 80 80%

  Diff 0 5 5

  I have a data set on detail level because I need the detail information in the second part of the report.

  So I created a grouplevel on Year and summarised per Year but how can I make a line with the differance between This and last year.

  TIA

  Eric

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  September 10, 2008 at 8:23 am

  #869688

  One way to do it in SSRS is to use the ReportItems collection. You can reference the textbox that has each year value like this:

  ReportItems!txtThisYearPlanned.Value = ReportItems!txtLastYearPlanned.Value

  You may need to do an explicit conversion to int, but I'm not sure.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question