Date prompts
-
I have two concerns with date prompts.
a) date format. How can I make a date prompt box acept input in a non american date format, eg dd/mm//yyy ? I can set the report's language property to English(Australian) but this only changes the date format displayed in the body of the report itself.
b) drop lists. My users are used to report date prompts from our app that display a month-style calendar control. I would at least like to supply a drop list of dates say from 1990 to 2010 or something. To that end, I tried linking the parameter to a values dataset of dates from 1990 to 2010 returned by a stored procedure, but this resulted in an unhandled exception at run time.
-
Best option is to build your own web page that uses the Report viewer control. Then you can format your parameter entry any way you wish.
Take a look at the Reporting Services Books Online for the various parameters that you can specify in the url to disable the default parameter toolbar and such.
--------------------
Colt 45 - the original point and click interface
-
A simpler suggestion may be to replace the date parameter with a string parameter, pass that to the sql which would converting it with a CONVERT function.
In fact a datetime parameter is pretty redundant if you can't apply a data entry mask to it like ##/##/####. I have users that if you told them to enter today's date into a date field, they would literally type "TODAY'S DATE" !
-
Entering the date into a freeform textbox is going to be fraught with danger. Your perceived simplicity goes out the window when you try and ensure correct date entry. When a user enters 11/12/2004, is it the 12th of November, or the 11th of December?
That's why I suggested building your own web page as the best option. Then you can include things like calendar popups, input validation, etc...
--------------------
Colt 45 - the original point and click interface
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply