Does anyone have any input for me, or is my question confusing? I'm sure there is something simple that I need to do (or not do to get this to work). Basically, I want to create a report that lists plant ID's, quantity, height, and spread.
When I try to do this using the tools > reports > create report feature and indicate that I want to summarize by plant ID, the ID and quantity are accurate, but the height and spread values are not. If I do NOT summarize by plant ID, the height and spread values are accurate, but I get multiple lines for each plant ID (if the same plant is used in multiple groupings throughout the plant).
Any advice is greatly appreciated!