Report Design
 Crystal Reports Forum : Crystal Reports .NET 2003 : Report Design
Message Icon Topic: Summing rows in Hierarchy Post Reply Post New Topic
Author Message
Daan
Newbie
Newbie
Avatar

Joined: 26 Sep 2011
Online Status: Offline
Posts: 1
Quote Daan Replybullet Topic: Summing rows in Hierarchy
    Posted: 26 Sep 2011 at 9:03am
Hi Guys,
I am trying to design a report where I need to show the following Hierarchy:
D.0307.01.01 TL
   D.0307.01.01.01 text1
     D.0307.01.01.01.01 M
     D.0307.01.01.01.02 L
   D.0307.01.01.02 text2
     D.0307.01.01.02.01 M
     D.0307.01.01.02.02 L
   D.0307.01.01.03 text3
     D.0307.01.01.03.01 M
     D.0307.01.01.03.02 L
D.0307.01.02 SL
   D.0307.01.01.01 text1
     D.0307.01.01.01.01 M
     D.0307.01.01.01.02 L
   D.0307.01.01.02 text2
     D.0307.01.01.02.01 M
     D.0307.01.01.02.02 L

In this format:
     Budget Value
TL     
M     $xxxxx
L     $xxxxx
SL     
M     $xxxxx
L     $xxxxx

So basically M and L totals for TL as one group and the same for SL as another group. The Child level of TL and SL can vary but the levels where the M's and L's are will stay the same.
For starters I am able to create a group for TL and suppress SL to show all M's for TL (will do the L's after). So now I have all the M's for TL showing in separate rows, but I need to combine them into one row with totals for M adding up under TL. I am able to identify the individual node names but cannot add up M. One other way I used was by using the running totals on M but then how do I get just the last row for M?
I hope my explanation is clear enough. Your help will be very much appreciated.

regards,
Daan.

Edited by Daan - 26 Sep 2011 at 9:04am
IP IP Logged
rahmaniac22
Newbie
Newbie


Joined: 24 Feb 2010
Location: United States
Online Status: Offline
Posts: 14
Quote rahmaniac22 Replybullet Posted: 05 Dec 2011 at 9:49am
I am not sure about your explanation.
 
Remove the group text 1,
You will get the totals for M and L.
 
 
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 08 Dec 2011 at 3:37am
I am not the Running Total expert, DBlank is, but I do the same thing in code using formulas and shared variables.
 
depending on if/when you need to reset the values, the appropriate group header:
shared numbervar oneVar := 0;
"" //hides the formula
 
to display, in the appropriate footer:
shared numbervar oneVar;
oneVar
 
those are the easy ones, the hardest (which may not be) one is the increment in details:
shared numbervar oneVar;
 
if someCondition then
  oneVar := oneVar + {table.field};  //or some value (usually a field)
 
"" //again hides the output otherwise you will see a running total
 
hope this leads to a solution.
 
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.