Hello!
I have a datasource and I want to make several summations grouping the data by a column. I do not want to show all rows, I want to show the summations like this:
ValueColumn A Subtotal 1 (Sum of all rows whose key column has value A)
ValueColumn B: subtotal 2 (Sum ... value B)
ValueColumn C: subtotal 3 (Sum... value C)
..................
value N: N subtotal
Therefore I can not use DataBand or groupfooterband.
How I can do this set of summations?
Thank you very much.
Set of Summations group by key column.
Re: Set of Summations group by key column.
Hello.
You could add Summary on the Group Header or Group Footer and set the Height of the Data Band to zero.
Thank you.
You could add Summary on the Group Header or Group Footer and set the Height of the Data Band to zero.
Thank you.
Re: Set of Summations group by key column.
Thank you HighAley it works perfectly
Re: Set of Summations group by key column.
Hello.
We are always glad to help you.
Let us know if you need our help.
Thank you.
We are always glad to help you.
Let us know if you need our help.
Thank you.
- Fabio Pagano
- Posts: 355
- Joined: Mon Apr 16, 2007 12:38 pm
- Location: Bari (Italy)
Re: Set of Summations group by key column.
Hi,
I need help about similar problem.
I'd like to view total of all rows whose column has the same value
I attached a picture of my DATASET, report structure (cattura2) and the result I expect (Opzione_totale).
I used the followind code into field I'd like conditional subtotal:
{SumIf(DataBand2,
DescrizioneLavoroSintetica.Lavoro__Prezzo,
DescrizioneLavoroDettagliata.Lavoro__Note_pubbliche_immagine=="OPZIONE1")}
but not work
any idea about?
thanks in advance.
I need help about similar problem.
I'd like to view total of all rows whose column has the same value
I attached a picture of my DATASET, report structure (cattura2) and the result I expect (Opzione_totale).
I used the followind code into field I'd like conditional subtotal:
{SumIf(DataBand2,
DescrizioneLavoroSintetica.Lavoro__Prezzo,
DescrizioneLavoroDettagliata.Lavoro__Note_pubbliche_immagine=="OPZIONE1")}
but not work
any idea about?
thanks in advance.
- Attachments
-
- Cattura2.PNG (23.85 KiB) Viewed 2650 times
-
- Opzione_SubTotale
- opzione_totale.PNG (7.69 KiB) Viewed 2650 times
-
- DATASET.PNG (11.89 KiB) Viewed 2650 times
Re: Set of Summations group by key column.
Hi Fabio,
Your report should work as you have done everything correctly. Please see the simple example of the report attached where the simple aggregate function is used. So please check the name of the Databand, was it definitely DataBand2?
Thank you,
Edward
Your report should work as you have done everything correctly. Please see the simple example of the report attached where the simple aggregate function is used. So please check the name of the Databand, was it definitely DataBand2?
Thank you,
Edward