[Solved] Chart in raport not saved

Getting your data onto paper - or the web - Discussing the reports features of Base
Post Reply
marklb
Posts: 12
Joined: Mon Nov 11, 2013 11:08 pm
Location: Poland

[Solved] Chart in raport not saved

Post by marklb »

HI ,

Iam new in base, I want to use chart in raport but I face soem problems,
OO 4.0.1 ORB 1.2.1

When I prepare simple raport is show data corectly, i save and open it again , chart is missing ?

Could you please advice,
Thanks
Last edited by marklb on Wed Nov 13, 2013 11:12 pm, edited 1 time in total.
oOO 4.0.1
Windows Vista
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Chart in raport not saved

Post by Villeroy »

As a work-around you may use Calc as reporting engine.
Register your database so it appears when you hit F4 in Calc.
Drag the icon of your table or query into a Calc document.
menu:Data>Refresh refreshes the import range.
[Tutorial] Using registered datasources in Calc
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
marklb
Posts: 12
Joined: Mon Nov 11, 2013 11:08 pm
Location: Poland

Re: Chart in raport not saved

Post by marklb »

Hi,
Yes, i have think about this, but using this way I face other problem,
as data in BASE will be updated, added, so chart data range will not reflect that,
if you know any workaround for that please let me know,
oOO 4.0.1
Windows Vista
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Chart in raport not saved

Post by Villeroy »

marklb wrote:Hi,
Yes, i have think about this, but using this way I face other problem,
as data in BASE will be updated, added, so chart data range will not reflect that,
if you know any workaround for that please let me know,
Data ranges imported from databases adjust to the actual size of the imported data area as if you would manually insert or delete new rows. All references in the importing spreadsheet adjust to the new dimensions of the refreshed import range (formulas, names, charts, conditional formats, validations, cell bound form controls). This makes database connections more useful and more reliable than any other data link (even database connections between 2 spreadsheets).
In addition, any formulas adjacent to the import range will also copied along the rows and columns, so you don't have to pull down when the range expands nor delete when the range shrinks.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
marklb
Posts: 12
Joined: Mon Nov 11, 2013 11:08 pm
Location: Poland

Re: Chart in raport not saved

Post by marklb »

HI Villeroy,

Yes you are completly right, it work as you described... thanks very much for help,
May I ask you additional question

as my work in BASE and CALC will be used by other peoply, more Dummy then I,
can you advice how I can make a button in CALC which will invoke => "menu:Data>Refresh refreshes the import range."
so person who onen cal will know to pysh button with make this refresh ?

thanks
oOO 4.0.1
Windows Vista
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Chart in raport not saved

Post by Villeroy »

Create your own toolbar with one button calling that command.
Create a text hyperlink or a hyperlink button with the following URL:
.uno:DataAreaRefresh

In either case the user should have selected one cell within the data range or the whole data range.

This macro does not depend on any selection but the given name should match the name of the database range:

Code: Select all

Sub refreshImport1
ThisComponent.DatabaseRanges.getByName("Import1").refresh
End Sub
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
marklb
Posts: 12
Joined: Mon Nov 11, 2013 11:08 pm
Location: Poland

[Solved]Re: Chart in raport not saved

Post by marklb »

herzlichen Dank,
Das is das
oOO 4.0.1
Windows Vista
Post Reply