Ask Your Question

Can MySQL views be used as a datasource for a Base report? [closed]

asked 2013-02-27 23:25:36 +0100

John k. King gravatar image

updated 2014-06-09 16:05:38 +0100

bencomp gravatar image

New to LibreOffice, experienced with MS Access and Visual Basic.

Connected to mysql db via odbc. Trying to create a report using a view as a datasource. I get errors about illegal characters when I do so. The errors go away if the report is simplified to include only integer data fields. Adding back in text data fields the errors complain of fields containing parentheses. Also, when adding fields to the report in design mode, the size of the field control is very tall compared to normal and does no contain the field name. The label does contain the default value (field name). Again, if it is in integer data field everything is as though the data is sourced from a table. If it includes text fields, then errors are generated and I don't understand why.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-25 00:18:04.784500


Can you show example names of the columns in the views? Do you create aliases for these columns using as, e.g. SELECT CONCAT(thing1, thing2) AS concatenation_of_things FROM table, so that there are no parentheses in the column names? Have you tried using the native JDBC connector or 'normal' JDBC connector?

bencomp gravatar imagebencomp ( 2014-01-11 14:12:55 +0100 )edit

We would need to see what the field names and/or aliases are that are used to build the view in order to be of some help, I guess.

Alex Thurgood gravatar imageAlex Thurgood ( 2014-01-18 18:25:54 +0100 )edit

It also might help if you only put one question instead of three different ones in the same post.

Alex Thurgood gravatar imageAlex Thurgood ( 2014-04-27 17:18:09 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2014-06-09 14:49:07 +0100

Alex Thurgood gravatar image

Yes, having just tested this on mysql datasource wth a view defined server side, I can generate a report. The view appears as a table in the Report Designer wizard.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-02-27 23:25:36 +0100

Seen: 364 times

Last updated: Jun 09 '14