Reports
Reports define printable views of data available in the database. With the programme "QuickReport Designer" you define a QuickReport file (.qra). This contains the logic for loading the desired data from the database and the visual representation of the data. Users can create a print job via various applications. This print job contains, among other things, a reference to the required .qra file. The Innosoft Print Service processes these print jobs periodically and creates a PDF document as a result. In addition to the .qra files, further meta information is required for this:
Which .qra files exist?
Which languages are supported?
Which .qra files from which application are available to whom?
All these details are irrelevant for the user who starts the print job. As an administrator, however, you must set these details. Below you will learn how to configure these details and integrate your own QuickReports into the system so that they can be used by your users for printing various entities.
Prerequisites
In order for the QuickReports administration to become visible and the subsequent printing of QuickReports to work properly, you have to
adjust settings in the FSM,
install a current version of the Print Service and set it up as a Windows service,
ensure file access for consuming services (such as FSM and the server component Mobile App).
Log into the FSM with an account with system rights. Then navigate via the main menu
to the "Settings" area. Select the link
under "Administration". In the "General" section of the area
you enter the base URL via which the FSM can be reached in the "Reference URL" input field together with the concluding path segment "/ref/". That means, when the FSM can be reached externally via https://example.com/fsm/, enter https://example.com/fsm/ref/ in the input field. The URL entered is required for the e-mail templates that are linked to the QuickReport definitions. The URL template parameters in the e-mail templates are replaced by URLs beginning with the entered reference URL.
In the section "QR Reports", tick the option "QR reports enabled". Now the input fields "QR report path" and "QR output path" appear. Select the paths in such a way that the following accesses are ensured:
Input field |
Remark |
Access |
QR report path |
Base directory in which all QuickReport files are stored. |
Writing:
Reading:
|
QR output path |
The printed PDF documents are (temporarily) stored under this path. |
Writing:
Reading:
|
Then install the Innosoft Print Service. Before setting it up as a Windows service, ensure the following configurations in the "ISPrintService.ini":
Configuration path |
Remark |
Value |
[OPTIONS].ALLOWCREATETARGETDIRS |
Allows the creation of sub-paths within [OPTIONS].ALLOWCREATETARGETDIRSJAILDIR |
1 |
[OPTIONS].ALLOWCREATETARGETDIRSJAILDIR |
Limits the creation of paths to sub-paths of the configured base path. |
Path you have entered in "QR output path". |
[OPTIONS]
; The time interval in which the service will check for new print jobs (in seconds).
INTERVAL=5
SERVICENAME=ISPrintService_StandardDem
SERVICEDISPLAYNAME=Innosoft Print Service - StandardDemo
; Is the service allowed to create target folders if they do not exist? (Default: 0)
ALLOWCREATETARGETDIRS=1
; If the service is allowed to create target directories (see above), you may limit the creation only to folders beneath this directory. Which means no folders outside of this directory will be created. (Default: "")
ALLOWCREATETARGETDIRSJAILDIR=C:\Innosoft\StandardDemo\QrOutput
[CONNECTION]
CONNECTIONSTRINGENCRYPTED=Provider=SQLNCLI.1;Persist Security Info=True;User ID=user;Initial Catalog=StandardDemo;Data Source=SQLSERVER;Password=****
[LOGGING]
; Possible values: ERROR, NORMAL, DEBUG, TRACE
; LOGLEVEL=TRACE
LOGLEVEL=WARN
; LOGLEVEL=DEBUG
; The filename of the log file to write. If no path is prepended the file will be written to the program directory of the service.
FILENAME=..\..\logs\PrintService.log
[PDFPRINTER]
; The name of the PDF printer to use
PDFPRINTERNAME=Innosoft PDF - Printer
; The amount of time that will be waited for a print job to finish (in seconds).
TIMEOUT=240
; Should the printer configured above, be forced as the default printer before printing (the previous default printer will be restored afterwards). This prevents possible problems when there is not any default
; printer configured for the Windows user account the service is running with. Also this prevents problems, when Windows Server sets the default printer to a redirected client printer when someone logs into
; remote desktop using the Windows user account the service is running with.
; Default: 1 ( = activated)
FORCEASDEFAULTPRINTER=1