NULL DateTime parameters via URL

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ron Lytal - 06 Oct 2004 22:28 GMT

My report has DateTime parameters and is being accessed via URL. These
parameters are set to "Allow NULL". When I access the report with the
parameter in the URL like this

&DateTimeParm=

I get the error "rsReportParameterTypeMismatch". When I omit the parameter
from the URL completely, I receive the error "rsReportParameterValueNotSet".
Books Online suggested this syntax

&DateTimeParm:isnull

but this gives me the error "rsInvalidItemPath". Is it possible to have a
datetime parameter passed as NULL using a URL?

Reply to this Message

Ron Lytal - 07 Oct 2004 15:04 GMT

This issue is resolved in the "URL access" article posted on 10/7/2004 by
"avnrao" with subject line "Few recommended and useful articles".

> My report has DateTime parameters and is being accessed via URL. These
> parameters are set to "Allow NULL". When I access the report with the
[quoted text clipped - 10 lines]
> but this gives me the error "rsInvalidItemPath". Is it possible to have a
> datetime parameter passed as NULL using a URL?

Reply to this Message

tyaramis - 14 Dec 2006 13:32 GMT

hi ron,

I have same problem while setting null values to datetime parameters in my
asp.net application.
Did you find a solution?

Thanks in advance.

>My report has DateTime parameters and is being accessed via URL. These
>parameters are set to "Allow NULL". When I access the report with the
[quoted text clipped - 10 lines]
>but this gives me the error "rsInvalidItemPath". Is it possible to have a
>datetime parameter passed as NULL using a URL?

Reply to this Message

Jon Tudhope - 28 Feb 2008 13:20 GMT

Use "value:isnull=true

From http://www.developmentnow.com/g/115_2004_10_0_0_451623/NULL-DateTime-parameters-
via-URL.ht

Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Reply to this Message