Sum in Report ODBC to MySQL
Posted: Mon Nov 14, 2011 11:11 pm
Hi, I have a table in MySQL which has, among other things, cost and date columns. I have used ODBC to connect OOo Base to the database.
I'd like to generate a report with summary totals by month. The cost field is of type FLOAT.
I have installed the report builder and followed directions to insert a text box into the report, that is sorted by the Extension data field, with a =AccumulationCost[Extension] entry in the box.
What I get is almost, but not exactly twice, the expected result.
If I capture the same data in a spreadsheet and import that into a OOo Base database with its native filesystem database I get the right answers.
Is this an ODBC 'feature'
I'm currently wrestling with getting jdbc working to see if that is any better.
This is really stretching my patience with OOo Base....
Ken
I'd like to generate a report with summary totals by month. The cost field is of type FLOAT.
I have installed the report builder and followed directions to insert a text box into the report, that is sorted by the Extension data field, with a =AccumulationCost[Extension] entry in the box.
What I get is almost, but not exactly twice, the expected result.
If I capture the same data in a spreadsheet and import that into a OOo Base database with its native filesystem database I get the right answers.
Is this an ODBC 'feature'
I'm currently wrestling with getting jdbc working to see if that is any better.
This is really stretching my patience with OOo Base....

Ken