We have the ability in U15 to total in tables. How do I total the highlighted cells in the table below?
stuartw said:We have the ability in U15 to total in tables
Where have you seen that statement? A MicroStation Table is not a spreadsheet. It doesn't have arithmetic or algebraic functions.
Regards, Jon Summers LA Solutions
I guess that I have misread this as assumed that a table, which is not dissimilar to a report, would have the total function. At the moment tables are practically useless, which is why I copy and paste a spreadsheet into my drawings.
Marco Salino said:aggregates and totals are indeed in reports, which are not that similar to tables in many ways reports is the whole technology that harvests data and produce a table elements as a result. This doesn't mean that we could not look at introducing simple algebraic capabilities in table elements but this is currently still not possible
OK thanks. To be honest we haven't seem much need/use for Reports so have not really used them. Have tried but they don't really do what we want so was trying to use tables instead. tables have limited value at the moment as they don't offer the same level of capability as Excel. I will stay with Excel for the time being and add to drawing as required.
Thanks Stuart, honestly I doubt we could ever compete with Excel with our Tables elements, they are simply not meant to do that but we can surely look at a better integration.
What would you like reports to do that are currently not doing?
I concur with Stuart, no need for "reports" per say but I would use tables if they where more powerful. Perhaps a report could be made that isn't linked to item types or other data just user input? This may very well be possible already I haven't had time to look at reports with any real effort in a long time. I distaste linking tables to excel because it's too easy to break them and end up with major issue that needs to be resolved at the worst of times. Ideally deliverables need to be stand alone and robust enough to limit that kind of failure.
-Grant
Grant Wood said:Perhaps a report could be made that isn't linked to item types
One of the misleading effects of the Report Definition user interface (UI) is that it implies that you can only create a Report about Item Types. In fact, you can define a Report to harvest all kinds of DGN information.
You haven't told us what interests you, but here's an independent view of Reports, with examples of Area, Line, Reference and Cell reports. No Item Types were harmed when defining those Reports.
Marco Salino said:What would you like reports to do that are currently not doing?
Honestly I don't know, apart from make them simpler to use. I did have a look at reports/tables for simple building areas in conjunction with one of your technicians and found that even that was not simple to set up. Why is this so complicated? It was something to do with floor area not being able to be assigned as a property and had to be set up another way. What that is I can't remember .See below. Why can't floor be assigned as a property?
I did try to set up a report for a simple file (attached) and ran the report but only got a small table with no information! Why is that?3000.Items-reports test file.dgn
stuartw said: I did have a look at reports/tables for simple building areas in conjunction with one of your technicians and found that even that was not simple to set up
It is simple to set up. To make it simpler still, I've published an example with step-by-step instructions.
stuartw said:Why is this so complicated? It was something to do with floor area not being able to be assigned as a property
Things that have area have area and perimeter properties That includes MicroStation shape, complex shape and ellipse elements.
Jon Summers said:It is simple to set up. To make it simpler still, I've published an example with step-by-step instructions.
I downloaded the sample file and and can see where the information is coming from regarding area, etc but in my case I was told by Bentley tech. that as I want area s om m23 and ft2 then these had to be set up differently. As noted I can't remember how.
I my file I set item types with unit number, area m2, area ft2 and car parking but the report doesn't generate this information. Why not I wonder.
It shouldn't' be this difficult to set up floor areas in m2 and ft2.
Jon Summers said:Things that have ara (perhaps others as well) have an area property. That includes MicroStation shape, complex shape and ellipse elements.
As I have noted this isn't so easy when wanting to have areas in m2 and ft2.
stuartw said:this isn't so easy when wanting to have areas in m2 and ft2
stuartw said: I was told by Bentley tech. that as I want area s om m23 and ft2 then these had to be set up differently. As noted I can't remember how
Here's your file with additions. I've added a couple of Reports under category LA Solutions.
stuartw.Items-reports test file.dgn
And, since this thread is about totals in tables, I defined another Report that generates Count and Total Area...
If you would like to know how to add aggregates to a Report, read this article.