Dataset: SalesEmployees.rsd
Dataset properties
| Property | Value |
| Path | C:\Users\Alen\Desktop\SSRS items\AdventureWorks 2012 SSRS Samples - Copy\SalesEmployees.rsd |
| Data source | AdventureWorks |
Parameters
| Name | Data type | Nullable | Omit from query | Read only |
| fdsf | String | True | True | True |
Fields
| Name | Field source column | Data type |
| BusinessEntityID | BusinessEntityID | System.Int32 |
| Employee | Employee | System.String |
| JobTitle | JobTitle | System.String |
Query
SELECT s.[BusinessEntityID], p.[FirstName] + N' ' + p.LastName AS Employee, e.[JobTitle] FROM [Sales].[SalesPerson] s INNER JOIN [HumanResources].[Employee] e ON e.[BusinessEntityID] = s.[BusinessEntityID] INNER JOIN [Person].[Person] p ON p.[BusinessEntityID] = s.[BusinessEntityID] |
See also