EDIT: Some steps in this post are not required. See Post 14 for an update
Try using another option field on the BAQ Report Designer for your input param, but with NotEquals. This will ignore this value when selecting the records. And you can reference the value the user entered in the BAQ Report.
Here’s some picts in case that wasn’t clear…
BAQ includes a column of type text with a width at least as wide as your input text:
The BAQ Report includes an Option field using that column, but set to not equals:
The BAQ Report screen then shows an input that the user can enter anything into (anything except something that would be an exact match for the field you’re piggy backing on to):
In the SSRS Builder: Reference Option2 (in the BAQReportParams dataset)
The report then shows that text that was entered.
EDIT: Some important notes:
- You don’t need the BAQ parameters.
- You can still do “calculations” on the input value like you would have in the BAQ
- Again, make sure the user entered value will never match the field you’re piggy backing on to. Especially if that field may be blank.
- The field you’re piggy backing onto can still be used in the report
