Date parameter getting converted

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
String datatype instead of DateTime, same results.It now appears that these same decimals are being passed in no matter what I
type in the date boxes...
"BrianW" wrote:
> 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
> String datatype instead of DateTime, same results.|||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!
"BrianW" wrote:
> It now appears that these same decimals are being passed in no matter what I
> type in the date boxes...
> "BrianW" wrote:
> > 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
> > String datatype instead of DateTime, same results.