Jasper Reports with iReport multiple records not showing up

Question

Hi I am creating an invoice report using iReport. I have a table named orderstable and within it there are 6 fields; Order Number, Account Number, Invoice Number, Description, Amount and VAT.

Data contained is as follows:

record 1: 1, PA0001, 10005, Monthly Charge, 200, 20
record 2: 2, PA0001, 10005, Training Delivered, 250, 20

Now when I run my report it asks me for the invoice number. In this case I put in 10005 and this returns a report with the 1st record only. How can I get it so that the details of the Description, Amount and VAT fields are returned for both records?

Thank you.

Answer 1

The solution to this problem is to make sure that you are putting your data in the details section of your report.

Answer 2

If you put the Table in the Details Section then i donot think that this situation will arise it will repeat the values as this is the property of the details section in IReport.