Generating fields by SQL query

[jack w.]

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?

[narcism]

This could be a starting point: https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v640/registration-fields-sql-query

The documentation also provides information about parameters/variables.

[jack w.]

Hi narcism, thanks for an answer.

I've already read this article and tried to create a field this way, but after I click "OK" nothing happens. So, after following the instructions, I suppose I have "registered" the field. But why doesn't it appear in the Fields list? How am I supposed to use it in my report?

[narcism]

Maybe you are getting an error on the Dataset and Query Dialog that prevents you from reading the fields. You need to check the top left corner of the dialog for errors after pressing the "Read Fields" button.