# Drill Down - Pass dates to Child Report **URL:** \ **Category:** KReporter\ **Created:** [November 13, 2018, 5:21pm UTC](https://community.spicecrm.io/t/drill-down-pass-dates-to-child-report/385 "2018-11-13T17:21:36Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![stephen.roy](https://avatars.discourse-cdn.com/v4/letter/s/c5a1d2/32.png) [@stephen.roy](https://community.spicecrm.io/u/stephen.roy)\ **Post date:** [November 13, 2018, 5:21pm UTC](https://community.spicecrm.io/t/drill-down-pass-dates-to-child-report/385/1 "2018-11-13T17:21:37Z")
is it possible to pass the dates from the parent report to the child report ot filter the results ? i have one date before and a date after and nee to pass these along with the assigned user. the assigned user is fine but im unable to select the date fields form the parent report in the mapping . ---
**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\ **Post date:** [November 14, 2018, 5:51pm UTC](https://community.spicecrm.io/t/drill-down-pass-dates-to-child-report/385/2 "2018-11-14T17:51:10Z")
Please check documentation [https://spicecrm.gitbooks.io/kreporter-4-x/content/integration/plugins/presentation\_drilldown.html](https://spicecrm.gitbooks.io/kreporter-4-x/content/integration/plugins/presentation_drilldown.html) What you need to do is proper mapping ---
**Author:** ![stephen.roy](https://avatars.discourse-cdn.com/v4/letter/s/c5a1d2/32.png) [@stephen.roy](https://community.spicecrm.io/u/stephen.roy)\ **Post date:** [November 15, 2018, 9:31am UTC](https://community.spicecrm.io/t/drill-down-pass-dates-to-child-report/385/3 "2018-11-15T09:31:18Z")
Hi Val, i have read the documentation. but date variables are not in the mapping table. the parent report has before X date and after Y Date. you cant sleect those same variables in the mapping… [https://FIBRECRM.tinytake.com/media/8d08a5?filename=1542274218094\_15-11-2018-09-30-17.png&sub\_type=thumbnail\_preview&type=attachment&width=405&height=566](https://FIBRECRM.tinytake.com/media/8d08a5?filename=1542274218094_15-11-2018-09-30-17.png&sub_type=thumbnail_preview&type=attachment&width=405&height=566) ---
**Author:** ![stephen.roy](https://avatars.discourse-cdn.com/v4/letter/s/c5a1d2/32.png) [@stephen.roy](https://community.spicecrm.io/u/stephen.roy)\ **Post date:** [November 15, 2018, 9:36am UTC](https://community.spicecrm.io/t/drill-down-pass-dates-to-child-report/385/4 "2018-11-15T09:36:48Z")
and the date fields in the parent select are not available to map the the child report. [https://FIBRECRM.tinytake.com/media/8d08f5?filename=1542274596552\_15-11-2018-09-36-35.png&sub\_type=thumbnail\_preview&type=attachment&width=1199&height=464](https://FIBRECRM.tinytake.com/media/8d08f5?filename=1542274596552_15-11-2018-09-36-35.png&sub_type=thumbnail_preview&type=attachment&width=1199&height=464) ---
**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\ **Post date:** [November 15, 2018, 9:56am UTC](https://community.spicecrm.io/t/drill-down-pass-dates-to-child-report/385/5 "2018-11-15T09:56:11Z")
before X should be ok with operator \< after Y with operator \> Did you select corresponding fields in select tab in child report? Set ignore as oprtaor + editable yes ---
**Author:** ![stephen.roy](https://avatars.discourse-cdn.com/v4/letter/s/c5a1d2/32.png) [@stephen.roy](https://community.spicecrm.io/u/stephen.roy)\ **Post date:** [November 15, 2018, 10:17am UTC](https://community.spicecrm.io/t/drill-down-pass-dates-to-child-report/385/6 "2018-11-15T10:17:06Z")
Hi Val, same fields selected in both reports but the date fields are still not selectable. child is set to ignore and editable. but i cannot select the parent date filters from the mappedid [https://FIBRECRM.tinytake.com/media/8d0a4e?filename=1542276911356\_15-11-2018-10-15-10.png&sub\_type=thumbnail\_preview&type=attachment&width=423&height=593](https://FIBRECRM.tinytake.com/media/8d0a4e?filename=1542276911356_15-11-2018-10-15-10.png&sub_type=thumbnail_preview&type=attachment&width=423&height=593) ---
**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\ **Post date:** [November 15, 2018, 10:56am UTC](https://community.spicecrm.io/t/drill-down-pass-dates-to-child-report/385/7 "2018-11-15T10:56:48Z")
Is the date from parent selected in manipulate tab? ---
**Author:** ![stephen.roy](https://avatars.discourse-cdn.com/v4/letter/s/c5a1d2/32.png) [@stephen.roy](https://community.spicecrm.io/u/stephen.roy)\ **Post date:** [November 27, 2018, 1:03pm UTC](https://community.spicecrm.io/t/drill-down-pass-dates-to-child-report/385/8 "2018-11-27T13:03:07Z")
Hi Val we have the drill downs working although with a few minor tweaks. do drill downs work as a dashlet ? is this something that could work ? ---
**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\ **Post date:** [November 27, 2018, 2:52pm UTC](https://community.spicecrm.io/t/drill-down-pass-dates-to-child-report/385/9 "2018-11-27T14:52:57Z")
Stephen, drilldowns do not work in dashlets. I would some time to analyze for capability. Val ---
**Author:** ![stephen.roy](https://avatars.discourse-cdn.com/v4/letter/s/c5a1d2/32.png) [@stephen.roy](https://community.spicecrm.io/u/stephen.roy)\ **Post date:** [December 4, 2018, 11:52am UTC](https://community.spicecrm.io/t/drill-down-pass-dates-to-child-report/385/10 "2018-12-04T11:52:42Z")
Hi Val, we have found another issue with drill downs. if the value you are passing has a space in the display value it is not passed correctly. you have to then select the filter again and then the report loads. [https://FIBRECRM.tinytake.com/media/8f4dd5?filename=1543924262537\_04-12-2018-11-51-01.png&sub\_type=thumbnail\_preview&type=attachment&width=697&height=167](https://FIBRECRM.tinytake.com/media/8f4dd5?filename=1543924262537_04-12-2018-11-51-01.png&sub_type=thumbnail_preview&type=attachment&width=697&height=167) [https://FIBRECRM.tinytake.com/media/8f4dd7?filename=1543924291261\_04-12-2018-11-51-30.png&sub\_type=thumbnail\_preview&type=attachment&width=671&height=690](https://FIBRECRM.tinytake.com/media/8f4dd7?filename=1543924291261_04-12-2018-11-51-30.png&sub_type=thumbnail_preview&type=attachment&width=671&height=690) [https://FIBRECRM.tinytake.com/media/8f4ddb?filename=1543924332769\_04-12-2018-11-52-12.png&sub\_type=thumbnail\_preview&type=attachment&width=699&height=391](https://FIBRECRM.tinytake.com/media/8f4ddb?filename=1543924332769_04-12-2018-11-52-12.png&sub_type=thumbnail_preview&type=attachment&width=699&height=391) ---
**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\ **Post date:** [December 5, 2018, 10:11pm UTC](https://community.spicecrm.io/t/drill-down-pass-dates-to-child-report/385/11 "2018-12-05T22:11:05Z")
Thanks for the detailed screens, I’ll look into the problem.