Hi I am having a report with report parameter.In report parameter user will enter the number(number should be <=9) and then related data will display on screen as well as the number which user entered.When user enters the number which less than 9
digit on report I need to display that number with leading zero on report.for example if user enter 12345 the related data will be displayed on report as well as I need to add 000012345 and display that number on report.I am using a textbox to display
the user selected number (parameter!number.value).So can any one say how to add leading zero in SSRS.In sql we can use SELECT REPLICATE(’0′, 10 – DATALENGTH(col1)) + col1 AS NAME
but can any one say how can we display in SSRS.
Thanks in advance
View Complete Post