Parent Dependent dropdown field is not filtering dropdown values based on the parent selection in Reports.

Hi All,

We have created parent dependent dropdown field in studio i,e, Type and Category field. Based on the selection of different types, different categories should be populated which is a dependent field. It is working perfectly in the edit layout but not working in reports. Please help us on this.

Thanks in advance.

  • Hi Yashgeet Saluja,

    Please describe in more detail what you mean by it not working in reports.

    The point of a dropdown dependency is to limit the options a user has in the record when setting the values. In reports, you are not setting values, but filtering on them, grouping by them, or displaying their values in the resulting columns.

    It is unclear what use case you have for a dependency restriction on a dropdown within Reports.

  • Hi Patrick,

    Please refer to the example explained below:
    Like we have two fields, Region and District. District is a dependent field on Region. Under Region, we have two lov's i.e. New Delhi and West Bengal. Based on the selection of New Delhi Region, following lov's in the district should be populated i.e. East Delhi, North Delhi and South Delhi and based on the selection of West Bengal Region, following lov's in the district should be populated i.e. Darjeeling, Kolkata and Howrah. District is not filtering values in reports based on the selection of Region, but 

     it is working fine in creation page layout. Attaching the screenshots for your easy reference.


  • Hi Yashgeet Saluja,

    The product, as described and shown, appears to be working as expected.

    There is no design expectation for dependent dropdown functionality to change dropdown options in Report filters.

    Enhancement request #79200, requested in 2017, speaks to the current design and requests that report filters respect the dependencies. In our system, the only case related to this request is the one case that reported it back in 2017, so it does not appear to be functionality with high demand.

    I recommend posting your desire for this functionality in the Explore section.

    I also appreciate that you have posted this in the developer section, so my hope is that someone here has custom development advice for you.

    I hope this helps!