Skip to content

Report Writer Reports

Jump to bottom
Mike B edited this page Mar 25, 2024 · 6 revisions

Home>Extensions>Report Writer>Report Writer Report Definitions

Report Definitions bring everything together. You select the Data Selection Group to specify which records will be output in this report, the Data Filter Parameters to specify which of the chosen records will be output, and the type of output.

You manage reports using the Main Screen as shown below:

reportwritermainrep.jpg

You can Add (1), Edit (2), Copy(3), Delete (4) or Run (5) a report. You must select an entry before you can edit, delete or run it. Button (6) opens the output folder to allow you to manage the created file.

When you add or edit a report you will be presented with the following screen.

rwreplabel.jpg

You must select a name (1), if the name already exists you will be asked if you wish to overwrite that entry.

You then need to select what type of output you want:

  • Create Database (2) as with View Jasper Report but it does not run Jasper
  • Create Spreadsheet (3) creates Microsoft Excel Spreadsheet with an extension of xlsx.
  • Create .CSV File(4) creates a separate file for each record, each file will be named as defined (7,8, 9 and 10) plus a short record name and the extension .csv (for example outputfileacct.csv)

If you choose 'Create CSV file' you will also be able to select the delimiter to use (5). If the output file is going to be read by Excel tick box (6), this will add a 'sep=x' where 'x' is the selected delimiter. If the delimiter is a comma (,) this is not added.

The next set of fields define the output file. You can enter a name (7) or choose to have the extension generate a name(8). This will be called 'ReportWriteryyyy-MM-ddHHmmss' where yyyy is the year, MM the month, dd the day, HH the hour, mm the minutes and ss the seconds.

If you donot generate the name (8) and the file already exists you can choose to overwrite it by clicking on (9), alternatively you can add the Date Stamp (10) which will append the date stamp (as above) to the file name. ** note ** if you select Generate (8) and Add Date Stamp (10) you will get the date stamp twice in the name.

Next you need to select a Data Selection Group (11) and a Data Filter Parameters (12) record.

Click on button (13) to save the data and exit, button (14) to cancel and discard the data.

Lastly, to actually run the report select the entry on the main screen and click on button (4).

Please refer to the following pages for more information about Report Writer:

Clone this wiki locally