最新消息:ww12345678 的部落格重装上线,希望大家继续支持。

Time field on SSRS shows time format Report Dynamics Ax 2012

网络文摘 alirazazaidi 1088浏览 0评论

Today is another small tip,

I was developing a custom report. Queried table stored the date and time in separate fields ie. Transdate and transtime. On  mapping the transtime to report, its showed time format. Instead of time value.

2016-10-28_19-18-27

For it solution, I added the string field on report temp table and then convert the time with time2str function and map to the field.

Complete statement is below.

TableTmp.StransTime  = time2Str(_Trans.transTime, TimeSeparator::Colon, TimeFormat::AMPM);

 

As result, report will display the trans time instead of its format.

2016-10-29_1-56-07

发表我的评论
取消评论

表情

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址