You’re offline. This is a read only version of the page.
35
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
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")
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
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.
it uses this
=Fields!postedTime.Value
and the type of the item in the data set is int32
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.
i am reading from a retail table to tmp table that fetch the records to my report
PostedStatementSummaryTmpTable.postedTime = retailStatementjour.postedTime;
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?
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (