Support Article

Reports - Drilldown on dataset is not working as expected

SA-36428

Summary



User is using sub-report properties in the main reports column source and configured drill-down report and chart.

The report definition is displaying expected results when clicking on chart but displaying no results when clicking on listviewdataset.

The issue is not observed when grouping is removed which is done by checking the "Do not display group headings" checkbox in the report Viewer tab of main report.


Error Messages



Not Applicable


Steps to Reproduce



1.Configure a drill down report with bar chart.
2.Click on dataset and observe the results.
3.Click on the chart and observe the results.


Root Cause



There are two issue's:

1.The columns used in the sub-report should be exposed.

2.Theddaggpath attribute is not being set on the aggregated columns. This is done in RRDataSummarySpreadsheetGeneratio.

Resolution



Perform the following local-change steps:

1.The sub-report columns used in the main report should be exposed.
2.ApplyHFix-32971.

Published April 12, 2017 - Updated May 2, 2017

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.