sql server reporting services: NULL DateTime parameters via URL -- sql server reporting services

You're in the

sql server reporting services

group:

NULL DateTime parameters via URL

Ron Lytal
10/6/2004 2:28:54 PM

sql server reporting services: 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?

Re: NULL DateTime parameters via URL

Ron Lytal
10/7/2004 7:04:55 AM

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

[quoted text, click to view]

RE: NULL DateTime parameters via URL

Jon Tudhope
2/28/2008 5:20:30 AM

Use "value:isnull=true"

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

Posted via DevelopmentNow.com Groups

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn