Re: [libreoffice-users] Re: Base and new Report Builder in 3.5

 Andreas ,

Thanks for your interest
With "grouping" i meaned having  the content of the grouped column on 
top or at the bottom off the items off the same group.
We where thinking on a macro who use a resulstet to fill the spreadsheet 
cell by cell  with some counters who are making a groupheader or footer  
when  the content of a column changed to a different vallue.
I look also a bit closer to the pivot tables

Greetz

Fernand





> Am 13.03.2012 12:11, Fernand Vanrie wrote:
> > It would be handy to see some examples of how you make reports with
> > calc. We have questions on how to Make headers , footers and grouping
> > somes results ?
> >
> > Greetz
> >
> > Fernand
>
> Page headers and footers can not have database content unless you 
> write a macro. But even with a macro the header/footer content will be 
> the same on every page.
> Of course you can have column headers and column footers with 
> additional formulas.
> Grouping can be done by the database software (SELECT ... GROUP BY ... 
> ORDER BY ...) or by a pivot table (aka data pilot). Pivot tables are 
> database reports. They follow the exact same logic as a SELECT ... 
> GROUP BY ... query.
> In addition, a pivot table can utilize the horizontal dimension by 
> means of column fields.
> http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/DataPilot 


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted