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

[Johnk.King]

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.

[bencomp]

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?

[iplaw67]

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.

[iplaw67]

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

[iplaw67]

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.