Please start any new threads on our new 
    site at https://forums.sqlteam.com.  We've got lots of great SQL Server
    experts to answer whatever question you can come up with.
    
        
            
                
                    
                        
                            
                                | Author | 
                                
                                 Topic  | 
                             
                            
                                    | 
                                         vaishanavi 
                                        Starting Member 
                                         
                                        
                                        9 Posts  | 
                                        
                                        
                                            
                                            
                                             Posted - 2009-03-19 : 06:36:23
                                            
  | 
                                             
                                            
                                            | When we are having two datasetsfor example in dataset we are having columns like id,description if the column is numeric field is giving sum(fieldname)if the column is description it is giving First(fieldname)so what I have to do if i want original database columns directly | 
                                             
                                         
                                     | 
                             
       
                            
                       
                          
                            
                                    | 
                                     visakh16 
                                    Very Important crosS Applying yaK Herder 
                                     
                                    
                                    52326 Posts  | 
                                    
                                      
                                        
                                          
                                           
                                            Posted - 2009-03-19 : 14:22:29
                                          
  | 
                                         
                                        
                                          | you need to link container (table/matrix) to any of dataset and use fileds in it. you cant have multiple dataset fields inside same container unless you apply sum(),max(),first(),... over them  | 
                                         
                                        
                                            | 
                                         
                                       
                                     | 
                                   
                            
                       
                          
                            
                                    | 
                                     vaishanavi 
                                    Starting Member 
                                     
                                    
                                    9 Posts  | 
                                    
                                      
                                        
                                          
                                           
                                            Posted - 2009-03-21 : 03:26:33
                                          
  | 
                                         
                                        
                                          | even though we are not getting if we taken two different tablesit is giving same sum(id) and first (field_name_  | 
                                         
                                        
                                            | 
                                         
                                       
                                     | 
                                   
                            
                            
                                | 
                                    
                                      
                                     
                                    
                                 | 
                             
                         
                     | 
                 
             
         |