Hi,
Ive got a crosstab where there are country,state and region used as rows .Issue is by default in a crosstab they get grouped wheras while these are used in a list they are ungrouped .Although the aggregate function property for region,country and state is set to none and the query's autosummarize property is set to none,Still they are getting grouped.Any idea how to ungroup them.
Thanks