Summarized data into report header

Getting your data onto paper - or the web - Discussing the reports features of Base

Summarized data into report header

Postby Torieth » Mon May 04, 2015 9:24 pm

Hi!

I have a report for a productivity query as below:
Code: Select all   Expand viewCollapse view
SELECT "TAB_PRODUCAO"."DATA", "TAB_SETOR"."SETOR", "TAB_FUNCIONARIO"."NOME", "TAB_TIPO"."TIPO", "TAB_PRODUCAO"."PRODUCAO", "TAB_PEDIDO"."PEDIDO", "TAB_PEDIDO"."ENTRADA", "TAB_PEDIDO"."LOTE", "TAB_PEDIDO"."DESCRICAO", "TAB_PEDIDO"."TAMANHO", "TAB_PRODUCAO"."OBSERVACAO" FROM "TAB_PRODUCAO", "TAB_PEDIDO", "TAB_FUNCIONARIO", "TAB_SETOR", "TAB_TIPO" WHERE "TAB_PRODUCAO"."ID_PEDIDO" = "TAB_PEDIDO"."ID_PEDIDO" AND "TAB_PRODUCAO"."ID_FUNCIONARIO" = "TAB_FUNCIONARIO"."ID_FUNCIONARIO" AND "TAB_FUNCIONARIO"."ID_SETOR" = "TAB_SETOR"."ID_SETOR" AND "TAB_PRODUCAO"."ID_SETOR" = "TAB_SETOR"."ID_SETOR" AND "TAB_PRODUCAO"."ID_TIPO" = "TAB_TIPO"."ID_TIPO" AND "TAB_PRODUCAO"."DATA" >= :DataInicial AND "TAB_PRODUCAO"."DATA" <= :DataFinal


Image

It's just a query to retrieve the records "names" through their ID. It still basically just the table "TAB_PRODUCAO"

This query records have the following look:

Image

Where I'd like to report the field called "PRODUCAO" grouping by "DATA" then "SETOR" then "NOME" and then "TIPO". I managed to do that with headers but, I'd like also to add a summarized table on each "DATA" header to show the total for each "TIPO" separated also by "NAME" and "SETOR". Something like the following:

Image

Can I do that?
Open Office 4.1.1
Windows XP SP 3
Torieth
 
Posts: 10
Joined: Wed Apr 29, 2015 2:23 pm

Re: Summarized data into report header

Postby MTP » Wed May 06, 2015 8:38 pm

I'm not sure if you can have the complete table. At least the subtotals can be done in a footer or header. Perhaps this thread could get you started: [Solved] Subtotaling in Group Footer
OpenOffice 4.1.1 on Windows 10, HSQLDB 1.8 split database
User avatar
MTP
Volunteer
 
Posts: 1620
Joined: Mon Sep 10, 2012 7:31 pm
Location: Midwest USA

Re: Summarized data into report header

Postby Torieth » Wed May 06, 2015 10:07 pm

Thnak you, MTP!! Your link is in the right direction, but, is not exactly what I need.

This link helps to summarize only "TITHES AND OFFERINGS" from the GRAND TOTAL. What I need is this, but, for each of the funds, considering I can't name all funds in some function because they won't be the same all times.
Open Office 4.1.1
Windows XP SP 3
Torieth
 
Posts: 10
Joined: Wed Apr 29, 2015 2:23 pm


Return to Reporting

Who is online

Users browsing this forum: No registered users and 1 guest