locked
"Employee ID" field to be displayed as 3 digit format ? RRS feed

  • Question

  • Hi All,

    Am running ssrs 2008 r2 report.

    I have one database field Employee ID which has data like 1, 2, 3, 4,.....10,11,...100(max)

    I need to display the above data in 3 digit format for ex., 001, 002, ....,010, 011,....099, 100

    Any idea?

    Thanks,

     

    Monday, January 10, 2011 9:13 PM

Answers

  • Can you use a format code of 000  instead of N0 or ###
    • Proposed as answer by M Mahendra Tuesday, January 11, 2011 1:40 AM
    • Marked as answer by UltraDev Tuesday, January 11, 2011 3:14 PM
    Monday, January 10, 2011 10:57 PM
  • Hi Mahendra,

    That works.

    But I got it working using below exp.

    =Right(

     

     

    "00" & Fields!EmployeeID.Value,3)

    • Marked as answer by UltraDev Tuesday, January 11, 2011 3:12 PM
    Tuesday, January 11, 2011 3:12 PM

All replies

  • Can you use a format code of 000  instead of N0 or ###
    • Proposed as answer by M Mahendra Tuesday, January 11, 2011 1:40 AM
    • Marked as answer by UltraDev Tuesday, January 11, 2011 3:14 PM
    Monday, January 10, 2011 10:57 PM
  • Hi Mahendra,

    That works.

    But I got it working using below exp.

    =Right(

     

     

    "00" & Fields!EmployeeID.Value,3)

    • Marked as answer by UltraDev Tuesday, January 11, 2011 3:12 PM
    Tuesday, January 11, 2011 3:12 PM