205
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
Hi Deepak,
try this in report expression:
=Format(TimeSerial(0,0,Fields!starttime.Value),"hh:mm:ss tt") - 12 hour clock
=Format(TimeSerial(0,0,Fields!starttime.Value),"HH:mm:ss tt") - 24 hour clock
Thanks for your reply but it's not working i already do all this things.
Can u tell me please how can i send my .xpo file because in my rich formatting attachment link option is disable.
we really want to help you, but you know sometimes its hard, if we don't have access to machine.
Kindly provide us 3 things
1) your XPO with all objects
2) your PDF file of report with current and desired output
3) Your exact application version of AX.
I too much appreciated your response thanks but i tried normally drag drop is also not give any result so tried to write job for seen the value of field when i write the job then i notice that the field give me the integer value so i need to do first change "time2str" In display method then may be i use this method as a field. I tried this thing but can u please suggest me how can i use "time2str" in method against "RsEntryTime" field for display.
Thanks Sir but i tried this thing before 3hours but nothing happen same result
Part 1:
First simply drag your field on design of SSRS. don't do anything with formatting. Let it display data,, which is coming from AX.
Part 2:
Now, when you are sure that data is coming on Report, and it just matter of formatting left, right click your textbox and click textbox properties. Finally click on Number and change formatting there.
Thanks for response actually Mr. sohaib that field which call in my table is in AOT> System Document> Types > timeofday . This EDT call in my table field and field name "rsEnteryTime" and it's EDT is "timeOfDay". How can i use this if i use as normal it's shows nothing.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (