Prefix parameter field
I have been provided with a report that requires the parameter field to be populated with the word u2018Weeku2019 and followed by the week number i.e. Week 02
I have an automated system for exporting reports via email, and I can set the parameters to enter dates or part of dates, however I am at a loss of how to have the word u2018Week u2018 (with a space at the end, thus before the week number).
Is there anyway in which I can prefix a parameter field.....so for the parameter of u201840u2019 the Select Expert would actually be checking u2018Week 40u2019 against the database?
Dom Horton replied
maybe pass the parameter field to a formula?
concatenate 'Week' and parameter, e.g.
"Week " + ?parameterfield
and then use the forumula field for your record selection.
Depending on whether your parameter field is a string or otherwise, use + or & as the concatenate operator.