Dates parameters

I create a report that brings information from an informix database. I have a
problem with date parameters when I put them static on query design (with
date format mm/dd/yyyy) it retreives information on a good response time. But
if I preview report with the option to add date paramaters reports doesn't
display information it always says "Processing report". I think that the
problem is that SQL adds the time to parameter because if I add time to date
value on design mode it sends an error.
Please let me know if you have comments
I will appreciate it
thanksThe date parameter is definitely date/time. If the data type in your
informix database just holds date then you need to use one of the date
functions and strip off the time. Go to your dataset and click on the ...
and go to the parameters tab. You will see the query parameter that maps to
the report parameter, change the report parameter to an expression and have
the expression convert it to just the date. You can use any of the functions
in Microsoft.VisualBasic, System.Convert, and System.Math without have to
write any custom code. Read up on expressions.
Bruce L-C
"Yoya" <Yoya@.discussions.microsoft.com> wrote in message
news:0CDE2FB6-C49F-47AB-B11D-40B54FB32965@.microsoft.com...
> I create a report that brings information from an informix database. I
have a
> problem with date parameters when I put them static on query design (with
> date format mm/dd/yyyy) it retreives information on a good response time.
But
> if I preview report with the option to add date paramaters reports doesn't
> display information it always says "Processing report". I think that the
> problem is that SQL adds the time to parameter because if I add time to
date
> value on design mode it sends an error.
> Please let me know if you have comments
> I will appreciate it
> thanks
>