Skip to Content
Former Member
Jul 31, 2013 at 10:27 PM

How to clean data for a param


I have some data that is being used in the report also as a param. from the server it is not such clean data

for example the name of the user

'Joe Smith 0000000000'

all those zeros. How best to remove the zeros? THis is used in the report as a group but there I can just limit the length but not in the param it shows the zeros.