November 10, 2010 at 9:51 am
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
November 10, 2010 at 9:53 am
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
November 12, 2010 at 4:51 am
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..
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply