Problem with binding the fields

[shreelu11]

Hi

Iam new to iReports,Doing my first report.

 

I designed the report with two Text Fields called $F{pay_mode} and $F{amt} and i have given sql query in report query to fetch data from the DB.

 

I don't know how to bind the query fields to ireport fields.

 

plz let me know how to do this.

 

Regards,

Sreelekha.

[makina_syu]

Did you set active connection?

[shreelu11]

ya, I have sat a active connection.

 

I gave a sql query in report query, I am doubtful if i have to specify $F{pay_mode}and $F{amt}in the query in place of the database field name and bind the fields of ireport and database fields anywhere else..

 

Pls let me know how to do that.

[makina_syu]

Sorry I didn't answer earlier. Probably you solved your problem. Anyway, this is I can answer to you:

In Report query select query language SQL

Query:

SELECT payMode, amt FROM yourTable...

When you write query like this you should click "Read Fields" or turn on "Automatically retrieve fields"

If everything is ok you should retrieve desired fields and you should see them in area below query area. That is it!