Monday, March 19, 2012

DateTime parameter format

Hi everybody

A quick question - is it possible to present DateTime report parameters with specified format. Let's say instead of '9/3/2005 12:00 AM' i'd like to show '9/3/2005' only. Plus maybe it's possible to plug in some sort of a popup calendar.

Thanks for response,
Konstantin

At least in RS 2000 if you define the parameter as string (instead of datetime) then it'll be shown in the format that you want.
And I don't know if the datepicker can be used in RS (maybe someone else could help us)|||One way of pluging in a popup calendar would be to create a front-end application to the report. You would use either the URL Builder functionality (fast) or the Web Service (slow) to run the report. The parameters could be created from any control (calendar, datagrid, etc...) There are some sample apps out there that do this (and some that run as Sharepoint web parts.)
An option to format dates is to use a Date Key (integer) and Date Name (formatted date) drop down list of dates. The report would have the date key passed in - the stored procedure would translate to the date selected.
Hope this helps,
Andrew.|||

I see
i guess second option would solve formatting issue.

Thanks,
Konstantin

No comments:

Post a Comment