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

Tricky Prompt

Started by cogman8, 28 Nov 2007 11:30:13 AM

Previous topic - Next topic

cogman8

The database table has a combination of summary and grand total records.  The grand total records are marked as '**'.  I know this is strange!  The fact table is joined to a few reference tables, ex. Fund Codes(Has a field '**' fund code grand total).  I need to create a prompt for Fund Code.  The three choices are:

1.  'No.  Select all Fund Codes'

2.  'Yes, Select some Fund Codes'

3.  'Yes.  Select Grand Totals'.

The first choice shouldn't do an auto submit, wait for the user to select the finish button and just return all fund codes.  The second choice should do an auto submit and give the user a list of fund codes to select from.  The third choice shouldn't do an auto submit, wait for the user to select the finish button and bring back only grand total records('**').

My attempt at the prompt has been to:

1.  Bring in the fields and create a value prompt which has 3 static choices(Selections above)

2.  Create 2 data items. 

     a.  Fund Code='**'

     b.  If/then/else statement assigning the static choice (1 and 2) to 

          the fund code field and static choice (3) to Fund Code='**'.

3.  Create a filter: Fund Code= ?FundCode?

Problems:

1.  The report creates 2 prompts for fund code, the first is a list of fund

     codes from the database and the second is the list of static choices.

2.  The prompt doesn't give me the list of fund codes when I choose

     'Yes, Select some Fund Codes'.

The report did filter on Grand totals when selected.  I hope that this gives you an idea of the scenario.  Any help would be appreciated.