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

How to (properly) display the values selected in a tree prompt

Started by Feanor, 30 Nov 2007 07:38:55 AM

Previous topic - Next topic

Feanor

I'd like some help with finding a proper way to display which values were selected by a user from a tree prompt.

I have a report containing a time-based tree prompt on the prompt page. After selecting one or more time values, the user submits the report and a mainpage is shown folowed by a data page containing a crosstab.

A business requirement is that the selected time values from the tree prompt are displayed on the mainpage (for distribution/printing purposes). When I insert a [Layout Calculation] based on the time parameter only the checked values (boxes) are shown on the mainpage. This way a user can not properly understand what was selected.

For instance, if I check the folowing values (items displayed bold):
Quote[2003]
    |- [Q 1]
    |- [Q 2]
[2004]
[2005]
    |- [Q 1]
           |- [January]
           |- [February]
    |- [Q 4]
           |- [November]
           |- [December]

The layout calculation shows:
Quote[Q 1] [Q 2] [2004] [January] [February] [November] [December]

So only the selected values are shown and it's not possible for someone who receives this report to determine to which hierarchy a member belongs.

Any ideas?

Feanor


MFGF

Hi,

The only approach that springs to mind is to display the contents of your tree prompt's query (which will be unfiltered) using something like a repeater, then use conditional formatting to change the format of the members in the prompt's parameter (ie your layout calculation) to bold.

Regards,

MF.
Meep!