Null Parameter

How do you pass a set a parameter null from an expression (i.e. drill
through report)? I've tried null, nothing, System.DBNull; none of these
work.
Thanks.I have the same question. Did you ever find a solution Elmer?
"Elmer Miller" wrote:
> How do you pass a set a parameter null from an expression (i.e. drill
> through report)? I've tried null, nothing, System.DBNull; none of these
> work.
> Thanks.
>
>|||No I haven't solved this one yet. I'm using a lame hack to work around. Set
the parameter to a special value that is then hard-coded to be treated like
null in the stored procedure. I'm glad I'm not the only one with the
problem. I'm sure there is a simple fix.
"Randy Howie" <RandyHowie@.discussions.microsoft.com> wrote in message
news:A94BBCDC-3021-4421-89A2-D791967765EE@.microsoft.com...
>I have the same question. Did you ever find a solution Elmer?
> "Elmer Miller" wrote:
>> How do you pass a set a parameter null from an expression (i.e. drill
>> through report)? I've tried null, nothing, System.DBNull; none of these
>> work.
>> Thanks.
>>|||Since I posted my question, I discovered that System.DBNull.Value does work
as a null (but System.DBNull alone does not).
This did not solve my problem, since null parameter value was not selected
in my target report, but I am convinced that is the correct method for
passing a null in an expression.
Randy Howie
"Elmer Miller" wrote:
> No I haven't solved this one yet. I'm using a lame hack to work around. Set
> the parameter to a special value that is then hard-coded to be treated like
> null in the stored procedure. I'm glad I'm not the only one with the
> problem. I'm sure there is a simple fix.
> "Randy Howie" <RandyHowie@.discussions.microsoft.com> wrote in message
> news:A94BBCDC-3021-4421-89A2-D791967765EE@.microsoft.com...
> >I have the same question. Did you ever find a solution Elmer?
> >
> > "Elmer Miller" wrote:
> >
> >> How do you pass a set a parameter null from an expression (i.e. drill
> >> through report)? I've tried null, nothing, System.DBNull; none of these
> >> work.
> >> Thanks.
> >>
> >>
> >>
>
>|||In the URL:
¶mname:isnull=true
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Elmer Miller" <millere@.empireco.nospam> wrote in message
news:%230KVJyB%23EHA.2112@.TK2MSFTNGP10.phx.gbl...
> No I haven't solved this one yet. I'm using a lame hack to work around.
> Set the parameter to a special value that is then hard-coded to be treated
> like null in the stored procedure. I'm glad I'm not the only one with the
> problem. I'm sure there is a simple fix.
> "Randy Howie" <RandyHowie@.discussions.microsoft.com> wrote in message
> news:A94BBCDC-3021-4421-89A2-D791967765EE@.microsoft.com...
>>I have the same question. Did you ever find a solution Elmer?
>> "Elmer Miller" wrote:
>> How do you pass a set a parameter null from an expression (i.e. drill
>> through report)? I've tried null, nothing, System.DBNull; none of these
>> work.
>> Thanks.
>>
>|||Jeff,
I have seen that tip for passing a null via a URL, but I was referring to
passing the parameter via a "jump to report" navigation expression
(drillthrough).
Randy Howie
--
"Jeff A. Stucker" wrote:
> In the URL:
> ¶mname:isnull=true
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Elmer Miller" <millere@.empireco.nospam> wrote in message
> news:%230KVJyB%23EHA.2112@.TK2MSFTNGP10.phx.gbl...
> > No I haven't solved this one yet. I'm using a lame hack to work around.
> > Set the parameter to a special value that is then hard-coded to be treated
> > like null in the stored procedure. I'm glad I'm not the only one with the
> > problem. I'm sure there is a simple fix.
> >
> > "Randy Howie" <RandyHowie@.discussions.microsoft.com> wrote in message
> > news:A94BBCDC-3021-4421-89A2-D791967765EE@.microsoft.com...
> >>I have the same question. Did you ever find a solution Elmer?
> >>
> >> "Elmer Miller" wrote:
> >>
> >> How do you pass a set a parameter null from an expression (i.e. drill
> >> through report)? I've tried null, nothing, System.DBNull; none of these
> >> work.
> >> Thanks.
> >>
> >>
> >>
> >
> >
>
>|||I have also tried the System.DBNull.Value, but it doesn't work because
DBNull is of a different type. My parameter is a Date type and the
DBNull.Value causes an error:
The value you provided for the report parameter 'service_date' is not valid
for its type.
It should be this easy, but in this case type-checking is hurting us. I've
run into this situation before with Strong-typed datasets and in that case
you need to set a separate propterties and methods to handle nulls
(IsFieldNull() and SetFieldNull()). I'm sure there is something similar
going on here.
"Randy Howie" <RandyHowie@.discussions.microsoft.com> wrote in message
news:EFCD8BB2-5DA9-43FC-970B-33B7E20CA426@.microsoft.com...
> Since I posted my question, I discovered that System.DBNull.Value does
> work
> as a null (but System.DBNull alone does not).
> This did not solve my problem, since null parameter value was not selected
> in my target report, but I am convinced that is the correct method for
> passing a null in an expression.
> Randy Howie
> "Elmer Miller" wrote:
>> No I haven't solved this one yet. I'm using a lame hack to work around.
>> Set
>> the parameter to a special value that is then hard-coded to be treated
>> like
>> null in the stored procedure. I'm glad I'm not the only one with the
>> problem. I'm sure there is a simple fix.
>> "Randy Howie" <RandyHowie@.discussions.microsoft.com> wrote in message
>> news:A94BBCDC-3021-4421-89A2-D791967765EE@.microsoft.com...
>> >I have the same question. Did you ever find a solution Elmer?
>> >
>> > "Elmer Miller" wrote:
>> >
>> >> How do you pass a set a parameter null from an expression (i.e. drill
>> >> through report)? I've tried null, nothing, System.DBNull; none of
>> >> these
>> >> work.
>> >> Thanks.
>> >>
>> >>
>> >>
>>|||I found another workaround.
Instead of using 'Jump to report:' and setting parameters. Use 'Jump to URL'
and build the correct URL string with the param:null=true in it. It will
open up in a browser window (even when previewing)
"Randy Howie" <RandyHowie@.discussions.microsoft.com> wrote in message
news:A94BBCDC-3021-4421-89A2-D791967765EE@.microsoft.com...
>I have the same question. Did you ever find a solution Elmer?
> "Elmer Miller" wrote:
>> How do you pass a set a parameter null from an expression (i.e. drill
>> through report)? I've tried null, nothing, System.DBNull; none of these
>> work.
>> Thanks.
>>