April 29, 2016 at 6:50 am
I have a report, the user can either enter consumer id, batch id or batch date.
How do I make sure the user entering at least one parameter?
Thanks
April 29, 2016 at 7:34 am
mister magoo has a good solution in this thread which I have used before.
http://www.sqlservercentral.com/Forums/Topic1724454-150-1.aspx
April 29, 2016 at 9:50 am
I don't quite understand about the following steps.
Create a third report parameter which does not allow blank or null values.
Set its available values to be sourced from a dataset and choose the one you just created.
Set its default value to be sourced from the same dataset.
April 29, 2016 at 12:56 pm
BTW mine does not work because one of the parameter is datetime value.
May 3, 2016 at 9:25 am
Loner (4/29/2016)
I don't quite understand about the following steps.Create a third report parameter which does not allow blank or null values.
Set its available values to be sourced from a dataset and choose the one you just created.
Set its default value to be sourced from the same dataset.
Effectively you're making an additional parameter that requires at least of the other parameters to be selected, even though it has no actual baring on the report.
It doesn't matter what data types your parameters are, this will work regardless (you could have one string, two datetimes, one decimal and a Boolean).
What part is it in the above you're stumbling over and someone will able to guide you through.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply