Note: To set the Visible properties for cells

Note: To set the Visible properties for cells in the data region, you can alternatively use the Textbox Properties dialog box, shown in Figure 15-3. To do this, right-click on the cell (such as the SubCategory header SalesAmount cell). This will show the Textbox Properties dialog box (like that shown in Figure 5-3, for example). Click the Visibility tab to select Hidden or Visible and a ToggleItem if appropriate. This is equivalent to setting these Visible property components in the Properties window. You cannot set the Visibility properties for the entire Detail and SubCategory rows in this manner you must use the Properties window. The Row/Column settings also supersede the individual cell properties within the Row/Column. Drilling down a recursive hierarchy Consider the example of drilling down on a report of managers and showing all the employees reporting to the manager. This is a little different from the previous example, because this employee hierarchy is usually a parent-child relationship in the database. This means that for every employee record in the database, there is an attribute that identifies the manager for that employee. Other types of parent-child relationships that you usually see in databases include departments and business units, cost centers and departments, and territories to regions. How do you tackle this? Follow these steps: 1. Prepare a query from the DimEmployee table. The Data window for the query is shown in Figure 15-4. You just need the fields EmployeeKey, ParentEmployeeKey, FirstName, LastName, and Title. Figure 15-3: Advanced Textbox Properties dialog box for the Sub- Category header cell Sales- Amount. Chapter 15: More About Interactive Reporting 277

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.