Ask Your Question
0

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
0

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

Ratslinger gravatar image

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

Hello,

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

Edit:

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

Comments

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

Stats

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

Seen: 42 times

Last updated: Dec 03 '20