SSRS SCENARIO

• maheshkrishnas

  Ten Centuries

  Points: 1045

  More actions

  November 14, 2011 at 8:53 pm

  #251895

  Hi,

  If i pass the current year in prompt then my report should be display the Current year sale summary and previous year sale summary..

  Example:

  If i pass the year 2011 in prompt it has to display the 2011 sale summary & 2010 sale summary...

  can any one help on this...

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  November 15, 2011 at 1:46 am

  #1407668

  Sounds pretty simple to me.

  Just add in the Where clause of your dataset the following:

  SELECT *

  FROM someTable

  WHERE year = @parametervalue OR year =(@parametervalue -1)

  [font="Verdana"]Markus Bohse[/font]

• maheshkrishnas

  Ten Centuries

  Points: 1045

  More actions

  November 15, 2011 at 9:23 pm

  #1408246

  hi,

  Thanks for the reply....