Sorting Primary Column in Reports
Hi guys,
Not sure if this is a bug or a "feature"
I can't seem to sort the primary column from a report. From the active sheet (no problem), but the purpose of reports is to have our own view and leave the active sheet alone.
And, yes, I don't have any other filters on.
Can anyone advice?
Paola
Answers
-
Are you using Grouping in your Report?
Grouping will automatically set your Report to Sort by the Group first, Alphabetically. Then if you apply a Sort, it will organize the rows within each Group, but not the Grouping structure. Does that make sense?
See: Sort Your Report Results with Report Builder and Configure grouping to organize results in report builder
Cheers,
Genevieve
0 -
Hi Genevieve,
No, the report is not grouped.
Thanks,
Pao
0 -
Would you be able to post a screen capture of what you're seeing, and the Sort not applying? (But block out sensitive data).
0