Hi, I want to retrieve a report as below. To the left are labels and to the right are the values. City has 2 values.
Country USA
State OR
City Portland, Salem
However i get the above in 2 seperate pages as below
page 1
Country USA
State OR
City Portland
page 2
Country USA
State OR
City Salem
Is there a way i could get both cities seperated by a comma or on a seperate line but same page?
The database might not have cities for some states and countries, in that case i just need country and state populated. However i see that if city is empty it is returning nothing, ie even country and state are not returned?
Thanks
Edited by sa-user - 25 Jul 2011 at 12:02pm