Tree Prompt Selections on Page Header

[laks]

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

[anilkumar]

Hi

try layout calculation


Thanks & Regards
ANIL K.MARRI

[paddhu]

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.