Drill Down - Pass dates to Child Report


#1

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 .


#2

Please check documentation
https://spicecrm.gitbooks.io/kreporter-4-x/content/integration/plugins/presentation_drilldown.html
What you need to do is proper mapping


#3

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


#4

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


#5

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


#6

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


#7

Is the date from parent selected in manipulate tab?


#8

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 ?


#9

Stephen,
drilldowns do not work in dashlets.
I would some time to analyze for capability.
Val


#10

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/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


#11

Thanks for the detailed screens, I’ll look into the problem.