Print Page - Tree Prompt Selections on Page Header

Title: Tree Prompt Selections on Page Header
Post by: laks on 11 Feb 2010 12:56:05 PM

Hi All,

In prompt page I am using a tree prompt for user input. In report I want to show user selections in Page Header.

For Example, Tree Prompt for location let's say hierarchy is Country>>State>>City. If user selected SAN FRANCISCO(which is under USA>>CALIFORNIA), in page header I want to show

Count - USA
State - CALIFORNIA
City - SAN FRANCISCO

If user selected SAN FRANCISCO (Under USA>>CALIFORNIA), MELBOURNE (under AUSTRALIA>>VICTORIA), I want to show

County - AUSTRALIA, USA
State - CALIFORNIA, VICTORIA
City - MELBOURNE, SAN FRANCISCO

Can someone please suggest how to do this

Thanks

Title: Re: Tree Prompt Selections on Page Header
Post by: anilkumar on 12 Feb 2010 11:38:51 PM

Hi

try layout calculation

Thanks & Regards
ANIL K.MARRI

Title: Re: Tree Prompt Selections on Page Header
Post by: paddhu on 16 Feb 2010 11:23:52 PM

I've tried many a way to get the same sort of display in my reports. The best I came up with was to use a list report with hidden borders and the data items filtered on the prompt.
In your case, as it is multiselectable, you could probably use a repeater that is again filtered on the prompt.
Use 3 repeaters beside the captions and drag country, state and province in each. Filter all the 3 on the prompt, and I think you should get what you want.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: laks on 11 Feb 2010 12:56:05 PM