Note: To set the Visible properties for cells

2. Create a simple report layout of employee information. Define a report with the column headings of Employee Name, Title, Level, and Employee Count. You can drag the Title field from the query into the Title field. You need to define a new calculated field called Employee (or the Employee Name column), which is set to the expression: =Fields!FirstName.Value + + Fields!LastName.Value. 3. Edit the Details Group by clicking inside the table and then clicking the Detail row icon to select the row. Then set the grouping properties as follows: a. With the details row selected, bring up the Properties window and click on the Grouping property. b. In the Details Grouping dialog box that appears, enter RecursiveGroup as the name. c. In the Group On section of the General tab, select the =Fields! EmployeeKey.value from the Expression drop-down list. This will group the detail data by employee key. d. In the Parent Group drop-down list, select the =Fields!Parent EmployeeKey value. This enables you to leverage the parentchild relationships in the data. 4. Display the level number of each employee. Figure 15-4: Query specifications for the Employee Roster report. 278 Part V: Developing Advanced Reports

Note: If you are looking for good and high quality web space to host and run your application check Lunarwebhost JSP Web Hosting services

Bookmark the permalink.

Comments are closed.