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.
Hi Stuart,
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.
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.