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 |  
                                    | Blessed1978Yak Posting Veteran
 
 
                                        97 Posts | 
                                            
                                            |  Posted - 2014-08-07 : 15:49:57 
 |  
                                            | I have a query in dataaset 1 that is doing exactly what i want to do, now i want to add an additional row in my report based on a seperate select statement which i will add to dataset 2. when i run the report it only shows  dataset 1  results  but not 2.How can a make my results show both datsets querries in my report |  |  
                                    | tmPosting Yak  Master
 
 
                                    160 Posts | 
                                        
                                          |  Posted - 2014-08-08 : 10:04:23 
 |  
                                          | Assuming you are displaying dataset in a table object.Two options:1. Add a second Table object and display dataset 2 records2. Modify dataset 1 to include records from dataset 2 query and display in the table object |  
                                          |  |  |  
                                |  |  |  |