Friday, November 29, 2013

019. iReport: CREATE NEW REPORT



We have to read and understand 013. SETTING DATABASE CONNECTION.
This tutorial using iReport 4.1.1.


  1. Create New File...
  2. Set Report Name (example: rptDDA)
  3. We will see a dialog that we have created it.
  4. Click Query Button
  5. Unceklis Automatically Retrieve Fields


  6. Write this sql:
    SELECT C.* FROM SCH.CHILD C
  7. Click Read Fields button. The fields will be shown below.
  8. Click OK
  9. All of Fields will be shown in Report Inspector tab -> Fields node.
  10. Select all fields, then drag them to Detail band.
  11. Fit the Detail height, by double click the bottom line of Detail band.
  12. Select all object within Detail band and Column Header band.
  13. Right click them, select Padding and Borders.
  14. Set the Line width, then OK.
  15. Click Preview button.
We know, it doesn't look like an interesting report. Remember, these steps are for white-belt.