An easy way to do this is to create a formula field and concatenate the parameter with whatever you have in the text box. Move this field to your report in place of the parameter and the text box. That way, you won't have to worry about the length of the parameter field. You will always have 1 space between the end of the parameter value and the word "Listing"
As an example:
If the parameter was "Clients", then the formula:
parameter & " Listing Report"
would give you "Clients Listing Report".
If the parameter was "Management" then the formula:
parameter & " Listing Report"
would give you "Management Listing Report".
It doesn't matter how many characters are entered for your parameter. It will always be spaces properly. When you move this new field to your report, you will have to make the box large enough to accommodate a parameter someone entered with a large number of characters.
Hope this helps.
Edited by JohnT - 24 Sep 2008 at 8:36am
IP Logged
