Reports not visible with choice_filter/cascading select

Description

I have a form with cascading select on three levels (type, category and code) using choice_filters. I want to create a report with those three fields to visualize the submissions. I see only the first layer of the cascading select (type) as available fields to use in the reports. I don’t see the other fields so I can not select them to visualize those fields.

Steps to Reproduce

  1. Create a cascading select set of questions
  2. Try to create a report with all the fields from cascading select
  3. Observe that this is only possible for the first top-layer field in the cascading select

Expected behavior

Ability to select every field in the report builder in Kobo.

Actual behavior

Only able to select the first field of cascading select in Kobo.

Additional details

I am using the KoboToolbox hosted by IFRC.

2 Likes

Welcome to the community, @Daan! Thank you for bringing this to our attention. Could you also share with us a screenshot of the issue? That would be very helpful for us to start investigating the issue.

Thanks for the amazingly quick reply @Kal_Lam .

Here are the relevant screenshots:

I would like to upload the xlsform as well but as new user it seems that I am not allowed

1 Like

Here is another screenshot:

1 Like

Thank you for sharing the screenshots, @Daan! Refresh your page and you should be able to upload the sample XLSForm that would also help us with testing your issue.

Thanks, here we go!
koboform for forum bug.xlsx (11.9 KB)

Hi @Daan

  1. In your XLSForm, I found an error in the cascading select setting for the question code “observation,_perception_or_belief”—there is an extra comma (,), which prevents the cascading function from working correctly for the “Belief or perception about the disease” category. I have fixed this issue in my uploaded file.
  2. After submitting about five cases to the server, I was able to generate a report, including the Feedback Category and Feedback Code. Please check the screenshot and try again after submitting some cases.


    koboform for forum bug.xlsx (16.8 KB)
2 Likes

Thank you very much @naylinsoe ! I was expecting it to be because of the cascading select. Turns out it was because of a small comma.. Thanks a lot for your help.

1 Like