Dataset: SalesEmployees.rsd
Property | Value |
Path | C:\Users\Alen\Desktop\SSRS items\AdventureWorks 2012 SSRS Samples - Copy\SalesEmployees.rsd |
Data source | AdventureWorks |
Name | Data type | Nullable | Omit from query | Read only |
fdsf | String | True | True | True |
Name | Field source column | Data type |
BusinessEntityID | BusinessEntityID | System.Int32 |
Employee | Employee | System.String |
JobTitle | JobTitle | System.String |
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] |