What Are Drill-Down Links?

Drill-down links (also called drill-through links) allow users to click on a value in one report to open another report with that value as a filter. They create an interactive reporting experience where users can explore data at different levels of detail.

For example, imagine a summary report showing sales by product category. A user sees “Electronics: $2.5M” and wants to understand which products in the Electronics category drove that revenue. They click the Electronics value, and a drill-down link opens a detailed report showing all Electronics products and their individual sales. This is drill-down reporting.

Drill-down links are powerful because they reduce the number of reports users need to request. Instead of “Can you send me the summary AND the detail for each summary line?,” users can request the summary report and drill down to detail themselves.

Planning Your Drill-Down Structure

Before building drill-down links, plan your report hierarchy. Think about how your users will explore data and what questions they’ll ask.

Example hierarchy for a sales analysis:

Level 1: Summary by Region (North, South, East, West, total revenue by region). Level 2: Detail by Customer within a Region (when user clicks a region). Level 3: Detail by Order within a Customer (when user clicks a customer).

This three-level hierarchy lets users navigate from broad regional view down to individual customer orders. Each level provides more detail than the previous level.

Plan your reports first. Build the summary report and each detail report independently, making sure they work correctly. Only then add the drill-down links that connect them together.

Creating a Drill-Down Link

To add a drill-down link, open your summary report in the designer. Identify which field users should click to drill down. In a sales summary, you might make the region name or region revenue clickable.

Right-click on the field and select “Create Link” or “Add Drill-Down.” A dialog appears asking you to configure the link:

Target Report: Which report should open when users click this field? Select the detail report you want to drill into (e.g., “Sales by Customer Detail”).

Link Field: Which field in the summary report contains the value users clicked? (e.g., “Region” field).

Target Field: Which field in the target report should be filtered with the link field value? If the target report has a Region parameter, you’d select that parameter here. AstraReports will automatically pass the clicked Region value to that parameter, filtering the detail report.

Display Text: What text appears as the clickable link? Often this is the same as the link field, but you can customize it. For instance, you might display “See Details” instead of the actual region name.

After configuring these settings, test the link in preview mode. Click the linked field and verify that the detail report opens with the correct filter applied.

Passing Parameters Through Drill-Down Links

Drill-down links work by passing parameter values from the source report to the target report. This requires that both reports have compatible parameters.

If your summary report shows sales by product category, and users can filter the summary by date range, you probably want the date range filter to apply to the detail report too. Otherwise, users click “Electronics” in the January summary, but the detail report shows all Electronics sales regardless of date, which is confusing.

To handle this, configure the drill-down link to pass multiple parameters: the clicked field (product category) AND the date range parameters from the summary report. Both get passed to the detail report, providing consistent filtering across the hierarchy.

Multi-Level Drill-Down

You can create drill-down chains multiple levels deep. Your summary report drills to a detail report, and that detail report has drill-down links to an even more detailed report.

For example: Summary report (Sales by Region) drills to Detail report (Sales by Customer within selected Region), which drills to another Detail report (Orders for selected Customer). Users can progressively drill deeper as their investigation requires.

With multi-level drill-downs, make sure parameter passing is consistent. If a user drills from Region to Customer with a date filter, and then from Customer to Orders, the Orders report should receive both the Region, Customer, and date parameters, ensuring all three levels remain synchronized with the original filter.

Performance Considerations

Drill-down reports can be resource-intensive if not designed carefully. Each drill-down opens a new report, which requires a new database query. If your detail reports aren’t optimized, opening them can be slow.

Design your detail reports with performance in mind. Use appropriate filters to limit the data returned. If a user drills down to a detail report for a specific region, the detail report query should only fetch data for that region, not all regions.

Also consider whether drill-down is the best solution for all scenarios. If users frequently need to see both summary and detail together, maybe a single report with both levels is better than a drill-down structure. Test with your users to understand their workflow and preferences.

User Experience Tips

Make it obvious which fields are clickable drill-down links. Use standard visual cues: underline the text, display it in blue, or display a cursor change when users hover over the field. Include a help note in the report explaining that users can click on specific values to drill down.

On the detail report, include a “Back to Summary” link that returns users to the summary report with their original filters intact. This makes navigation intuitive.

Consider opening drill-down reports in a new browser window or tab rather than replacing the current report. This lets users compare summary and detail side-by-side if they want to.

Troubleshooting Drill-Down Links

If a drill-down link isn’t working, verify that the target report accepts a parameter with the name and data type you’re passing. A drill-down that passes a text Region value to a numeric CostCenter parameter will fail.

Check that the linked field contains actual values, not null or blank. Some reports might filter out certain data, so the drill-down field might not always have a value. Test with data that actually has values in the drill-down field.

Verify that users running the drill-down report have permission to access the target report. If the target report is restricted to certain users, users without access won’t be able to drill down.