Build 24.1.1030.641

Foundation 25.0319

Master Cut Report

I'm trying to "group" certain parts together in the report. For example, for parts names we don't need to see "Base", "Tall", "Upper" nor do we need to know if a part is a left or right, if it is part of the carcass we don't need to know if its a top or bottom. For us simply grouping these parts by generic names like Gable, Top/Bottom is good enough. It really reduces the length of the printout and just gives us the common part sizes and quantities of each.

So far I've put in a pretty lengthy identical IIF statement in the expressions tab for GroupHeader5 (Parts.Name) and GroupFooterBand1 (Parts.Name text box.). It works for most of the parts except for some drawer box material sides, fronts and backs. I end up with multiple rows of same sizes parts with the same name instead of one row showing a quantity of 2,3,4,etc. If I remove the IIF statement and revert back to the original expressions just reading Parts.Name, the drawer parts group as expected.

Not sure if I'm going about this the right way with the IIF statements or if there is a better way.

{IIF(Parts.Name.Contains("Finished End Panel"),"Applied Gable",

IIF(NOT Parts.Name.Contains("Drawer") AND (Parts.Name.Contains("Top") OR Parts.Name.Contains("Bottom")),"Top/Bottom",

IIF(NOT Parts.Name.Contains("Drawer") AND Parts.Name.Contains("Side"),"Gable",

IIF(NOT Parts.Name.Contains("Drawer") AND Parts.Name.Contains("Rail"),"Rail",

IIF(NOT Parts.Name.Contains("Drawer") AND Parts.Name.Contains("Adj Shelf"),"Adj Shelf",

IIF(NOT Parts.Name.Contains("Drawer") AND Parts.Name.Contains("Adj Shelf Edge"),"Adj Shelf Edge",

IIF(NOT Parts.Name.Contains("Drawer") AND Parts.Name.Contains("Fixed Shelf"),"Fixed Shelf",

IIF(NOT Parts.Name.Contains("Drawer") AND Parts.Name.Contains("Fixed Shelf Edge"),"Fixed Shelf Edge",

IIF(NOT Parts.Name.Contains("Drawer") AND Parts.Name.Contains("Back"),"Back",

IIF(NOT Parts.Name.Contains("Drawer") AND Parts.Name.Contains("Blind Stile"),"Blind Stile",

IIF(NOT Parts.Name.Contains("Drawer") AND Parts.Name.Contains("Blind Panel"),"Blind Panel",

IIF(NOT Parts.Name.Contains("Drawer") AND Parts.Name.Contains("Cleat"),"Cleat",

IIF(NOT Parts.Name.Contains("Drawer") AND Parts.Name.Contains("Nailer"),"Nailer",

IIF(NOT Parts.Name.Contains("Drawer") AND Parts.Name.Contains("Divider"),"Divider",

IIF(NOT Parts.Name.Contains("Drawer") AND Parts.Name.Contains("Division"),"Division",

IIF(NOT Parts.Name.Contains("Drawer") AND Parts.Name.Contains("Front"),"Front",

IIF(NOT Parts.Name.Contains("Drawer") AND Parts.Name.Contains("Door"),"Door",

IIF(NOT Parts.Name.Contains("Drawer") AND Parts.Name.Contains("Left FE"),"Left FE",

IIF(NOT Parts.Name.Contains("Drawer") AND Parts.Name.Contains("Right FE"),"Right FE",

IIF(NOT Parts.Name.Contains("Drawer") AND Parts.Name.Contains("Face Frame"),"Face Frame",

IIF(NOT Parts.Name.Contains("Drawer") AND Parts.Name.Contains("Stile"),"Stile",

IIF(NOT Parts.Name.Contains("Drawer") AND Parts.Name.Contains("Stile Chamfered Return"),"Stile Chamfered Return",

IIF(NOT Parts.Name.Contains("Drawer") AND Parts.Name.Contains("Stile Corner Return A"),"Stile Corner Return A",

IIF(NOT Parts.Name.Contains("Drawer") AND Parts.Name.Contains("Stile Corner Return B"),"Stile Corner Return B",

IIF(NOT Parts.Name.Contains("Drawer") AND Parts.Name.Contains("Stile Radius Return"),"Stile Radius Return",

IIF(NOT Parts.Name.Contains("Drawer") AND Parts.Name.Contains("Sub Front"),"Sub Front",

IIF(NOT Parts.Name.Contains("Drawer") AND Parts.Name.Contains("Sub Back"),"Sub Back",

IIF(NOT Parts.Name.Contains("Drawer") AND Parts.Name.Contains("Sub Side"),"Sub Side",

IIF(NOT Parts.Name.Contains("Drawer") AND Parts.Name.Contains("Sub Bottom"),"Sub Bottom",

IIF(NOT Parts.Name.Contains("Drawer") AND Parts.Name.Contains("Sub Top"),"Sub Top",

IIF(NOT Parts.Name.Contains("Drawer") AND Parts.Name.Contains("Partition"),"Partition",

IIF(NOT Parts.Name.Contains("Drawer") AND Parts.Name.Contains("Kick"),"Kick",

IIF(NOT Parts.Name.Contains("Drawer") AND Parts.Name.Contains("Sleeper"),"Sleeper",

IIF(Parts.Name=("Left Drawer Side") OR Parts.Name=("Right Drawer Side"),"Drawer Side",

IIF(Parts.Name=("Top Drawer Front") OR Parts.Name=("Bottom Drawer Front") OR Parts.Name=("Second Drawer Front") OR Parts.Name=("Third Drawer Front") OR Parts.Name=("Forth Drawer Front") OR Parts.Name=("Fifth Drawer Front") OR Parts.Name=("Sixth Drawer Front") OR Parts.Name=("Seventh Drawer Front") OR Parts.Name=("Eighth Drawer Front") OR Parts.Name=("Ninth Drawer Front") OR Parts.Name=("Tenth Drawer Front"),"Drawer Face",

IIF(Parts.Name=("Drawer Sub Front"),"Drawer Front",

Parts.Name))))))))))))))))))))))))))))))))))))}