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
Sum in Report ODBC to MySQL
Re: Sum in Report ODBC to MySQL
OK got it working via JDBC as well.
Similarly the results of the sums have more to do with fiction than reality.
I have a strong commitment to Open Source software but I have to say this is bordering on "User Aggressive"
I think I'll run SQL queries directly on the database to get some sensible numbers.
Very dissapointing
Ken
Similarly the results of the sums have more to do with fiction than reality.
I have a strong commitment to Open Source software but I have to say this is bordering on "User Aggressive"
I think I'll run SQL queries directly on the database to get some sensible numbers.
Very dissapointing
Ken
OOo 3.3 on FC14
Re: Sum in Report ODBC to MySQL
Base UI, and report builder designed with HSQLDB syntax, which is a built-in database, which has different dialect in SQL than MySQL if you find it not working with some case, caused by different SQL implementation, is usual. As you find, use SQL direct mode where you can use server specific settings.
You will not find opensource and paid tools which works same, in different SQL implementations. You needs to find a tools which fit to your goals.
You will not find opensource and paid tools which works same, in different SQL implementations. You needs to find a tools which fit to your goals.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
Hungarian forum co-admin