Cognos 8 Report Studio -- Drill Through Report

How to create a Drill Through report

 

Sample Scenario:  You have been asked to create a Drill Through report sample using the Great Outdoors model.  You decide to show this behaviour creating a report that lists product sales by order method for each product line, and allows users to drill through from the sales report to view the product details for any item selected. You need to create two reports: one that contains the details for the item; and another that lists the product sales for the order methods selected by users.

 

1. Open Report Studio and select the GO Sales and Retailers package.
2. Create a new List report.
3. Add the following query items from the Orders and Products query subjects to the report page.
1. • Order method
2. • Product line
3. • Product type
4. • Product name
5. • Description
6. • Introduction date
7. • Product image
4. Group the Order method, Product line, and Product type columns.
5. Click the filters button and add the following filters:
1. [Product name]=?p_ProductName?
2. [Order method] in ?p_OrderMethod?
6. Change the title of the report to Product Details.
7. Save the report as Product Details.
8. From the File menu, click New to create a new List report.
9. Add the following query items from the Orders and Products query subjects.
1. • Order method
2. • Product line
3. • Product type
4. • Product name
5. • Quantity
6. • Revenue
10. Group the Order method, Product line, and Product type columns.
11. Add the following filter to the report:
1. [Order method] in ?p_OrderMethod?
12. Right-click the Product Name column and click Drill Throughs.
13. Click the new drill through button.
14. Under Report, click the ellipsis points (...) and select the Product Details report you created previously.
15. Click Action and click Run the report.
16. Click Format and click HTML.
17. Click the edit button.
18. For the item p_OrderMethod, under Method, select Pass parameter value, and select p_OrderMethod for the Value.
19. For the item p_ProductName, under Method, select Pass data item value, and select Product name for the Value.
20. Click OK twice.
21. Change the title of the report to Product Revenue by Order Method.
22. Save the report as Product Revenue by Order Method.
23. Click the run report button.  When the report is run, you are prompted to select one or more order methods. When you click OK, the list will show the product names as clickable links. When a product is clicked, the second report will run, showing the order methods and product selected in the first report.