iam having one report in which all the branches of hotels which are in profit ,out of profit should be displayed city wise.
iam using while loop for recordset and accessing profit wise,location wise and displaying.
without using loops it is displaying but i need to display to display location of that hotel wise(urban/rural).
how can i use cross tab with while loop and display? plz help me .