Reports by either one or the other input paramater

• Maria Thomas

  Newbie

  Points: 8

  More actions

  November 27, 2006 at 10:54 pm

  #153313

  This report i have ot generate has two parameters - param 1 or param 2.  only one parameter is required.  How can i generate a report using only one parameter - i.e. if the user enters one parameter, then the other parameter should not be displayed for input and the report generated should be based on the input parameter.  Any input into this would be greatly appreciated.

  Thanks in advance.

• Renu Mehta

  SSC-Addicted

  Points: 429

  More actions

  November 28, 2006 at 1:28 am

  #674251

  Dear Anitha,

  are the parameters param1 , param2 are used for the where conditions of select stmt. ???

  if yes then u can try this ...

  create proc sample1

  @param1 as numeric(9,0), @param2 as numeric(9,0)

  As

  begin

     select *

     from test1

     where field1 = isnull(@param1, field1)

     and     field2 = isnull(@param2, field2)

  end

   

  ---

  Kindest Regards,

  Renu