nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Sub and Grand Totals

Frisky

Hi all
I'm a relatively inew user of BIRT and so I'm learning every day. However, I seem to have hit a stumbling block in terms of Sub and Grand totals which wasnt in the training. I'm sure this will be an easy answer....

I have a report that produces an amount in two categories for each establishment for each of the areas I deal with.
It would look similar to the below:

Area Details Amount A Amount B
Area 1 Company 1 12 11
Company 2 10 8
Company 3 4 7
 SUB TOTAL N N 

Area 2 Company 4 4 2
Company 5 15 13
 SUB TOTAL N N

Area 3 Company 6 15 17
Company 7 19 13
 SUB TOTAL N N

 GRAND TOTAL N N

How do I add s SUB TOTAL for each Area (these have been done by using Groups in BIRT) then a GRAND TOTAL at the end?
All other data is pulled from a data source, so nothing is calculated in BIRT. I've tried to look at Data Cubes, but cannot put the correct details in! Must be missing something?

Thanks

Find more posts tagged with

Comments

pricher

Hi Frisky, The attached example shows how to use a crosstab and a table to accomplish what you need. In the crosstab, use the Row Area sub total and grand total to display the aggregations. In the table, create aggregations at the group and table level. Hope this helps, P.

Frisky

HiThanks for getting back to me.However I get an error message when using the Cross tab..[color=#FF0000;][font="'times new roman', serif;"]ReportDesign (id = 1): [/color][/font][color=#FF0000;][font="'times new roman', serif;"]+ An exception occurred during processing. Please see the following message for details: 
exception.error 
Error happens when create measure. 
A BIRT exception occurred. See next exception for more information. 
Can not convert the value of to Double type. [/color][/font] Any thoughts?Thanks

GLO_FR

Hi, can you upload your design.Are you triing to convert something like a integer or date or whatever in a double ?

Frisky

HiNo, not trying to convert anything, just adding figures for each area. Attempted to add an Aggragate builder (which is where the errors arise).Have removed the cross tab for now. Any help would be appreciated, thanks

GLO_FR

Can you also upload an xml sample (for the data). Did the "new date()" field works (top right) ?It's better to use a dynamic tex for that

Frisky

Yeah the date works ok... will change it over if it improves the performance though - cheersSample data attatchedThanks

GLO_FR

Are your sure it's the xml used in this report ? I think I found what is wrong.first, if you run the uploaded report, does it works ? If no, delete the data cube and try again.

Frisky

I had to remove a lot of the data and create a new xml (sensitive reasons)I guess its down to not understanding how the cube works with the data I have and of course no-one can show me. So I'm a little stuck, really

GLO_FR

In your cube, you're triing to create "sum" measure with string.In your report, you're doing also agregation with string (sum(local place) or avg(local_place)) You can do a count/min/max with a string field but that all. If you want to have a sum, change local_place to a numeric value and it should works

Frisky

Hi - Sorted; thanks! It hadn't occurred to me to check the the data type in the Data Set - Doh! Every day is a school day!Didnt need a Cross tab or data Cube in the end...

GLO_FR

Cool.