[libreoffice-users] Re: [Base] Can we connect a macro to a report?

2014-11-15 Thread Andreas Säger
Am 14.11.2014 um 23:58 schrieb Jean-Francois Nifenecker: Le 14/11/2014 21:22, Andreas Säger a écrit : It is possible to use Calc as reporting engine. Hit F4 and drag your query onto a spreadsheet cell. When the database content changed, click any cell in that import range and call

[libreoffice-users] Re: [Base] Can we connect a macro to a report?

2014-11-14 Thread Andreas Säger
Am 14.11.2014 um 16:03 schrieb Jean-Francois Nifenecker: Hi, I've got a working report in Base (connected to a Query, the data source being a Calc sheet). This is an accounting report that groups data according to some code in a column. A subtotal amount is accumulated for each group. I'm

Re: [libreoffice-users] Re: [Base] Can we connect a macro to a report?

2014-11-14 Thread Jean-Francois Nifenecker
Le 14/11/2014 21:22, Andreas Säger a écrit : It is possible to use Calc as reporting engine. Hit F4 and drag your query onto a spreadsheet cell. When the database content changed, click any cell in that import range and call menu:DataRefresh. The page layout is a bit tricky but with Calc's