Ask Your Question
1

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

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

John k. King gravatar image

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

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

Comments

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 +0200 )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 +0200 )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 +0200 )edit

1 Answer

Sort by » oldest newest most voted
1

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

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

Stats

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

Seen: 315 times

Last updated: Jun 09 '14