Formatting Parameters

• DoubleEx

  SSCommitted

  Points: 1523

  More actions

  June 8, 2009 at 12:54 pm

  #384734

  I have a report that includes a simple Start ID and End ID range that I prompt the user. The ID value in the database is string with zero padding. If it were a VB.NET interface I would simply pad the user entered value before I built the SQL string.

  I wrote a simple function in the report's code properties. I would like to replace the value of the user entered parameter with the "padded" value so the padded value is used in the SQL statement.

  Does anybody have any experience with this?

• dva2007

  SSCertifiable

  Points: 7707

  More actions

  June 18, 2009 at 9:57 am

  #1011886

  If you are using stored procedure then you can format your parameter (start id and end iD) as you like and then use into SQL code.