If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

creating a text box prompt using filters

Started by Tsunami, 23 Nov 2010 03:27:26 PM

Previous topic - Next topic

Tsunami

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?

MFGF

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.
Meep!

ksr

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

Tsunami

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.

MFGF

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.
Meep!