Multiple Parameters in Report but I only want to select 1

• SJB42

  SSChasing Mays

  Points: 613

  More actions

  November 10, 2010 at 9:51 am

  #228954

  Hi,

  Is it possible to have a report that has two parameters but when you run the report you don't actually need to select a value from both drop downs i.e. only a selection from one of the parameters is necessary for the report to run.

  I've checked 'Allow Null value' and 'Allow Blank Value' for both parameters but when I run the report it's asking me to select a value for both parameters. Maybe I'm misunderstanding what the 'Allow Null value' and 'Allow Blank Value' checkboxes are for?

  Many thanks,

  Stephen

• GSquared

  SSC Guru

  Points: 260824

  More actions

  November 10, 2010 at 9:53 am

  #1249016

  Allow Null/Blank simply allows those. If you don't want to use one of them, I believe you need to set a default value for it.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

• vasanti mestri

  Right there with Babe

  Points: 786

  More actions

  November 12, 2010 at 4:51 am

  #1249916

  use query like this in where clause of your dataset

  ( column_name=@para1 or @para1 is null )

  and also set allow null value and blank value in report parameter..