Report Sorting by Sheets Names Starting with Numbers Out of Order

Hello,

I have a report being built off of 10 different sheets. Each sheet name is prefixed with a number and followed by the name (1. Project Name, 2. Project Name, etc). All was working well and the sheets were being sorted in the report by sheet name as expected until I came to sheet #10. Now the report sort order is 1, 10, 2, 3, 4, 5, etc. Is there a way to force the sheet named "10. Project Name" to display after 9 in the report?

Thanks!

Find more posts tagged with

Reports

Project Management

Comments

Andrée Starå

Hi Eileen,

Have you tried 01,02 - 09, 10? I think that will do the trick.

Best regards

Andrée

Eileen F

Hi Andrée,

I actually tested adding a leading zero to the single digit sheet names. It looks like it should sort correctly, however when I run the report it orders the sheets as follows: 01, 02, 03, 04, 05, 06, 09, 10, 07, 08. I've attached screenshots of the sheet names and report builder. I can't see why it would put 7 and 8 after 9 and 10.

Thanks,

Eileen

Report Builder.jpg

Andrée Starå

Hi again Eileen,

Maybe it has something to do with the reporting issue that was reported on earlier in the week?

Have a fantastic weekend!

Best regards

Andrée