Bug 147573 - Standalone base reports document
Summary: Standalone base reports document
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.3.0.3 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-02-21 12:46 UTC by cianoz
Modified: 2022-03-01 11:51 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description cianoz 2022-02-21 12:46:31 UTC
Description:
In LibreOffice Base you can create forms and use them both inside Base and as standalone documents.
But you can't create independent standalone documents for reports; a report can be run/open only from within a Base file.
Overtake this limitation would be a huge improvement.

Steps to Reproduce:
No step to reproduce because it's a missing feature.

Actual Results:
Currently you can't create or save a Base report as standalone document.

Expected Results:
Create a Base report as independent / standalone document


Reproducible: Always


User Profile Reset: No



Additional Info:
NA
Comment 1 Robert Großkopf 2022-02-26 10:40:57 UTC
Isn't possible at this moment without macros. Would be a good feature, because external forms will be able to print data through a report.

At this moment a macro will help:

SUB Reportstart(oEvent AS OBJECT)
DIM oField AS OBJECT
DIM oForm AS OBJECT
DIM oDocument AS OBJECT
DIM oDocView AS OBJECT
DIM Arg()
oField = oEvent.Source.Model
oForm = oField.Parent
sURL = oForm.DataSourceName
oDocument = StarDesktop.loadComponentFromURL(sURL, "_blank", 0, Arg() )
oDocView = oDocument.CurrentController.Frame.ContainerWindow
oDocView.Visible = False
oDocument.getCurrentController().connect
Wait(100)
oDocument.ReportDocuments.getByName("MyReport").open
oDocument.close(True)
END SUB

Tested with LO 7.3.1.1 on OpenSUSE 15.3 64bit rpm Linux
Comment 2 Alex Thurgood 2022-03-01 10:04:26 UTC
(In reply to cianoz from comment #0)
> Description:
> In LibreOffice Base you can create forms and use them both inside Base and
> as standalone documents.
> But you can't create independent standalone documents for reports; a report
> can be run/open only from within a Base file.
> Overtake this limitation would be a huge improvement.
> 


My understanding is that this feature was apparently partly/wholly removed with the removal of the old C++ report writer code, and hasn't been re-engineered.


FWIW, you might want to look at:

https://forum.openoffice.org/en/forum/viewtopic.php?f=29&t=81229

and

https://extensions.libreoffice.org/en/extensions/show/basereportextension

as somewhat simpler alternatives / workarounds to using the Java-based report builder that comes with LibreOffice.
Comment 3 Alex Thurgood 2022-03-01 11:51:23 UTC
(In reply to cianoz from comment #0)
> Description:
> In LibreOffice Base you can create forms and use them both inside Base and
> as standalone documents.
> But you can't create independent standalone documents for reports; a report
> can be run/open only from within a Base file.
> Overtake this limitation would be a huge improvement.
> 

Historically, with StarOffice and OpenOffice.org when initially released, you could do this and decide whether the standalone Writer document would be a "set-in-stone" report or a dynamic report. The dynamic report would update each time you ran it (rather nifty functionality). Unfortunately, I seem to recall that that functionality was removed when Sun introduced embedded hsqldb into OpenOffice.org 2.0.