Jump to content

wall report in worksheet


Recommended Posts

I'm trying to access the data included in a wall in a worksheet. Namely the description field in the wall data. I can access door data, but all the information in the walls seems to be inaccessible. Can anyone point me to a tutorial or to the page in the manual where this process is explained. Seems a waste to have all these neat data fields in a wall and then have to manually type wall descriptions in a worksheet. Thanks in advance for any help.

Link to comment

Okay, I have given up.

When I enter the formula it simply repeats itself in the column and does not return data.

The template would be helpful if I could find a way to unhide the row that contains the formulas.

Why is it that when you use Tools-Create Report, it will only allow you to create a report for objects that have records, but the the default wall styles report schedules objects that do not have records? Does not make any sense.

The description cell does not display all the text in the description box even when word wrap is turned on.

There is no way to have the cells word wrap when the report is in the drawing.I.E Open the report set it to wrap and close the report, the text does not show up.

Extremely frustrating.

The other aspect that bothers me is that the schedule is dead. I cannot change a window by selecting it in the schedule and changing the type. There is no real link between the object in the model and the data. It is simply a report that was correct at the time it was made and cannot really be trusted. Not BIM at its best.

Link to comment

To see the formulas, click 'Database Headers' under the downward pointing rectangle at the top of the first column. Then click in the other columns accross from the empty triangles on the left to see formulas.

To see the criteria that sets which objects will be listed, highlite the database

header and go to 'Edit Criteria' under the downward triangle.

To refresh the list choose 'Recalculate'.

If your formulas aren't returning data it's because there's something wrong with the syntax of the formula. Field names are very literal.

I personally think the best way to get a handle on database worksheets is to start from scratch and make a couple of simple ones. Seems to me that a lot of people go with 'Create Report' and then don't know where to go from there.

Hope that helps


Link to comment

Thanks Charles, that'll get me part way there.

I created a new worksheet, set the row up as database and pasted the formula from the default wall styles template so there would be no mistake in syntax. Still will not return data. I know I am missing something very small, but cannot figure it out. Also cannot figure out how to get the word wrap to show all the characters.

I appreciate your help!

Link to comment


While you may have the correct syntax for the formula, it still has to match the criteria. So if your criteria lists all objects with record name 'Info' and your formulas are looking for record fields that don't exist, you'll get no data.

I'm afraid I can't be of much help with wall data specifically, cause I'm not an architect and don't use walls. I do, however, depend on worksheets for a ton of other things. Just keep applying boneheaded determination, and they will bend to your needs. Worksheets are hugely powerful in my world.

BTW...looks like we're neighbours!


Link to comment
There is no real link between the object in the model and the data. It is simply a report that was correct at the time it was made and cannot really be trusted. Not BIM at its best.

There is a real link FROM the object TO the report. Recalculation brings in the latest data.

This is actually a very complex issue. What aspects of an object does one really want to change in a text-only list view? The height or length of a wall? The size of a window?

Overall, the only context where decisions like this can be made is the "drawing". Notwithstanding, I'd love to change something now and then, but in the balance of things, the current scheme has a justification.

Link to comment

The worksheet that I created uses the same criteria as the default wall styles worksheet that comes with VW. It uses the same syntax (i pasted it). Yet the worksheet I created will not extract the data the same as the default.(the default report works fine) I am at a dead end. Maybe I'll send the file to NNA.

Link to comment

I'm not sure what you mean by import, but the wall sample report that ships with VW works just fine. Reports the data from the wall elements in my file like it is supposed to. I simply cannot replicate it. Perhaps I am meant to edit this file to suit my needs, and not try to create my own from scratch.

Link to comment


Have you been inserting the following text into a new worksheet header =__NNA_Wall_Style_Format.'Wall Function'

The single quote characters at Wall Function are Unicode Control Characters which you cannot enter with the keyboard...best to just copy paste the formula from the template worksheet.

Unless there is someone out there who has found a way to reproduce the special unicode character.

Link to comment

I'm looking for the data in the OIP I guess. The data that is reported in the wall. There are several built in fields such as description, mark, manufacturer, etc. I was trying to build my own, but it is not possible. You can only get these fields to report if you modify the wall styles report that is built in. If you try and make your own worksheet and paste the formula into it from the default it does not work. Go ahead and try it! Even pasting it in does not work.

Link to comment

Joe, I share your frustrations. If I could help you, I could help myself as I'm looking for the same answers. It seems that we can get and report data from just about everything else, just not walls. If so, someone would have had the answer by now. That leaves me to believe no one has a clue. I'll let you know if I stumble into something.

Link to comment

Okay,I got it to work by pasting your text. Thank You!

Now for the hard part: How do I get the cells to word wrap when I paste them into the drawing? And the second part of that: What is the character limit for the cells, as it appears a lot of the text gets cut off in the description field.


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.

Reply to this topic...

×   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...