Ask Your Question

doc for LO base reports on linux? [closed]

asked 2016-09-22 20:26:18 +0200

LewG gravatar image

updated 2020-09-12 15:34:44 +0200

Alex Kemp gravatar image

I've installed ubuntu 16.04. Using the LO base that comes with it, I'm able to access db files created in AOO base under windows. I'm new to linux and not a trained programmer, but I'm usually able to figure out procedures and solutions for some things.

But since moving to ubuntu, I can't edit reports well. I want the report to provide subtotals for groups and a grand total. I had this working under windows. When I edit the odt report output, it doesn't appear or work as it did under windows. The supplied formats organize the items visually in appropriate groups, but I can't get calculated fields to work.

This very good series -- -- is very helpful with examples that I used successfully under windows to get the result I want. But those videos (and the user guide pdf) show colored sections for page headers, group sections, footers, and menu items (control, data, function, accumulate) that are not available now that I'm on ubuntu. The user guide says that you can do what I want, but it doesn't describe how to do that or where to find the report builder or how to use that. Text-only doc on reports that I've seen don't explain how to do it.

I downloaded and installed basereportextension.oxt. (At least I think I installed it -- installations in linux not as simple and clear as in windows.) No difference in what I see.

Before I face the hassle of installing AOO to try that, can someone tell me: when building reports under ubuntu , should I be seeing the same thing or something different from what I saw under win10?

If it's supposed to look and function differently, can you point me to doc that clearly and practically explains how to do what I want under linux?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-09-12 15:36:39.211067

1 Answer

Sort by » oldest newest most voted

answered 2016-09-22 22:14:05 +0200

Ratslinger gravatar image

Whether using Linux, Windows or Mac you should see little if any difference in Base. Base comes with Oracle Report Builder already installed and there is no need to install any extensions.

Begin by starting your database (.odb file). This brings up the following screen:

image description

By clicking Reports in lower left corner, you are in the report builder section and any defined reports are listed to the right. Double clicking on a report will generate that report. To Edit the report configuration, right mouse click on the name of the report and select Edit. This will bring up Oracle Report Builder so you can make any necessary modifications.

There are many publications available for LO base on this page: click here.

If this answers your question please click on the ✔ (upper left area of answer).

edit flag offensive delete link more


It doesn't behave the way AOO did under windows. In your link, the pdf on reports shows on page 29 what I saw. In AOO I added a text field then changed properties to present a subtotal for my group. This video shows what I saw at minutes 1:20, 2:15, 2:50. Now editing a report is black&white, no sections on the left, I can't even see properties for text fields.

LewG gravatar imageLewG ( 2016-09-30 22:51:23 +0200 )edit

The page 29 image is what I see all the time when editing (right click on report name & select Edit). Not sure on the video - there are multiple on the page. Which one are you talking about? When you run a report and then click the upper right button Edit Document this is a black & white Writer document. Do you see LibreOffice Writer at the top of the form you are editing?

Ratslinger gravatar imageRatslinger ( 2016-10-01 05:27:52 +0200 )edit

Sorry for my delay. Life happened for a while.

The video is #71. It looks like page 29. When I run the report, the output is a Writer document. When I right click on the report name, I get something to edit in Writer.

I'm also unable to run a report that takes input parms (begin/end date). The output is a blank document. My next guess is that it's because I created the report under windows. I'm willing to create the report new in LO under linux, but then I run into documentation issue.

LewG gravatar imageLewG ( 2016-11-01 23:18:00 +0200 )edit

Your question and comments are not consistent and create a lot of confusion. Page 29, the video @ 1:20 and the video @ 2:50 is the Oracle Report Builder for editing the report. You say it looks like this but also not in color - confusing. If you don't see properties use the toolbar button for 'Properties' (to right of pointer arrow) or select from menu View->Properties. The black & white Writer document (video @ 2:15) is the created report result from the design in Report Builder.

Ratslinger gravatar imageRatslinger ( 2016-11-02 07:15:01 +0200 )edit

As for input parameters, this is a separate issue and requires more information. It would be best put as a new question. Since this involves a query, it would be helpful to include the query, what your input is and the specific field type in the table it is referencing. The report should work if designed in Windows or Linus.

Ratslinger gravatar imageRatslinger ( 2016-11-02 07:21:14 +0200 )edit

Sorry. Yes, it is confusing. I didn't meant to say that the report parameters don't work in LO -- I was just saying that that report editing function shows the same problem. The problem is the general report editing environment. When I edit a report in LO under ubuntu, it doesn't look like it did in AOO under windows. AOO/windows showed the colored section identifiers on the left. (I can't add a screen shot, so I can only point to the pdf and videos.)

LewG gravatar imageLewG ( 2016-11-03 23:22:31 +0200 )edit

It seems there is something wrong with you installation/version. Try resetting the user profile - click here. If that doesn't work, I've experienced/seen some problems with distro versions. I would either delete that installation and install one directly from LibreOffice or contact ubuntu about the problem.

Ratslinger gravatar imageRatslinger ( 2016-11-03 23:33:26 +0200 )edit

In LO/ubuntu, I only get a writer document, and I can't add a text field that I can set as a counter or subtota, etcl. See minute 2:13 in video #72. I can Insert/FormControl/FormattedField. Right click/Control shows 'General', 'Data', 'Events' tabs. Data has a box for 'Data field', but it doesn't list the fields. No Data Field Type box as in the video. In general, it's not working as it did in AOO.

LewG gravatar imageLewG ( 2016-11-03 23:39:56 +0200 )edit

Our comments crossed. I'll try those measures. thanks

LewG gravatar imageLewG ( 2016-11-03 23:40:58 +0200 )edit

If you could upload your .odb (without any personal/confidential info) it may expedite this process.

Ratslinger gravatar imageRatslinger ( 2016-11-04 01:32:34 +0200 )edit

Question Tools

1 follower


Asked: 2016-09-22 20:26:18 +0200

Seen: 120 times

Last updated: Sep 22 '16