I'm trying to create a prompt that allows the user to enter a value as well as wildcards. However, when I create the filter [Project] = ?Project?, it creates a drop down list with all the projects.
Is there another syntax to get my desired results?
Hi,
Just drag a Text Box prompt onto a prompt page in your report, and set it to point at your ?Project? variable.
Regards,
MF.
1) create a Prompt page using page explorer
2) From tool box tab, drag text box prompt to the prompt page
a Prompt wizard will be started and in the first screen of it, it will ask you weather to create
new parameter or to select existing parameter
3) select existing parameter radio button and select project in the list
4) click finish
Ok, so you have to create a prompt page? I was just trying to use the filters to automatically populate prompts when you run the report.
Quote from: Tsunami on 06 Dec 2010 01:51:39 PM
Ok, so you have to create a prompt page? I was just trying to use the filters to automatically populate prompts when you run the report.
This will happen, but you will get whatever prompts are defined as the default in Framework Manager for the items you are filtering, and you have no direct control from within the report. The way to override this in the report is to define a prompt page and add whatever is the appropriate prompt type to this.
The alternative is to modify the FM model to generate a Text Box Prompt whenever the item in question is used in a parameter filter. You would then need to republish the package to implement this.
Regards,
MF.