Ask Your Question

How do I edit the SQL generated for a report?

asked 2020-12-03 14:30:14 +0200

karelc gravatar image

I'd like to be able to see the SQL generated by the Report writer, but can't find how to do that. I can't even see where the parameters such as dates and other data filters used are held on the design form.

I'd be grateful for help with these.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-12-03 17:42:07 +0200

Ratslinger gravatar image

updated 2020-12-03 19:19:54 +0200


Report Builder does not generate any SQL. Reports are based upon tables views or SQL generated by the user.


Should also note, you can within Report Builder base a report on an SQL command you create. Again, not generated by Report Builder.

In all cases, since the user defines these items it is not clear as to why you do not know where they are.

Edit 2:

Perhaps the documentation will help -> LibreOffice Base Guide. See Chapter 6 - Reports in the Base section.

edit flag offensive delete link more


Hello Ratslinger, thank you very much for your reply, and taking the time to help me. After reading your answer I did a bit more digging by unpacking the odb file and examining the contents.xml file. Bearing in mind what you had said the whole thing and how it works is now very clear to me. Once again, thank you! Karel

karelc gravatar imagekarelc ( 2020-12-04 01:10:29 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-12-03 14:30:14 +0200

Seen: 42 times

Last updated: Dec 03 '20