Ask Your Question

Will subreports ever be available in Base report builder?

asked 2018-08-29 01:13:14 +0200

paradigm gravatar image

updated 2018-08-29 07:53:17 +0200

I would like to prepare reports that include unrelated information. Is this something that might be possible in future releases? I love how reports output into LO Writer, and then you can customize them. That makes them perfect for newsletters and such. If I could have subreports in there, it would be just divine!

While most of the info for my project will be related, the queries aren't always combinable (at least not at my skill level). I want to have weekly data as well as daily data on the same report. On top of that, the weekly data needs to be distinct. In any event, I would like to be able to just have a subform with any info I chose, like the weather for the week, next to another section with average test scores for the week.

More specifically, I am designing a database to store lesson plans. Lesson are numbered and dated and linked to one or more state standards using an association table. Likewise there are vocabulary words linked to each lesson. I would like the top of my weekly report to display all the state standards covered that week without repeating them (distinct), and another section showing all of the vocabulary words covered that week. Below that I want each lesson for that week sorted by date with several lesson fields printed out.

The principal requires printed reports in a certain format, however so far it looks like I'll have to print separate report pages to accomplish this which doesn't quite hit the mark. One for weekly state standards, one for Weekly vocab, an then one for the lessons. However I would rather have them all in one report, especially because paper is so precious. Currently teachers are using MS Word to fill in a template, but time is even more precious than paper, and I think I can show them a far better way, if I can get this to work, and for free.

I am exploring alternatives. I have already set up Base as a front end for the MySQL database incase I need to experiment with some free report (BI) platforms (overkill?). Also I can design web based reports myself that look exactly like I want at the cost of lot more time in this volunteer venture. I am also learning more about database incase I can figure out a way to overcome this with better queries or something, but I still wouldn't have the flexibility that I desire.

At the end of the day I really don't have a need for Business Intelligence suites or a website, just simple sub-forms would do. And if my finished report could be output into LO Writer which could be edited to slip in a bi-weekly newsletter, it would be like magic!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-08-29 01:46:54 +0200

Ratslinger gravatar image

updated 2018-08-29 02:17:42 +0200


See Bug #114062 for this request.

Also could you explain what you mean by "unrelated information" as sub-reports usually are related to something.

edit flag offensive delete link more


Thanks for your input. I have included more information.

paradigm gravatar imageparadigm ( 2018-08-29 07:34:00 +0200 )edit

@Ratslinger, I'm assuming, after the description, that it is articles (news).

ebot gravatar imageebot ( 2018-08-29 08:40:14 +0200 )edit

@paradigm For the items you have now presented, I don't know of any free software to accomplish your request. At best, report generators with these capabilities (Jaspersoft Studio comes to mind) cost quite a bit & I don't see LO putting this into Report Builder.

Ratslinger gravatar imageRatslinger ( 2018-08-29 16:26:23 +0200 )edit

I searched and found several free reporting packages, but they all seem like overkill. After going through the trouble of converting my DB from LO Base to MySQL in preparation of trying one of those packages I just went ahead and made a web based report and it's working beautifully. I'll just output the reports with the web app and continue to use Base for the forms for now. I might make web based forms later, but this solution will due for now with my small project.

paradigm gravatar imageparadigm ( 2018-09-12 07:45:37 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-08-29 01:13:14 +0200

Seen: 117 times

Last updated: Aug 29 '18