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.

Comments (4)

  1. PhilNicholas says:

    Do you know if there’s new functionality in this area that will be in a future service pack?

  2. Bob Meyers20 says:

    We are definitely considering this for a future release. Not likely in a service pack, though.

  3. Markus says:

    Is this fixed in reportbuilder 3.0??

  4. Yoann says:

    Can we use a formula as a parameter, i'm meaning something like injection.