How to use sorting in an Advance Workshop list?

 
  • Information
  • Software
    Advance Workshop
  • Module
    Advance Workshop - All
  • Version
    ≥ 2016
  • Type
    General
  • Difficulty
    *

Open the Advance Workshop Management Tools. Go to “Reports Customization”, select a report and double click to open it.

Wie können bei der Positionierung Präfixe vergeben werden?

Select “Table1”, and then click “Property dialog…” in the lower right corner.

Wie können bei der Positionierung Präfixe vergeben werden?

The objective is to sort all data, respectively, by “Profile”, by “Material”, and by “Length”.

In the “Table - Sorting” dialog box, access the “Sorting” tab.

Use the “+” (Add) button to add a new field.

In “Expression”, click the down arrow button to open the drop-down list and select Fields!SHAPE.Value for the first field (Profile).

Wie können bei der Positionierung Präfixe vergeben werden?

Repeat this step two more times for the “Material” and “Length” fields.

Wie können bei der Positionierung Präfixe vergeben werden?

The last necessary step is to change the last value, because the first two values are strings (and when reading data, all fields are strings), but for “Length” to be sorted correctly, it must be interpreted as a number.<br><br> To change this value, open the &ldquo;Expression&rdquo; drop-down list and select <Expression…>.

Wie können bei der Positionierung Präfixe vergeben werden?

Insert “ToDouble” before the Fields!LENGHT.Value string, as in the image below, then click “OK” to confirm.

Wie können bei der Positionierung Präfixe vergeben werden?

Click “OK” to close the “Table - Sorting” dialog, then save the report.

GRAITEC GROUP 2017 At GRAITEC we take privacy seriously. Please read our privacy policy.