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  | 
                             
                            
                                    | 
                                         chakrapu 
                                        Starting Member 
                                         
                                        
                                        1 Post  | 
                                        
                                        
                                            
                                            
                                             Posted - 2009-04-30 : 10:44:46
                                            
  | 
                                             
                                            
                                            | HelloI have matrix report with three rowgroups, two static columns and  a details report.Now when click  on subtotals in matrix it sholud go to details report. The problem is when i use InScope() method in parameter expression of jump to report,the parameters passed are incorrect to details report.      The three rowgroups are "Year" under this "PlantID" under this "Month" rowgroup. Now  thees three values corresponding to subtotal are to  be  passed to the detalis report.Please help me out,thanks in advance,chakrapu. | 
                                             
                                         
                                     | 
                             
       
                            
                       
                          
                            
                                    | 
                                     visakh16 
                                    Very Important crosS Applying yaK Herder 
                                     
                                    
                                    52326 Posts  | 
                                    
                                      
                                        
                                          
                                           
                                            Posted - 2009-05-07 : 14:25:05
                                          
  | 
                                         
                                        
                                          | you can write expression in navigation property to send correct field based on value of Inscope() function to distinguish between subtotal and detail.  | 
                                         
                                        
                                            | 
                                         
                                       
                                     | 
                                   
                            
                            
                                | 
                                    
                                      
                                     
                                    
                                 | 
                             
                         
                     | 
                 
             
         |