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

Prompt

Started by naren.crn, 03 Aug 2007 05:42:14 AM

Previous topic - Next topic

naren.crn

Hi i have a report in that i am using filter
ex: amount payed='yes'
Now i want create a value prompt on the customer no   now i want to see customer nos who Pay the amount in the value prompt drop down list

MFGF

Hi,

Add a prompt page to your report, then from the toolbox bring in a value prompt and work through the prompt wizard to generate your customer parameter, filter, prompt and prompt query.

Once this is complete, go to the Query Explorer and select the query used for your prompt.

From the toolbox, add a detail filter to this query [amount paid] = 'Yes'

When you run your report, the query bringing back the customers for your value prompt now only shows those customers who have paid...

Hope that helps.

MF.
Meep!

raj_tumati



hi,

   prompt is a dynamic filter which forces the end user is selecting or entering the values to restrict the data from the dwh