Forum Discussion

DineshDinesh's avatar
DineshDinesh
Qrew Cadet
9 years ago

Summary Report Drilldown Issue

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:

  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    9 years ago
    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's avatar
    DineshDinesh
    Qrew Cadet
    9 years ago
    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
    • MCFNeil's avatar
      MCFNeil
      Qrew Captain
      9 years ago
      That is very odd.  I haven't seen this before.  I wish I could help but in all honesty it looks like a bug.  Maybe a support case is going to be your best route.

      it could have something to do with the types of filters coming from your initial summary report.  

      Just to experiment, try making the same report from scratch again and see if it gives you the same errors.

      Also, try simplifying a few of the variables and see if it give you any insight as to what may be causing it.
    • DineshDinesh's avatar
      DineshDinesh
      Qrew Cadet
      9 years ago
      Yes, I too feel that there is a bug in the summary report with many initial filters set. The same drill down report works just fine with another summary report.

      This could be because of the unnecessary repetition of filters applied in drill down report when it's opened from summary report.

      I'll raise a support ticket. 

      Anyway, thanks for trying to help.

      Thanks.,
      Dinesh
    • DineshDinesh's avatar
      DineshDinesh
      Qrew Cadet
      9 years ago
      I've raised a QuickBase support ticket. Waiting for their response....