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
[Solved] Chart in raport not saved
[Solved] Chart in raport not saved
Last edited by marklb on Wed Nov 13, 2013 11:12 pm, edited 1 time in total.
oOO 4.0.1
Windows Vista
Windows Vista
Re: Chart in raport not saved
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
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Chart in raport not saved
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,
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
Windows Vista
Re: Chart in raport not saved
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).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,
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Chart in raport not saved
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
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
Windows Vista
Re: Chart in raport not saved
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:
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice