Jump to content
  • 0

Using Plant Report to Create Basic Planting Key


justinekwood

Question

I use VW2019 and I want to use the plant report tool to produce a basic key for my planting plans.  Basically just showing the 2D symbol and the Latin Name.  No quantities, no common names, no 1 row for each occurrence of that plant.

 

I have used the basic plant report with images and can delete the columns I don't want but then I have a row for each occurrence.  So for example on my report I just want to show Rosa Munstead Wood once rather than the 5 times it appears.

 

I can't see how to do this on custom report as this doesn't show the plant field options.

 

Is there a tutorial on the/amending and deduplication within custom reports or can someone simply explain?

 

Thanks

 

Justine

Link to comment

19 answers to this question

Recommended Posts

  • 0
  • Vectorworks, Inc Employee

I would use the standard Plant List Simple with Images, that comes as a pre-formatted report in Landmark. Then edit to remove the columns you don't want (just right-click on the column headings you don't want and choose to delete the column).

  • Like 1
Link to comment
  • 0

Tom and Tamsin - is there a simple way that I can add the Latin Name Criteria to the Basic Template with Images?    I can add a column but I am unsure how to link the Latin name Criteria contents to it.  I work with Latin names not common names with Clients and Nurseries.

Thanks

 

Link to comment
  • 0

Hi @justinekwood Tamsin suggested you used the 'Plant List Simple with Images' preformatted report which has a latin names column already. But if you're using the 'Plant List Basic with Images' report you can right-click on the database header row (row 3 with the small black diamond) + select 'Edit Report'. Then in 'Edit Report' dialog, in 'Columns' pane, choose 'Select from records>plant record' + choose 'Latin name' in the list, then click on 'Add>>' button to add that column to your report.

 

In this dialog you can see all the possible fields you can add as columns + also see the existing columns in your report + remove them. This is basically the way you create database reports so useful to play around with it.

 

Sometimes easier to create your own database report from scratch - with a blank canvas - than work with the preformatted ones (in my opinion)

 

 

  • Like 1
Link to comment
  • 0

Are you asking how to insert images in the report? If so right-click on the header cell for the relevant column + select 'Insert Image Function'

Then if necessary go to 'Images' tab of 'Format Cells' dialog to set type/size/view of the image

Link to comment
  • 0

I am trying to create a customer report that has one column for the 2D symbol associated with the plan record, another column for the Latin name and the last column with the quantity that plant record.  So not importing an image - using something that exists already.

 

When I use the reformatted report (Basic with images) it is that image field that I am trying to create in a custom report.

 

 

Link to comment
  • 0

I have checked the number of worksheets and deleted all of them and still when I amend the report the changes do not show up after I click OK.  It just appears to hang in the edit report window and then when I click outside to return to the report nothing has changed.

Link to comment
  • 0
24 minutes ago, justinekwood said:

I am trying to create a customer report that has one column for the 2D symbol associated with the plan record, another column for the Latin name and the last column with the quantity that plant record.  So not importing an image - using something that exists already.

 

When I use the reformatted report (Basic with images) it is that image field that I am trying to create in a custom report.

 

 

Yes you just need to do what I said: Insert Image Function. And if it's the 2D look of the plant you want to show ensure in 'Images' tab of 'Format Cells' dialog you choose Top/Plan view. May be the default already.

 

 

Link to comment
  • 0

Ahhh thanks that is all clear.  Last question is how do I deduplicate.  I have many borders using the same plant records.  I have clicked summarise but I still have a row per mention of the plant record.  I just want to deduplicate so that I have 1 row per plant record where the quantity totals ALL incidences of that plant record.

Link to comment
  • 0
58 minutes ago, justinekwood said:

Ahhh thanks that is all clear.  Last question is how do I deduplicate.  I have many borders using the same plant records.  I have clicked summarise but I still have a row per mention of the plant record.  I just want to deduplicate so that I have 1 row per plant record where the quantity totals ALL incidences of that plant record.

Not sure if you sorted this bit or not but basically using a combination of sort, summarise + sum in this dialog:

22959684_Screenshot2021-02-11at14_18_18.thumb.png.c193ef4ae4f49077f4a00d14e39cdf57.png

you should be able to get the data displaying exactly how you want

Link to comment

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.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...