locked
Hrs Value for Work Column RRS feed

  • Question

  • Hi All,

    I have WORK field in my report like below. I am getting the data in hour format as in 1st column in the below . But I need the WORK column as 'hr' as in 2nd column for the values .Kindly help me on this how can i achieve this.

    Work

    Work

    2:00

    2:00hr

    5:00

    5:00hr

    10:00

    10:00hr

    Thanks in Advance.


    Soumya T | EPM Consultant


    • Edited by Soumya.T Wednesday, August 24, 2016 9:28 AM
    Wednesday, August 24, 2016 7:07 AM

Answers

  • Hi Soumya T,

    According to your description, you want to add a suffix as “hr” for the hour format data. Right?

    In current Reporting Service, there’s no built-in hour format date that will contain a suffix as “hr”. So to work around your requirement, I would suggest you concatenate the “hr” by using the expression like =Fields!Work.value & “hr”.

    If you still have any questions, please feel free to ask.
    Thanks,
    Xi Jin.

    • Proposed as answer by Xi Jin Friday, September 2, 2016 7:30 AM
    • Marked as answer by Xi Jin Sunday, September 4, 2016 1:13 AM
    Thursday, August 25, 2016 6:59 AM