December 20, 2011 at 3:43 pm
Hi , I want to show the "report parameter" in 24 hr clock time
for instance if user chooses Parameters!prompt.Value = 1 then the @reportstart would be
-------Switch statement goes like that-------------------------------------------------------------
Parameters!Prompt.Value=1, CDate(DateValue(dateadd("d",-1, Globals!ExecutionTime)) + " 18:00:00")
--------------------------------------------------------------------------------------------------
but when I run the report it always shows as 12/19/2011 6:00:00 PM ( since todays date is "12/20/2011") but I want it to show up like 12/19/2011 18:00:00
I tried changing the "regional settings" of report and changed the language of report but it already had English (united states), which is correct. So I dont know if its browser specific or any other way of doing it.
I also tried below code in SSRS but did not work some expected type error-----------------------
Parameters!Prompt.Value=1, Format((DateValue(dateadd("d",-1, Globals!ExecutionTime)) + " 18:00:00"),"d") & " " &
Format((DateValue(dateadd("d",-1, Globals!ExecutionTime)) + " 18:00:00"),"HH:mm")
Thanks for your help.
December 20, 2011 at 4:37 pm
Have a look at this thread and see if it helps
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 21, 2011 at 8:31 am
Thanks for the link. however I am not into .Net much. Is there anything I can do on my own. something at report level formatting/sp level ?
December 21, 2011 at 8:36 am
As the link indicates - you cannot without trying to do a .Net workaround.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply