Good day,

I am trying to create an expression that will take the answer of a 'child' question, ONLY if the answer to the 'parent' question is 'Yes'. For example, the question is structured in this format:



Now if the user answers YES, then they are asked a further question. I want the report to show only the No answer (from parent), but if the answer is a YES, then give the answer (from the child question)

Please assist

Regards

Zimiso

Can you post your desired output in case of the above report layout ? Please post your sample data and let us know the desired output .

Hi Milan,

The above shows exactly what the report should look like.

The questions are just coming from an end user application, and store in a database table. The database records ALL answers (Yes, No, programme); BUT the report will only show 'NO' answers and the relevant child answer when the answer was a Yes.

In other words, the report will not show any Yes answer, but the respective programme a user is studying for

Regards

Hi Zimiso,

In your scenario, if the answer of the parent question is stored in one field, and the answer of the child question is stored in another field in the database, in other words, the records stored in the database looks like below:

Then you can specify the expression based on the condition whether the parent question is Yes or No then return corresponding results. Please refer to screenshots below:

If the expression cant achieve your requirement, please share sample data stored in database for our analysis.

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu