I have an issue with a report I am converting from Crystal Reports to SRS.
The reports datasource is a SQL stored procedure, that converts a datetime column to a varchar column containing just the time portion of the data. The time is converted to 24 hr format. CR was able to with it's built in syntax to convert this to a 12 hr format with AM & PM.
I have not found a way to do this within SRS and have been struggling to determine if there is something I can change in the stored procedure to convert the time to 12 hr format, instead of the 24 hr format. I have tried the CAST and CONVERT, with no luck.
I know that they must be a way to handle this situtation, relativly easy, but I have a limited amount of Transact-SQL expertise, and turn to some expert advise.
Here is the original statement from the SP:
@IND datatype is datetime
Your help is appreciated greatly.
December 11, 2006 5:11 PM
December 12, 2006 11:26 AM