You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. The report uses a dataset that is constructed from an SQL table named Employees. The table has an employeeID field and a managerID field. The managerID field in each row represents the employeeID field.
You execute the following Transact-SQL query to get the dataset from the report:
SELECT CONVERT(varchar(255), c.FirstName + ‘ ‘ + c.LastName) as Name, e.EmployeeID, e.ManagerID FROM HumanResources.Employee AS e JOIN Person.Contact AS c ON e.ContactID = c.ContactID You need to display the dataset as a hierarchical, organizational chart, as shown in the Exhibit. (Click the Exhibit button.)
What should you do?
A.
Use the Level function in the Left property of the Padding property of the cell.
B.
Group the report by the employeeID field and set the managerID field as the group parent.
C.
Group the report by the managerID field and set the employeeID field as the group parent. Use the Level function in the Left property of the Padding property of the cell.
D.
Group the report by the employeeID field and set the managerID field as the group parent. Use the Level function in the Left property of the Padding property of the cell.