BJSmith Posted May 9, 2007 Share Posted May 9, 2007 Ughhhh . . . I'm creating my first report and I want a basic plant list that shows plant ID, quantity, height, and spread. When I go to tools > reports > create report, and select my columns (based on plant record) and then choose summarize by plant ID, the result looks good except the height and spread are sums (I think) of all the plants with that plant ID! What am I doing wrong? Thanks, BJS Quote Link to comment
BJSmith Posted May 16, 2007 Author Share Posted May 16, 2007 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! Quote Link to comment
dspearman Posted May 16, 2007 Share Posted May 16, 2007 The height and spread you are putting on the report is the drawn size. Use the scheduled size instead. This one won't summarize. Quote Link to comment
BJSmith Posted May 16, 2007 Author Share Posted May 16, 2007 dspearman - Thanks for the response! A couple questions about scheduled size: (1) I see where scheduled size is available as a field when you first add a plant, but now that I have all of my plant graphics in place, I can't find where to go in and input that information. I'm working on my first draft of the design, so I haven't selected specific plants yet, I'm only interested in showing plant height and spread and texture. (2) Is scheduled size a freeform text box, so I could input something like "45h x 30s"? (3) Are there other fields that won't summarize - like if I wanted to show spacing or hardiness zone or something like that? Thanks again, BJS Quote Link to comment
dspearman Posted May 19, 2007 Share Posted May 19, 2007 In the Place plant tool settings dialog (get to it using the button on the mode bar), select the plant you want to modify using the pull down thumbnails, and click on the "edit current" button. Scheduled size is text. You can enter any text. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.