Hi all, I'm new to report builder and would like to know how I can UNION data together. For example, I have one dataset that populates a table, but I would like other information to be combined to this dataset. How do I create a union between the two?

Hi vba123, Union funtion in Report builder 3.0: Returns the union of all the non-null spatial data values of type SqlGeometry or SqlGeography that are specified by the expression. If your data type is SqlGeometry or SqlGeography, please refer to the Union Function (Report Builder 3.0 and SSRS):http://technet.microsoft.com/en-us/library/ee240850.aspx If your data type is neither SqlGeometry or SqlGeography, I suggest you can use Union in your dataset like following: Select * from [table1] union Select * from [table2] For more information about Union in T-SQL, please refer to the following articel, UNION (Transact-SQL): http://msdn.microsoft.com/en-us/library/ms180026.aspx if you have question, please feel free to ask. Thanks, Eileen