How to create static parameter?
I've created a string static parameter in one of my report for users to enter vendor account number as their selection. However, the Vendor Account# field in the Vendor Master database that I'm connected to has some leading blank spaces in front of the Acct#. So when I keyed in a valid vendor account# in my parameter prompt, CR2008 returns no record since '12345' is not the same as ' 12345'.
Does anyone know how to make this work? I don't want to tell my users to hit the SPACE BAR 4 times before entering a Vendor Account#. Is there any go-around for this? Please any help will be appreciated. Thank you.