Creating the client/server table

You created your second graph. You have two graphs representing round-trip time: one for clients and another for servers. Now create a table blending both client and server round-trip times. Starting in the Layout tab of the Report Setup window:

1.	Click Add Item; select Table; and click OK. The Table Column Setup window appears.

2.	Type Top 10 Client/Server TCP RTT (ms) in the Table Title box.

3.	In the Data Source Selection area, configure your data source to match the following parameters:

Trending Source: Application Performance Analysis

Sub-Source: Server/Client Application Performance Statistics

Report Type: Applications with Associated Server Connections

4.	In the Available Columns area:

a.	Under General Statistics, select these columns:

Response Time Client Average (ms)

Response Time Server Average (ms)

b.	Under Client Statistics, select “Bytes Client.”

c.	Under Server Statistics, select “Bytes Server.”

d.	Under General Statistics, select “Bytes Total.”

5.	Click OK to confirm your changes. You return to the Report Setup window.

6.	Ensure the Top 10 Client/Server TCP RTT (ms) table is still selected, and click the Down Arrow button once to move the table below the graphs. Your report now appears similar to Figure 4.

Figure 9. Client/Server Table is Complete

7.

You successfully created a table showing the top ten client/server round-trip times. Now perform a sub-report association to give the table a clickable “drill down” effect. Sub-report association is the process of creating context-sensitive links between two or more reports. Starting in the Layout tab of the Report Setup window:

8.	Ensure the Top 10 Client/Server TCP RTT (ms) table is selected.

9.	In the Report Drill Down area, click Select near the ORS drill down report box. The Select Drill Down Reports window appears.

10.	Choose Application Performance Analysis from the “Only show reports which use trending source” list. Doing so narrows your choices to a manageable number.

11.	From the list, double-click Server-Client Application Performance. The report is now added as a sub-report, but it must be modified (in the following steps) to work correctly.

12.	In the Selected Reports for Drill Down area, click your newly created “Server-Client Application Performance” sub-report. The new sub-report must be selected for the next step to work.

13.	In the Drill Down Elements area, click and drag the “Application Name” drill down element to its matching source element in the Source Elements area and release. Repeat this for “Either IP Address.” See an example of this operation in Figure 5.

Figure 5 is for visual reference only; it does not reflect your progression in the tutorial.

Figure 10. Example of Sub-Report Association

14.	Click OK to confirm your changes. You return to the Report Setup window.

You can perform the same sub-report association on the graphs created earlier. Doing so allows your report’s viewers to click the bars in the graph(s) and be brought to a context-sensitive sub-report.