Hi all,
I'm trying to set up a Cascading filter, but can't get it to work.
My reports that this filter should run on are on the task_sla and sc_req_item table. We have two choice type fields on the sc_req_item table (inherited from task table) called u_product_category and u_product_subcategory, where the latter one's possible values are dependent on the first one's value.
Now I want to create a cascading filter where you first select the u_product_category, and then in the second filter you now have a list of options to select ONLY from the choices in u_product_subcategory which have dependent value == your selection for u_product_category.
I tried different approaches but nothing seems to work so far. The filter for u_product_category seems fine but the logic breaks around the filter for u_product_subcategory.
This is what my "parent" cascading filter looks like:
This was my first attempt at the "child" cascading filter:
Since that doesn't work (I only get option 'All' under the filter for Product Subcategory), I attempted the following approach:
Also not working... It just says Loading failed. Is it something I'm missing here? Or is this even possible?
TIA,
Annika
