# Drilldown report passing display value not database value **URL:** \ **Category:** KReporter\ **Created:** [February 5, 2019, 12:20pm UTC](https://community.spicecrm.io/t/drilldown-report-passing-display-value-not-database-value/423 "2019-02-05T12:20:54Z")\ **Posts on this page:** 8\ **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:** [February 5, 2019, 12:20pm UTC](https://community.spicecrm.io/t/drilldown-report-passing-display-value-not-database-value/423/1 "2019-02-05T12:20:54Z")
Hi Val, when we drill down into a child report and pass a value from a dropdown the display value is passed to the child report and not the database value. this means you have to click the filter and select the correct filter. ![image](https://canada1.discourse-cdn.com/flex030/uploads/spicecrm/original/1X/5105c4eab226035e0731cf8de8a00f89d77f6c2d.png) ![image](https://canada1.discourse-cdn.com/flex030/uploads/spicecrm/original/1X/8a4b125315116f05e0811cd777df5fdbd231680a.png) ![image](https://canada1.discourse-cdn.com/flex030/uploads/spicecrm/original/1X/4ef36926eed5a063c4f3988c31c7860db7f6ca4b.png) ---
**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\ **Post date:** [February 6, 2019, 1:55pm UTC](https://community.spicecrm.io/t/drilldown-report-passing-display-value-not-database-value/423/2 "2019-02-06T13:55:06Z")
Thanks for reporting this. In my KReporter 4.4 the database value is passed. But the database value is also displayed in parent report and not the corresponding language label. I’ll take a look into it. ---
**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:** [February 6, 2019, 2:07pm UTC](https://community.spicecrm.io/t/drilldown-report-passing-display-value-not-database-value/423/3 "2019-02-06T14:07:22Z")
Thanks Val. is there a way to get the database value showing instead of language label? it could be a quick workaround until it is resolved. ---
**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\ **Post date:** [February 6, 2019, 4:19pm UTC](https://community.spicecrm.io/t/drilldown-report-passing-display-value-not-database-value/423/4 "2019-02-06T16:19:01Z")
Try this: override type in presentation with “do not format” ---
**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:** [March 26, 2019, 2:56pm UTC](https://community.spicecrm.io/t/drilldown-report-passing-display-value-not-database-value/423/5 "2019-03-26T14:56:48Z")
Hi Val, Do not format has no bearing on passing the values to the child report. any other ideas ? ---
**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:** [March 26, 2019, 3:10pm UTC](https://community.spicecrm.io/t/drilldown-report-passing-display-value-not-database-value/423/6 "2019-03-26T15:10:27Z")
as a test i stored the result and displayed it in a fixed field. i set the fixed field to be the mapping in the dropdown. passing the database value works and the child report loads correctly. ---
**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\ **Post date:** [March 26, 2019, 4:47pm UTC](https://community.spicecrm.io/t/drilldown-report-passing-display-value-not-database-value/423/7 "2019-03-26T16:47:49Z")
Clever workaround! Thanks for sharing ---
**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:** [March 26, 2019, 5:00pm UTC](https://community.spicecrm.io/t/drilldown-report-passing-display-value-not-database-value/423/8 "2019-03-26T17:00:02Z")
Hi Val, it’s not really a workaround it was more to illustrate the point that the values being passed are incorrect.