Condition Based Parameter - SSRS

• ramsql.blogpost

  SSC Veteran

  Points: 230

  More actions

  September 10, 2020 at 12:57 pm

  #3787537

  Hi,

  I have a situation that I am unable to find any solution by browsing. I have an internal parameter @Category which has to be passed null value to StoredProc if we select @subCategory option "All". If we select any other value in @SubCategory drop down, I need to pass the selected value to Dataset which if again StoredProc and the result value to @Category.

  When I am selecting All option, it is by default going to dataset and it has no result to return causing the error "The Parameter @Category" missing a value".

  Is there any way to resolve the issue. Requirement is simple, If @SubCategory is "All" the we can assign null to @Category, otherwise get the value from dataset by passing @SubCategory.

  Please help.

  • This topic was modified 4 years, 2 months ago by  ramsql.blogpost.

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  September 11, 2020 at 1:10 pm

  #3787880

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.