pass null value

• Berth

  Say Hey Kid

  Points: 691

  More actions

  January 31, 2009 at 2:20 pm

  #196681

  Hello,

  I have a report with two inparameters. One of them is getting available values from another dataset, a lookup table.

  What if I want to pass NULL as that parameter? If I pass NULL to my SP, it returns all rows.

  Im using Reporting Services 2000

  Regards

• Bob Griffin

  SSCertifiable

  Points: 5982

  More actions

  February 2, 2009 at 10:42 am

  #936571

  Just build some logic into your stored procedure to handle the null value.