Problem sorting Sheet List

[Sahay_R]

Hello all,

We have sheets organized by Discipline Name in our Project Browser. The problem is that the sheets re not sequenced in the order that they should appear in the set - which should be GENERAL, DEMOLITION, ARCHITECTURE. Since the discipline names are sorted alphabetically, the sheets appear in the Project browser with ARCHITECTURE, DEMOLITION, GENERAL.

The solution was to name each Discipline Name with a numerical prefix - which sorts the sheets correctly in the Project Browser. In the Sheet List, sheets are sorted by Discipline Name with a header BUT the header shows up as 00_GENERAL, instead of GENERAL. Yikes.

Any solutions?

Regards

Rina

[TripleM-Dev.net]

Hi,

Shouldn't the Sheet list not also be ordered as the Project Browser? and if it's ok for the Sheet List it sure would be ok for the Project browser.

use a second parameters and fill in the "00_general" etc... and leave the other as "General".

For the Projectbrowser: Use the Second Parameter

For the sheetlist (optional of course) also use the second parameter to group, but make it invisible and add the "Discipline" parameter also as group + Header option , now they are both grouped/ordered identical.

- Michel

[Ilic.Andrej]

I suggest leaving the discipline names without prefix (General, Demolition, Architecture) and using some custom project parameter for grouping the sheet list. It could be an integer.

[Discipline]=General          corresponds to:   [Discipline Order]=0  

[Discipline]=Demolition    corresponds to:   [Discipline Order]=1

[Discipline]=Architecture  corresponds to:   [Discipline Order]=2

So the idea for sorting and grouping the sheet list is:

1. By: [Discipline Order]  (no header, [Discipline Order] is a hidden field btw)

2. Then by: [Discipline]  (as header)

[syman2000]

I use a different technique to fool the sheet list schedule to read GENERAL, DEMOLITION and ARCHITECTURE while the project browser has number prefix. It is difficult to achieve General since the browser is always sort by numeric or alphabet. To overcome this, I usually modify the schedule so it achieve what you want

First I would create a parameter call Sort Order and set it to number value

Here I would add calculated value and reference to sort order. Set it to text value and the formula I use would be if(Sort Order = 1, "GENERAL", if(Sort Order = 2, "DEMOLITION", if(Sort Order = 3, "ARCHITECTURE", "")))

For any sheet, you simply add those sheet to 1, 2 or 3 to get the header value.

In the sorting/grouping, I choose Sort Order first and follow by Drawing Type Override. Once you done this, the schedule will read GENERAL, DEMOLITION and ARCHITECTURE like the first screenshot.