Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Sub-totaling Post Reply Post New Topic
Author Message
HolyCow
Newbie
Newbie
Avatar

Joined: 18 Sep 2008
Location: United States
Online Status: Offline
Posts: 15
Quote HolyCow Replybullet Topic: Sub-totaling
    Posted: 20 Oct 2008 at 7:06am
Is it possible, either with passing values back from a sub-report, or just working in the main report to total the sub-totals.  I have had to sub-total some numbers (not with the SUM command, but rather with adding them up to a field in my Formula Field.  The problem is I am unable to get grand totals from them.  I am trying to add my employees hours, problem is, the the values are calculated, not sub-totaled.  How does one sub-total, or total a calculated field?  PLEASE help.....
IP IP Logged
mikebird
Groupie
Groupie
Avatar

Joined: 04 Mar 2008
Location: United Kingdom
Online Status: Offline
Posts: 70
Quote mikebird Replybullet Posted: 20 Oct 2008 at 7:49am
Use Running Totals, customised, just the way you want them
Life = luck (+/-) and effort (+/-). If you have no luck & make no effort, then you are dead
IP IP Logged
keval300
Newbie
Newbie
Avatar

Joined: 18 Jul 2008
Location: India
Online Status: Offline
Posts: 24
Quote keval300 Replybullet Posted: 21 Oct 2008 at 9:01am
HI,
 
It seems you are finding problem to get the value in sub report to the main report.
 
you can use "Shared" to do so in your formula.
 
for eg:
 
I will use a formula "MyValue"
 
The formula content will be as follows
 
1. In Main Report
Shared Numbervar MyValue;
MyValue:=10;
 
2.In Sub Report
Shared Numbervar MyValue;
MyValue:=MyValue+10;
 
(Note : I have created the formula both in main report and subReport.)
 
Now How does this Actually works?
 
Let me Place the Formula which I had created, In different Sections.
 
1.For Main Report.
  a.Page Header Section.
  b.Page Footer Section.
 
1.For Sub Report.
  a.Page Header Section.
 
 
Now its the Time for Output.
 
10 - Page Header Section,Main Report.
20 - Page Footer Section,Sub Report.
30 - Page Header Section,Main Report.
 
 
Hope you have understood the basic by this example.
Using "Shared" in formula can handle still more complicate things easily.
This was just a Simple example.You willl be able to uderstand about using "Shared" ,by placing the formula created in different sections of subReports and Main Reports.
 
 
For more clearification in Crystal Reports you can contact me any time.
 
Warm Regards
   Keval Raj
Enjoy...
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.