Padding number with leading zero?

[WhiteKnight2K]

Hello, quick question, is it possible to "pad" a number field with a leading zero in CR? The number I pull from the database does not have a leading zero for years < 10. I have a parameter field which allows the user to select records based on the Year field corresponding to that record. However the Year field is just a number and does not save a leading zero for years < 10 in the database. Therefore, I need to display the year entered by the user on the report, but for years < 10 the leading zero does not show, even if the user enters it in the parameter dialog box.

Thanks!

 

[lbass]

You could create a formula to display the parameter value:

totext({?numberparameter},"00")

-LB

 

[WhiteKnight2K]

You are a genius lbass...I never knew of that function. Thanks again as always!!