Share
Reporthi 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
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?
#1
André Arnaud de Cal...
293,001
Super User 2025 Season 1
#2
Martin Dráb
231,833
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
All responses (
Answers (
