hi all ..
when i run my report that has a field of type time the result is h:mm:ss tt
i tryied all formats in report but no result
Which expression do you use as the value of the text box? Didn't you actually set the format text as the value, instead of using a field value there and configuring a number format?
i am reading from a retail table to tmp table that fetch the records to my report
PostedStatementSummaryTmpTable.postedTime = retailStatementjour.postedTime;
Your code shows how you set the field value in AX, but your problem seems to be about SSRS. Open the design of your SSRS report, find the text box for "Posted time" and look at what expression it uses to get the value.
it uses this
=Fields!postedTime.Value
and the type of the item in the data set is int32
Where and how did you set the date/time format?
By the way, this is a different field than before. In your previous reply, you said that the field was postedDate, not postedTime.
oh i meant postedtime sorry
possted time field and the data type is time
when i display it in a ssrs report it shown me this h:mm:ss tt
when i see the type of this field in my report it is int32
i made a simple search in google and found this line of code and it work
=Format(DateAdd("s", Fields!MySecondsField.Value, "00:00:00"), "HH:mm:ss")
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,028
André Arnaud de Cal... 878 Super User 2025 Season 2
Sohaib Cheema 579 User Group Leader
