all groups > sql server reporting services > december 2005 >
You're in the

sql server reporting services

group:

Passing Date as String


Passing Date as String asnewbie+rs=argh
12/16/2005 10:21:03 AM
sql server reporting services:
I have a report that returns date in the format 'YYYY-MM-DD'. This report
has no parameters, but I am drilling to another report that accepts date as a
parameter. So, I select the textbox I want to drill from and select "Jump to
Report". I select the report to be drilled to and define the parameters that
are to be passed.

Parameter Parameter Value
date =Fields!date.Value

Next, I go to the report that is to be drilled to and add date as a
parameter. Parameter name "date", parameter data type "string". Now, when
the drill report passes the date to the drilled report, the date parameter is
filled in as:

MM/DD/YYYY 00:00:00

Why is RS converting my strings and what is the best way to either make it
stop or work around this problem.

Thanks for any help!

RE: Passing Date as String (SOLVED) asnewbie+rs=argh
12/16/2005 5:47:45 PM
Sprinkle liberally with:

=Format(Convert.ToDateTime(Fields!date.Value), "yyyy-MM-dd")

Cheers,

[quoted text, click to view]
AddThis Social Bookmark Button