Ask Your Question
0

cannot create report in design view

asked 2018-11-01 22:46:25 +0200

dougmn gravatar image

I cannot create a new report in design view. I select "Reports" and on the "Tasks" section, I click on "Create Report in Design View" and nothing happens.

Here's the version I am using: Version: 6.1.2.1 Build ID: 1:6.1.2~rc1-0ubuntu0.18.04.1 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); Calc: group threaded

Can this be fixed?

edit retag flag offensive close merge delete

Comments

Can you create forms, open them and edit your data with them? I notice that one of the first things that happens when I do as you say above, is that I get a request for a password. Not that I expect you to get this, as I am connecting to MariaDB, but because connection to the database is one of the first things that should happen. So the reason I ask if you can create forms, open and edit w/ them, is to collect info about what else might not be working correctly, as a clue.

EasyTrieve gravatar imageEasyTrieve ( 2018-11-02 03:23:19 +0200 )edit

I also notice, thought it shouldn't matter, that you are running a fairly dated kernel (4.15). I'm using Debian stretch w/ 4.9.0-8-amd64. Another Q is if you're updated generally speaking, i.e. apt .. wise.

EasyTrieve gravatar imageEasyTrieve ( 2018-11-02 03:25:35 +0200 )edit

Yes, everything I do with forms works fine. Thanks for asking.

dougmn gravatar imagedougmn ( 2018-11-02 03:25:52 +0200 )edit

I'm fairly new to the linux world -- 3 or 4 months. I just install all the updates that come my way. The distro I'm using is FerenOS. What would be the effects of having the dated kernel that I have?

dougmn gravatar imagedougmn ( 2018-11-02 03:32:02 +0200 )edit

When I get stuck like this, usually I somehow try to divide and conquer. In your case, and I'm not sure which is easiest, I might try to install a 2nd version of LO, to see if it's version has anything to do with it. OR I might give your .odb file to someone else and see if they can create a report from it. OR I might reset your LO user profile and re-try. For me your distro and kernel version are suspect. I think I might try booting from another distro, via a CD or USB stick or something.

EasyTrieve gravatar imageEasyTrieve ( 2018-11-03 01:08:08 +0200 )edit
1

@EasyTrieve Curious as to why you believe kernel v4.15 is dated? Your v4.9 is much older! I personally use v4.15.0-33.

Ratslinger gravatar imageRatslinger ( 2018-11-04 05:45:58 +0200 )edit

@Ratslinger, Thanks for pointing out my embarrassing mistake.

EasyTrieve gravatar imageEasyTrieve ( 2018-11-04 06:36:57 +0200 )edit

Thank you @EasyTrieve and @Ratslinger for some good suggestions. Moving a few states away this week will keep me from testing them out. But I when I am able I will report the results back here.

dougmn gravatar imagedougmn ( 2018-11-05 16:32:57 +0200 )edit

3 Answers

Sort by » oldest newest most voted
0

answered 2018-11-03 03:08:50 +0200

dougmn gravatar image

updated 2018-11-05 21:28:23 +0200

Bug report #121136 https://bugs.documentfoundation.org/s...

The solution was found via the discussion in the bug report. My distro has additional packages "LibreOffice-report-builder" and "LibreOffice-report-builder-bin." I needed to have both of these installed for the report designer to work, but I only had the "LibreOffice-report-builder-bin" package installed. Installing the other package fixed my immediate problem of not being able to open the report designer. Then several other problems with designing and running a report showed up, which are probably separate issues which will require upgrading to a newer version.

edit flag offensive delete link more

Comments

@dougmn Glad all (sort of) is working for you now. Have never completely understood why disto versions regularly fail to include everything for LO. Base in its entirety is usually left off and Report Builder items missing here & there. I personally stay away from distro versions.

Ratslinger gravatar imageRatslinger ( 2018-11-05 21:41:07 +0200 )edit
1

answered 2018-11-01 23:50:51 +0200

Ratslinger gravatar image

Hello,

There may be two problems with filling your request. Have seen a few problems in this area using versions from the distro. Those problems were due to some item missing. On Ubuntu based systems the preferred method is through a PPA. See this page for details -> LibreOffice Fresh.

Even if that were to fix your immediate problem, there is an outstanding bug in Report Builder. Any labels used in the report will simply print Label once you exit the creation of the report. This bug is due to be fixed in version 6.1.3 and due to be released any day.

So the recommendation is to switch to the PPA and wait for the updated version release or install a version prior to version 6.1.1.x.

edit flag offensive delete link more

Comments

I added the PPA, but notice no change, either in report builder, or even in the version information that comes up with "Help-About LIbreOffice". Is this a bug I need to report?

dougmn gravatar imagedougmn ( 2018-11-02 03:14:37 +0200 )edit

Hello,

Just noticed your OS posted. Can't say this has anything to do with it but stranger things. And don't worry about your Kernel version - it is fine. Some systems I have are older & work just fine. Have just switched to Ubuntu Mate 18.04 where I have LO PPA v6.1.2.1 and all is working as it should (except it has the aforementioned 'Label' problem).

You may want to try resetting your user profile. See -> LibreOffice user profile

Ratslinger gravatar imageRatslinger ( 2018-11-02 03:45:23 +0200 )edit

Just after making my initial post, I suspected that having recently installed the "Base report extension" was the cause of my problem. I uninstalled it, but that did not help. I just checked the user profile. I restarted LO in safe mode, but that made no change as far a being able to use the report designer.

dougmn gravatar imagedougmn ( 2018-11-02 04:04:57 +0200 )edit

That is about the extent of the possibilities known to me on this subject. Best to file a bug report. After, please post bug # back here for others to reference. Not familiar with your distro so that is not out of the question.

Ratslinger gravatar imageRatslinger ( 2018-11-02 04:53:14 +0200 )edit
0

answered 2019-02-22 11:11:02 +0200

LO_user1 gravatar image

You have to just install LibreOffice-report-builder. Use this command in terminal. # sudo apt-get install libreoffice-report-builder. It will install Oracle report builder. Actually some distro do not install this app with LibreOffice. So your LO is missing report builder.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2018-11-01 22:46:25 +0200

Seen: 202 times

Last updated: Feb 22