Report Query using Microsoft Excel data source

[tinhester]

Hello everybody!

I'm a new user of iReport and at the moment I'm trying to create a report with data from a Microsoft Excel source. The connection was successfully set up. Now I'm trying to write an SQL statement in the Report Query since I do not need all fields of the table (see below). Somehow, the SQL query is completely ignored and I always get the complete table. Additionaly, I would like to add fields via the SQL query but that doesnt work as well. 

Does anyone has a solution for that? 

 

Thanks in advance,

Therese

Code:

SELECT     st.COUNTRY,     st.COUNTRY as "newcountry"FROM     state02 st

[pioppogatto]

Report query is not  for an Excel Datasource.  If you don't want all the columns in the report simply don't put the fields in the layout. If, for some reason, you don't want the columns in Excel datasource, while creating it, delete the columns after clicking on "Get columns name from the first row of the file".

Antonio