Skip to main content
Question

Summary Report Drilldown Issue

  • February 13, 2017
  • 0 replies
  • 90 views
In some summary reports, the dynamic filters do not show any records in the drill down report set even though there are records matching the filters applied. This problem does not occur when I launch the drill down report directly, not from the summary report. 

Have anyone faced this issue? I'm clueless about how this is happening for some summary (not all) summary reports.

Before Applying Filter:



After Applying Filter:

      This topic has been closed for replies.

      • MCFNeil
      • Registered
      • February 13, 2017
      The drilldown report will use the filters from the parent/master report in addition to any existing filters on the selected drilldown report.

      You will want to make your "drilldown" report with the styling and columns you want, BUT make sure there are zero filters applied.

      Then make that report the drilldown, when clicked, from a graph for example, it will apply those new filters from the parent report. 

      Prior to clicking the dynamic filters, try clicking the little "wrench" symbol to see what filters are already being applied.  

      Maybe post some screen shot of those filters and you might be able to see what is causing the data to be missing.
      • DineshDinesh
      • Author
      • Registered
      • February 13, 2017
      Thanks for the response! Initially, I suspected the same. I came to know that it's not good to have initial filters set in the drill down report. But, this report does not have any initial filters set.

      Drill down Report Settings:




      Before applying the filter:

      (I'm not sure why the drill down report has the same filters applied 3 times when it's opened from the summary report.)



      After applying a dynamic filter: 

      (Initial filters are getting removed for some reasons)



      Thanks,
      Dinesh
      Terms & ConditionsAccessibility statement