Customize Consent Preferences

We use cookies to help you navigate efficiently and perform certain functions. You will find detailed information about all cookies under each consent category below.

The cookies that are categorized as "Necessary" are stored on your browser as they are essential for enabling the basic functionalities of the site. ... 

Always Active

Necessary cookies are required to enable the basic features of this site, such as providing secure log-in or adjusting your consent preferences. These cookies do not store any personally identifiable data.

No cookies to display.

Functional cookies help perform certain functionalities like sharing the content of the website on social media platforms, collecting feedback, and other third-party features.

No cookies to display.

Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics such as the number of visitors, bounce rate, traffic source, etc.

No cookies to display.

Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.

No cookies to display.

Advertisement cookies are used to provide visitors with customized advertisements based on the pages you visited previously and to analyze the effectiveness of the ad campaigns.

No cookies to display.

Steps to create Drill through report in Cognos

Mar 5, 2021

Share this post
issues-after-qlikview-version-upgrade-on-passive-node-of-production-servers

Drill through Report: Navigating from the summary report to the detail report from one report to another report or with in the same report is called Drill through the report.

Steps to create Drill through Report:

Create a report (Child or detailed) and save the report.

    • Select a package and go to the launch button and click on report studio.

Choose a blank report.

Click on the list from the toolbox as shown in the below screenshot.

    • Drag the data items to the page area we need to build a report.
    • Go to the query explorer and set a filter to the main query and create a parameter.
    • Go to the main report (Parent or Summary).
      • Select a package and go to the launch button and click on report studio.

Choose a blank report.

Click on the list from the toolbox as shown in the below screenshot.

Drag the data items to the page area we need to build a report as shown in the below report.

Here to the main report click on one of the data item which is parameterized in the child report, right-click on it and select Drill Through Definitions.

Here we need to add a new drill-through definition and will get a window that appears such that, we need to add the child report, we need to choose the action of the report and click on the edit of the parameters and add those parameters here and click ok.

Now when we run this report and click on this field (Drill through is defined) it will redirect to the Child or Detailed report from this Parent or Summary report with the detailed data which it will filter on this detailed report.