Solved

crystal group subtotal

Posted on 2010-11-10
19
346 Views
Last Modified: 2012-05-10
I have a report with dates what I am trying to do is get it display correctly but when I use the date group it does not add correctly.

date        amount         result
10/11         50                 50
10/12          20                70
10/15          10
10/15           9
10/15            5
10/15           40                134  
10/19          10                 144

0
Comment
Question by:sevensnake77
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
19 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 34107625
What should the result be?

How are the sums being done?

What is the group?
Are you grouping by day?

mlmcc
0
 
LVL 9

Author Comment

by:sevensnake77
ID: 34108596
above is what the result should be.
this is one user and by there userid displays the amount according to the day and month
 
I am grouping by day but when I add the amount it only sums the last month shown for example
 
date        amount         result
10/11         50                 50
10/12          20                70
                     
                     
                      40                180  
10/19          10                  190
 
so the result for example suppose to be 220 it comes out 190  
 
If I can get the same result to add each amount line but do not show the group like the example
 Do not want below**
date        amount         result
10/11         50                 50
10/12          20                70
10/15          10                 90
10/15           9                    99
10/15            5                    104
10/15           40                134  
10/19          10                 144
Do want below

date        amount         result
10/11         50                 50
10/12          
10/15           40                134  
10/19          10                 144
 

 
 
 
 
 
0
 
LVL 8

Expert Comment

by:kingjely
ID: 34109054
The examples and example text does not make any sence at all.
0
How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

 
LVL 9

Author Comment

by:sevensnake77
ID: 34111890
Here let me explain it since it doesn't make since.

The amount will total in the results but they will be grouped together using the date. So if its the same date it will only show once. why giving the correct total result on each line.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 34113300
If you put the totals in the group footer, they will appear only once per group.  

If you want the details to show for the group then put the field in the detail section.

mlmcc
0
 
LVL 9

Author Comment

by:sevensnake77
ID: 34113488
I did add it in the group and vice versa, but this does not give me a sub total of the amount in Details and it does not separate it when i group it together in the group section. If i add it in the group section then it only gives me the last line subtotal of that group. If I add it to details then it shows everything and does not  separate it like it does in group.

Let me know if you follow.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 34113617
How are you totaling?

mlmcc
0
 
LVL 9

Author Comment

by:sevensnake77
ID: 34113903
let me ask you this can i call a group name and define it in the details row, if so example how.
0
 
LVL 9

Author Comment

by:sevensnake77
ID: 34113912

>>How are you totaling?
NumberVar y;
WhilePrintingRecords;
y:=y+{Review.ChargeAmount};
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 34114203
Put the total formula in the detail section

Right click it
Click FORMAT OBJECT
Click the COMMON TAB
Click the formula button to the right of suppress
Enter the following
Not OnLastRecord  or Next({GroupField}) = {GroupField}

mlmcc
0
 
LVL 9

Author Comment

by:sevensnake77
ID: 34115440
Not OnLastRecord  or Next({GroupField}) = {GroupField}

ok sorry not to familar with crystal syntax groupfield would be
0
 
LVL 9

Author Comment

by:sevensnake77
ID: 34115546
Ok i got it thanks
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 34115619
GroupField is the field you re grouping on.  In this case the date field

mlmcc
0
 
LVL 9

Author Comment

by:sevensnake77
ID: 34115932
I uses a run total and add it to group.
0
 
LVL 9

Author Comment

by:sevensnake77
ID: 34115942
I was trying to give points and there was a glitch
0
 
LVL 9

Author Comment

by:sevensnake77
ID: 34115944
t
0
 
LVL 9

Author Comment

by:sevensnake77
ID: 34121141
trying to add points
0
 

Expert Comment

by:Modalot
ID: 34162426
Overruling original poster's inappropriate closing attempt by issuing a better disposition.

Modalot
Community Support Moderator
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Expanding/Collapsing Tree on SharePoint List 29 62
SSIS - Using VB.NET to parse XML file 11 40
Google Chrome: Debugging AJAX call 6 38
Adding Rows to Grid 4 32
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question