My Total Follow Up

Dave M followed up with a question on the regrouping totals post from a day or two ago.


Would it be possible to reference the group sum values from outside of the loop? For instance, if you wanted to have a separate table at the bottom of the report that contained the department totals for each department.


Of course the answer is 'Yes', but of course there are several ways you could tackle it. You could use our updatable variables to track totals against each department as you move through the XML tree. Not ideal and probably expensive.


You could loop through everything again in the summary section.


<?for-each-group:ROW;DNAME?> 
<?DNAME?> <?sum(current-group()/SAL)?>
<?end for-each-group?>


Its another pass thru the data which could be expensive on a very large report. The fastest way to get the summary is going to be to have the summarization at the extract layer. Another alternative might be to build a dynamic XML tree and then use that to render the values. I think this would be just as expensive as the solution above thou - I might be wrong thou.


 


 

Comments:

Thanks Tim. Your blog is very helpful to the BIP community!

Posted by Dave M on November 02, 2007 at 03:50 AM MDT #

Hi Tim, I'm triing to summarize with group by method it's working fine. But with some case I've got some format number issue. for example : Remuneration Costs -66.55 Remuneration Costs -39.93 -- My Rtf : -- Result : -106.47999999999999 I expected -106,48 Is there have any other ways to summarize? Many thanks

Posted by Thierry on February 21, 2010 at 07:38 PM MST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Follow bipublisher on Twitter Find Us on Facebook BI Publisher Youtube ChannelDiscussion Forum

Join our BI Publisher community to get the most and keep updated with the latest news, How-to, Solutions! Share your feedback and let us hear your voice @bipublisher on Twitter, on our official Facebook page, and Youtube!

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today