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.
stuartw said:I copy and paste a spreadsheet into my drawings
Have you tried using Excel as the data source for a table?
Lets you place a table using the data in an excel workbook or .csv file.
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
Product Manager, MicroStation
Bentley Systems intl
www.bentley.com
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?