Friday, February 24, 2012

Calendar control for date selection ?

Hello,
I have a very simple report...
SELECT AmountDue from Table where DueDate Between @.Dt1 and @.Dt2...
So in above case i will see two parameter in my report. Is there any way so
that i can select dates from calendar control in Reporting Service ?
ThxHi,
Not yet. In SQL RS 2000, the date parameters default to using a text box for
input.
In SQL RS 2005, you will be able to use date pickers for date parameters.
In the meantime, it is possible to write your own ASP-type front ends to
allow users to pick parameters. These parameters can then be passed to your
report using query string parameters. (See RS books online for details...)
"mvp" wrote:
> Hello,
> I have a very simple report...
> SELECT AmountDue from Table where DueDate Between @.Dt1 and @.Dt2...
>
> So in above case i will see two parameter in my report. Is there any way so
> that i can select dates from calendar control in Reporting Service ?
> Thx

No comments:

Post a Comment