You need to add a sort for EVERY column header (except quantity):
Thank you for your suggestion, anyway reducers don't seperate such as 75X40, 75X50 and 75X65 still show in 1 category. what should i do next???
kindly... and thank you for your suggestion.
This is how we get the items to seperate.
I'm still strugging with this-- exactly which setting do I change to get the ND to show both ports?
Thanks!
--viet
If you want main and reducing sizes together (e.g.: 4"x3") use 'Engineering Items_Size'. This works on version 2014 and up. BTW, if you are reporting items with different size formats in the same report, like fittings and bolt sets, you will need to set up and expression to select the correct format.
it works. Thank you!
Hello,
I think I found a solution to this specific problem. I had the same issue that my reducing components were all bundled to the main (r.e. largest) diameter in the report creator.
The solution that worked for me is as follows:
In the Group and Sort window (you may need to activate said window: View tab -> Windows -> Group and Sort) there is a class order specified. In the default state the size is referenced as ''EngineeringItems_NominalDiameter'' if you set this sort to: ''EngineeringItems_Size'' it should work like a charm. At least it did for me.
Screenshot for clarification: