tinhester

Hello! I'm currently trying to make a report using a multi axis chart because I want to combine a line chart and two bar charts. Unfortunately, I have three different Y-axis in my report. Since all charts have the same range, I only want them to have one common Y-Axis. Is that possible? And if yes, how can I do that? Thanks for your help, Therese

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