Is there a way to pad left one of the values in a report parameter, say I have the number 10731 but the db is going to be looking for a 6 digit number 010731. Can I access the properties of the parameter in the report itself or the query.If not is there a way to pad left the parameter in the query? Padding left @customer_bill_to and @customer_delv_toWHERE (detail_record.pickup_date >= @start_date) AND (@customer_bill_to IS NULL) AND (@customer_delv_to IS NULL) AND (detail_record.pickup_date < DATEADD(day, 1, @end_date)) OR (detail_record.customer_bill_to = @customer_bill_to) OR (detail_record.pickup_date >= @start_date) AND (@customer_bill_to IS NULL) AND (detail_record.pickup_date < DATEADD(day, 1, @end_date)) AND (detail_record.customer_delv_to = @customer_delv_to) OR (detail_record.pickup_date >= @start_date) AND (detail_record.pickup_date < DATEADD(day, 1, @end_date)) AND (detail_record.customer_bill_to = @customer_bill_to) AND (detail_record.customer_delv_to = @customer_delv_to)
If so it would make my life mmuch simpler.Thanks for the helpCoachBarker
Padding left on a report Parameter?
Posted - 2009-04-03 : 14:50:37
