I want to generate fields in my report that match a certain condition, for example:
1. I've got a survey with ID 40
2. I want to select all "question_name" values from table "questions", where "survey_id" = 40
How can I do that? I assume that my "question_name" values are fields I need to display in my Detail band, but where do I put the SQL query that will enable me to do so? Do I use parameters/variable for this?