Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Group footer problem Post Reply Post New Topic
Author Message
legasy
Newbie
Newbie
Avatar

Joined: 19 Apr 2010
Location: Jamaica
Online Status: Offline
Posts: 2
Quote legasy Replybullet Topic: Group footer problem
    Posted: 18 May 2010 at 5:22am
I have a problem. I have a group which is grouping by date along with other sub groups, one of which is currency code. I would like the group footer for date to repeat for every currency code sub group that was presented. Any ideas on how I could accomplish this?
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 19 May 2010 at 4:03am

you can't make the group footer for a 'higher' group display for a lower group, but you can probably code for all the value in higher group to appear in the lower (provided that they are straight aggregate values or values that are known by that time in the report).  What I mean, is by a simple aggregate is COUNT or SUM where all values are included.  If there are any conditional sums occurring, this method won't work.  As this goes to the second part of the statement, values that are known.  CR is basically reading the records, so if you are looking for a value that occurs after the lower group but inside the higher group (date in this case) that you want displayed on the lower group's footer(currency group) and you can't get this value by an aggregate, then you can't code for it in the group footer.

 
You will probably need to change the grouping value on the aggregate to use the 'date' group, as CR will be default assign the 'currency code' group to an aggregate that is to be displayed in the 'currency code' footer.
 
Hope it isn't to confusing.
 
IP IP Logged
legasy
Newbie
Newbie
Avatar

Joined: 19 Apr 2010
Location: Jamaica
Online Status: Offline
Posts: 2
Quote legasy Replybullet Posted: 06 Jun 2010 at 5:57am
Hey there. thanks for the quick reply and sorry for my late one. I think I should rephrase the issue. I have a Parent group called Date and a sub group called Company and another called Currency Code. In the footer for Currency Code, I have it giving me the total per currency for each Company. So if im using USD or Pound or something, it will give me the total for the company along with the currency code being used. The problem lies with giving me the total for the date. I dont want to total all the currency codes because of the different codes being used. I would like to put a total per currency code so if im using USD and pound for 1-3-2007, i would like to have two totals. one for 1-3-2007(USD) and one for 1-3-2007(Pound). Hope this isn't too confusing.
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 07 Jun 2010 at 3:15am
hmm...
 
You might try getting a total in currency code for the date, just like you are doing for company, otherwise, I think a subreport is required.
 
Since your report is something like
gh1 - Date
  gh2 - Company
    gh3 - Currency
 
and you want the totals based on Currency, I think that you need to run all the sums in the Currency Footer, as the other footers will get confused and just add the values, which isn't appropriate.
 
HTH
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.016 seconds.