Forum Discussion
ArchiveUser
9 years agoQrew Captain
It is now possible to set a report to "drill down" into when clicking on a chart, summary report or summary field! For a report, you can find this option towards the bottom of the report settings, and for a summary field, you can find this option on the properties of the summary field.
- ArchiveUser9 years agoQrew CaptainHow, exactly, does one get this to work? I have a summary report (with grouped columns, if that makes any difference) and have defined a report to drill down into. When clicking on a value to drill down into, I get no results displayed. When I go immediately into the drill down report's filters, I see that the original filters are duplicated and a new set if filters has been added.
Is there some trick to creating the drill down reports? - MCFNeil9 years agoQrew CaptainThe 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 a "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.
Let me know if you get stuck. - ArchiveUser9 years agoQrew CaptainThanks, Matthew. I saw the feature on the release notes but never found any detailed instructions.
What you posted works perfectly for my summary reports that don't require user's to select criteria before hand (such as a date range or category or whatever). Thanks you again for your help.
I'm still running into the issue I mentioned above, though, with any summary report that has user inputted criteria. Would you have any insight on that? - MCFNeil9 years agoQrew CaptainI did a quick test on one of my summary reports that has some grouping, and the drill-down worked as it should have.
I even applied a "Ask the user" filter for the master summary.
I'm note sure what might be causing the data discrepancy.
Maybe, if its ok, take some screen shots and show/explain whats happening. - BobbyWindmeyer9 years agoQrew MemberThis works for a Summary Report, but what about a Table Report that has "Show summary table based on the grouped columns" and "Hide main table and show only summary table" checked? It doesn't look like it's possible to specify a drilldown report in this case.
I would at least expect the drilldown in this case to show a details report with the same columns as the original Table Report...
Thanks,
Bobby