Dataset: SalesEmployees.rsd

CollapseAll image

Collapse image Dataset properties


 Property   Value 
 Path   C:\Users\Alen\Desktop\SSRS items\AdventureWorks 2012 SSRS Samples - Copy\SalesEmployees.rsd 
 Data source   AdventureWorks 

Collapse image Parameters


Name  Data type  Nullable  Omit from query  Read only 
fdsf String True True True
Total: 1 parameter(s)

Collapse image Fields


Name  Field source column  Data type 
BusinessEntityID BusinessEntityID System.Int32
Employee Employee System.String
JobTitle JobTitle System.String
Total: 3 field(s)

Collapse image 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]

Collapse image See also


About this documentation