Drill down requirement

[kishorj1982]

Hi all,

I am using  Hierarchy Area->Country->company->Region

When ever I am navigating to company my navigation display chart caption would be

SelectedAreaName|SelectedCountryName

for Area to  Region  display would be

SelectedAreaName|SelectedCountryName|SelectedCo,panyName

Can you please suggest how to proceed

[Anil_Babu_Samineni]

What if Country has 2 values for selected one which is associate to another one?

[mdmukramali]

Hi,

can you tyr something like belw:

=if(GetPossibleCount(Area)=1,Area,'')&' '&

          if(GetPossibleCount(Country)=1,Country,'')&' '&

                    if(GetPossibleCount(company)=1,company,'')

[madhumitha]

Hi Kishor,

Please try this

GetFieldSelections(Area,',',100)&' '& GetFieldSelections(Country,',',100)&' ' & GetFieldSelections(company,',',100)&' ' & GetFieldSelections(Region,',',100)

Thanks!

[satheshreddy]

Hi Kishor,

use getfieldselection() function and use separator as you want.

getfieldselection(fieldname) &'|'&getfieldselection(fieldname)

Regards

Sathish