When a Web part is configured to get results from a report, the Web part runs the report and interprets the data through a control called WebPartReportView.aspx. This control takes a report GUID as an argument and returns the results of the report as an HTML table to be displayed in the Web part.
Most reports in the Altiris database return data as text and values. When these reports are interpreted through the WebPartReportView.aspx control, the resulting HTML table contains the text and values from the report. This allows you to view data in a Web part, but it does not make the Web part interactive.
A more interesting Web part would give you the ability to create a drill-down report much like you can already do within the Altiris Console. This is possible within a Web part. It simply takes some manipulation of the data in the underlying report. Remember, the WebPartReportView.aspx control renders the results as HTML. Therefore, it is possible to embed HTML in the report results. This HTML can be a link to another report in the Altiris database (or any other link available through HTTP).
The following examples show you how to create a report and a Web part that supports the HTML drill down (with parameter passing). This example will show you how to look at the latest packages available in the Altiris database.
A sample XML report has been attached to this article for reference and import. There are a few items to note in the SQL of step 2c:
Configure a Web part to use the report in Step 2 once both reports have been created. When the preview is shown in the Web part page, you should see a clickable link. Clicking on this link should bring up the drill-down report in a new window with the correct parameter passed.
It is important to be able to find the GUID for any report or item that was created. There are a few ways to get the GUID of an item. Here are two easy ways to accomplish this:
Similar methodologies can be used to link Web parts to the Resource Manager, as an example. Simply replace the HREF statement with the link to the Resource Manager instead of the report_summary page in the HREF: