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; } } }

running sum

Shoaib Bagwan

can any one please help me...!
i want to display the sum of the all cells from perticuler column to the footer......
how can i do this ...

Thanks in Advance...

shoaib

Find more posts tagged with

Comments

mwilliams

On each page, you want the accumulation, SO FAR? Or you just want the total at the bottom of the report? Let me know. Also, let me know your BIRT version.

Shoaib Bagwan

m using birt-runtime-3_7_1
and i jst want the addition of each cell of the column at the bottom....

mwilliams

To get the sum of a column in the footer, you simply need to drag an aggregation element from the palette into the footer, choose SUM as the aggregation function, and choose the column you want to add as the expression. This should show your total for the specified column. Hope this helps.

Shoaib Bagwan

ya i tried this procedure but its not working in my problem.....
"select Count(*) as count from table where a = ? and b = ? and c= ?" this is my query which returns count (ex - 23)
i am taking this count on report but as u told for running sum i have to select column name for running sum....!
in that case i dont find the this column name in the expression drop down....
what should i do now...?

Shoaib Bagwan

<blockquote class='ipsBlockquote' data-author="'swabzz'" data-cid="97462" data-time="1331271490" data-date="08 March 2012 - 10:38 PM">
ya i tried this procedure but its not working in my problem..... 
"select Count(*) as count from table where a = ? and b = ? and c= ?" this is my query which returns count (ex - 23) 
i am taking this count on report but as u told for running sum i have to select column name for running sum....! 
in that case i dont find the this column name in the expression drop down.... 
what should i do now...? </blockquote>
 
m waiting for your rply.....

Hans_vd

Hi Shoaib,

There is a devshare post that describes what you need: http://www.birt-exchange.org/org/devshare/designing-birt-reports/1247-page-totals-using-page-variables/

Regards
Hans

Shoaib Bagwan

Thanks HANS now i can calculate the colum total but now the problem is that ..
resultent count is displaying in the header of the table and i want to display total count in the table footer