Hi I have a related question. I am trying out iReport for the first time, and I am trying to use a subdataset with an Excel spreadsheet as data source. (Some report elements such as 'Table' seem to require a subdataset) My Excel spreadsheet looks like this: Soda Respondents Coke 100 Pepsi 100 7-Up 33 Sunkist 20 Welches Grape 10 My xml code for the subdataset looks like this: <subDataset name="Dataset_1" uuid="0ed8ae74-6ddf-4e05-afba-dda8894f0c25"> <field name="Soda" class="java.lang.String"/> <field name="Respondents" class="java.lang.Number"/> </subDataset> Must I set up a query to get hold of the actual Soda and Respondents data? What must this query look like? Any feedback would be appreciated.
