Jump to content
Benson Shaw

Worksheet collapse or hide rows

Recommended Posts

Worksheet database headers calling valid data cause sub rows (item rows? not sure of name) to appear below the database row.  eg 12.1,12.2.12.3, etc.  Is there a way to collapse or hide these sub rows and show only the summation values in the header row?

 

thanks!

 

-B

Share this post


Link to post

No way that I know of.  Two options:

 

1.  Pick a field that is the same on all of the items and SUMMARIZE based on that column. That should get you one subrow.  Select the Sum Values option in each column and you should have the same values in the header and the subrow. Hide the headers and you should have what you are looking for.

 

2. Don't use a database at all and just use the functions with criteria. i.e. =Count((C=;'My_Class'))  Will return the number of objects in the class names My_Class. I don't think you can do this for Record.Field combinations.

  • Like 1

Share this post


Link to post

Great, Thanks, Pat!

 

I have 27 stainless panels with lattice cutouts, and about 1000 little pieces hanging in the lattice holes. Engineer needs total area and metal weight, but I don't want 1027 rows to show on the worksheet.  I used the blank, perimeter shapes drawn as polylines on their own layer, in their own class.

 

Made #2 work but with function =Count with the sum and summary options.  Then other columns for area and weight.

Couldn't get any results with=Count((C=;'Bridge3-PanelBlank')).  Maybe it's the hyphen in my class name.

 

Thanks again.

 

-B

Edited by Benson Shaw
brevity

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×