Share via

I want to reference a parameter (twice!) in a formula filter condition

  • Article

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

  • Anonymous
    January 03, 2007
    Do you know if there's new functionality in this area that will be in a future service pack?
  • Anonymous
    January 15, 2007
    We are definitely considering this for a future release. Not likely in a service pack, though.
  • Anonymous
    July 29, 2010
    Is this fixed in reportbuilder 3.0??
  • Anonymous
    September 28, 2010
    Can we use a formula as a parameter, i'm meaning something like injection.