sql server reporting services: Date parameter getting converted -- sql server reporting services

Date parameter getting converted

BrianW
12/10/2004 1:05:04 PM

sql server reporting services:

I have my report's data source set to a stored procedure that I created which
takes 2 date parameters. If I run the dataset while in the Data Tab it works
fine but when I go to the preview window no data shows up. I ran a SQL
Profiler trace to figure out what was going on. Apparently in the Data Tab
the dates are being passed in just as typed but in the preview window the
dates get converted to extremely tiny decimals...9.677419354838709e-002. How
can I get these dates carried through properly? I even tried to make them

RE: Date parameter getting converted

BrianW
12/10/2004 1:09:04 PM

It now appears that these same decimals are being passed in no matter what I
type in the date boxes...

[quoted text, click to view]

RE: Date parameter getting converted

BrianW
12/10/2004 1:45:03 PM

I figured it out. In the Parameters Tab of my dataset I thought I was
supposed to put default values in. Instead I put the expression of my Report
Parameters in and it worked. Wow, these message boards are great!

[quoted text, click to view]

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.