![]()  | 
 
Grand total for a Column | 
 
    Post Reply  
   | 
  
| Author | |
   
   SHAN  
   
   Groupie  
    
   Joined: 17 July 2010 Location: Dubai Status: Offline Points: 73  | 
  
   
      Post Options
    
        Thanks(0)
      Quote   Reply
   
     Topic: Grand total for a ColumnPosted: 20 July 2010 at 3:34am  | 
 
| 
   
    
   Hi,
 
   
  How to show the Total for a Column. I don't want to Group. I want total for all records ? 
    | 
 |
| 
   
     
     Product: Xtreme SuitePro (ActiveX) version 15.0.2 
 
   
  Platform: Windows 7 Professional Language: Visual Basic 6.0  | 
 |
![]()  | 
 |
   
   Xander75  
   
   Senior Member  
    
   Joined: 26 April 2007 Status: Offline Points: 353  | 
  
   
      Post Options
    
        Thanks(0)
      Quote   Reply
   
     Posted: 09 August 2010 at 9:18am | 
 
| 
   
    Hi, By showing a total for a column I am guessing you mean the following: 
Col 1     
------ 
100 
100 
------ 
200 
If so then this is easy, just loop round all the rows calculating the values for the required column and display in the footer. 
    | 
 |
| 
   
     
     Product: Xtreme SuitePro (ActiveX) v15.3.1  
   
  Platform: Windows 7 64-bit (SP1) Professional Edition Languages: C#.Net using Visual Studio 2012 & Visual Basic 6.0 (SP6)  | 
 |
![]()  | 
 |
   
   Aaron  
   
   Senior Member  
   Joined: 29 January 2008 Status: Offline Points: 2192  | 
  
   
      Post Options
    
        Thanks(0)
      Quote   Reply
   
     Posted: 09 August 2010 at 9:32am | 
 
| 
   
    
   Hi,
 
   
  @Xander75: I guess @SHAN means total as in formulas... 
I made small demo, see post http://forum.codejock.com/forum_posts.asp?TID=17044   
    | 
 |
| 
   
     
     Product: Xtreme SuitePro (ActiveX) version 15.0.2 
 
   
  Platform: Windows XP (32bit) - SP 2 Language: Visual Basic 6.0 Zero replies is not an option....  | 
 |
![]()  | 
 |
    Post Reply  
   | 
  |
|       
  
  Tweet   	
    | 
 
| Forum Jump | Forum Permissions  ![]() 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  |