Sorting Primary Column in Reports

Paola Barlow · 03/31/22

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

Genevieve P. · 04/04/22

Hi @Paola Barlow

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

Paola Barlow, PMP · 04/04/22

Hi Genevieve,

No, the report is not grouped.

Thanks,

Pao

Genevieve P. · 04/05/22

Hi @Paola Barlow, PMP

Would you be able to post a screen capture of what you're seeing, and the Sort not applying? (But block out sensitive data).

cyrusmody · 05/21/23

I also seem to be having this problem... The primary column doesnt appear as an option when you select the sort function...

Andrée Starå · 05/21/23

Hi @cyrusmody

I hope you're well and safe!

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

cyrusmody · 05/22/23

Sure - here you can see even though I am typing "Task name" there is no such option for sort.

Genevieve P. · 05/22/23

Hi @cyrusmody

Try typing in "Primary" to see if "Primary" comes up as an option. Since you can re-name a Primary Column in a Report, it uses the default label in the different Report builder options.

For example, I titled my Primary Column to be "New Title", but note that it appears as "Primary" in the Sort dropdown list:

Cheers,

Genevieve

cyrusmody · 05/22/23

That seems to have worked! Thanks!

Sorting Primary Column in Reports

Answers

Categories