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?