I want to reference a parameter (twice!) in a formula filter condition
In this release of Report Builder there is no direct support for referencing parameters in the Formula dialog. They will show up if you edit a prompted filter condition as a formula, but there is no way to directly insert a parameter reference.
However, with a little trickery and relying on some behavior that is arguably a bug J, you can get one (or even two!) parameter references into the formula:
1. Add a field to your filter
2. Click the field name and choose Prompt
2.5. Do this if you want two references: Click the operator (usually “equals”) and choose From…To
3. Click the field name and choose Edit as Formula
This will give you a formula with one or two references to the parameter. You can edit the rest of the formula to get what you want -- just don't delete the ones you have, because you won't be able to reinsert them. Hopefully two is enough, because I can’t think of any way to get three.
