I have been asked to update the standard "Drawer Box List Report" that we generate for the shop with a few items to make it easier and provide more information.  I am having some issues getting things to generate correctly or at all. 

I think these would also be good options to add into future reports so they are more robust and fully operational. 

1. Bay Locations
1. Using the {Subassemblies.BayPosition} I am able to get the bay position number on the report. (71, 79, etc)
2. While that is a start it doesn’t help anyone who doesn’t know what the bay positions mean.
3. How could I write the formula to say “IF(BayPosition=71,”Top Drawer,else)”?

                                                               i.      I tried writing an if/then and it hasn’t worked yet.

1. Adding Drawer Track per box
1. They would like us to list the drawer track that should be applied to each box per line item. 
2. This makes sense to me since we can do 50-100 drawers a day using multiple different track.
3. I found and tried the {Hardware.Code} but I can’t get it to single out the drawer track specifically.