COGNOiSe.com - The IBM Cognos Community

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?

Anyone??

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.