Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I want to show dynamic header name changing for example ='country =' & country, if i select single country it will show country name on caption but if i select more than one selection on country it did not show on caption and what is difference between ='country =' & country and ='country =' & only(country) please let me know solution for this requirement
Thanks in Advance
Nihhal
Above are possible solutions, but it will always depends on what you're exact requirement is. Try also below:
='Country = ' & Concat(DISTINCT Country,', ')
Concat() function, will provide you list of entity depending on your parameter. For above example, it will give you list of all distinct or unique country names when nothing is selected in list box, and it will show you one country name when selecting one country, so on...
Regards,
Bill