Time field on SSRS Report Expression display

(0) Share

Report

Posted on by DEEPAKNONU

207

I'm creating Query Base Report in my "Time Attendance Table" have Time field when i put this field on sssrs report it will show like this "HH:mm:ss". I need to show time on my report please help me how can i show time on my report.

*This post is locked for comments

I have the same question (0)

All responses (23)

Answers (0)

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

what issue are you facing exactly? e.g. how to display it on SSRS? or formatting of "HH:mm:ss" or something else?

Was this reply helpful? Yes No
Suggested answer

Hajish 460 on at

Like (0)

Report

In cell properties, you can change the date format as you need.

Was this reply helpful? Yes No
DEEPAKNONU 207 on at

Like (0)

Report

Mr. Sohaib i have one table tablename "AttendanceTimeTable" it's a customized table in this table one field is for time for.eg. "Time In is 8:00 Am " and "Time out is 6:00 Pm".

I created a query base ssrs report when i take this field and use in my report it will show like this "HH:mm:ss" it not shows the time.

Was this reply helpful? Yes No
DEEPAKNONU 207 on at

Like (0)

Report

Mr. Hajish thanks for response but i need to show time not date.

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

Hi,

is not "HH:mm:ss" the time???

by the way if you are confuse about AM/PM with format, you can change that by using textbox properties.

i.stack.imgur.com/NTNNM.png

Was this reply helpful? Yes No
DEEPAKNONU 207 on at

Like (0)

Report

Mr. Sohaib thanks for your quick response but i already check by changing properties of text box but when i change the properties it shows "h:mm tt" its not any type of error but when i run my report it show this field shows this "h:mm tt".

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

what do you want ? do you want to show AM/PM with it or something else?

Was this reply helpful? Yes No
DEEPAKNONU 207 on at

Like (0)

Report

I just want to show for eg:- 8:30AM

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

I would recommend you to use custom format, as shown below, if you are unable to choose a workable format.

Was this reply helpful? Yes No
DEEPAKNONU 207 on at

Like (0)

Report

Thanks for response but is also not working again shows "hh:mm:ss tt"

Was this reply helpful? Yes No