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

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,

 

Answer 1

Can you use a format code of 000  instead of N0 or ###

Answer 2

Hi Mahendra,

That works.

But I got it working using below exp.

=Right(

 

 

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