tamarindi Posted July 9, 2008 Share Posted July 9, 2008 I created a symbol's library of different furnitures. Each item should have a catalog number, dimentions of x,y,z, and other notes. The goal is to create a report that can sum the quantity of symbols/furnitures, and also show the other data. I tried first using the create report, which do the summing perfectly. How and where do i enter the other data? and how do i make a report that contains all of it? Is there a manual for reports?? do i need to know vectorscript? Thanks Quote Link to comment
Jonathan Pickup Posted July 9, 2008 Share Posted July 9, 2008 the other data need to be added to the symbol on the Object Info Palette (Data pane). you will need to make a record format for the objects to attache the data you want. you do not need to learn vectorscript Quote Link to comment
tamarindi Posted July 9, 2008 Author Share Posted July 9, 2008 how do i define the fields i need? in the data tab there are specific fields..and i need others.... and also - after entering this data will it automatically go into the report? or should i define fields again....? Thanks again... :-) Quote Link to comment
islandmon Posted July 9, 2008 Share Posted July 9, 2008 One Record > many Fields Create >NewRecord> Create NewField> define field 'type' > assign default Exit select> Object >OIP> select>NewRecord> select> NewField> enter data as required Then use the CreateReport Procedure to select>NewRecord>select>NewFields Quote Link to comment
tamarindi Posted July 9, 2008 Author Share Posted July 9, 2008 OK...got it !!! I created fields, entered data in the object info. Then created a report. all fields are there. One thing missing: I want a sum by criteria , for example a catalog number. how do i add this field??? it gives me a sum of total items, instead of per item.... Quote Link to comment
tamarindi Posted July 10, 2008 Author Share Posted July 10, 2008 questions: 1. I entered data inside the symbol, which affect the symbol and then being counted in the report. There is also an option to enter data outside the symbol. Does that override the original symbol data? 2. I added a "quantity" field and then in the report the sum function. The report always show one item, summarized. I guess something in the definitions is wrong...but i can't find it... Quote Link to comment
RickR Posted July 10, 2008 Share Posted July 10, 2008 I'm having a similar problem: http://techboard.vectorworks.net/ubbthreads/ubbthreads.php?ubb=showflat&Number=106449#Post106449 Summing values rather than sumarizing lists seems to be an issue. One workaround I found (if all items have the same value) is to multiply that value by the count of items. Although some folks complain of values adding when summarizing (window widths etc.) That's what I want but can't make it happen. Quote Link to comment
tamarindi Posted July 13, 2008 Author Share Posted July 13, 2008 Please if anyone can help... I entered data inside a symbol, so the report will calculate all symbols. should I attach record to all symbols as well? or is it disturbing the calculations???? Is there a manual for reports other then the VW help? Thanks again.... Quote Link to comment
daedalus Posted July 17, 2008 Share Posted July 17, 2008 Hi, I'm a bit confused about this process as well. I've created plumbing fixture symbols, attached record information to them, and managed to create a worksheet that successfully lists all of the plumbing fixtures. Somewhere along the way I opted to list repeat fixtures only once in the schedule based on the ID mark, e.g., if I use the same 'P-1' symbol twenty times in my drawing it only shows up on the schedule once. Very handy. Is there a way to automatically show how many instances of the symbol are in the drawing on the worksheet? Using the example above, can I create a field that will count up my twenty P-1 symbols? thanks! Quote Link to comment
Pat Stanford Posted July 17, 2008 Share Posted July 17, 2008 To get the single line, you have probably dragged the SUM icon/button to the top of one of the columns. To get the number of objects that are included in each row, add a column with a formula of =Count Pat Quote Link to comment
daedalus Posted July 17, 2008 Share Posted July 17, 2008 Pat, To get only one line in my worksheet for the multiple items in my drawing, I selected the "summarize items with the same: (mark)" option in Tools/Reports/Create Reports. The =Count formula works perferctly when I put it at the end of the database row. Completely mysterious to me why it works, but thanks so much!! -craig 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.