Adding Reports for Cash Server

Procedure

1. Configure online data gathering. Check on the reports that there is data on the open shift.
2. Go to Options > Customization > Extended properties and create extended properties for the restaurant, in the "List of Types: System -> Restaurant" property:
   

   Note: the system name of all extended properties, except IPAddress, can be arbitrary, the main thing is to know the ID of the extended properties.

   Note: the system name of all extended properties, except IPAddress, can be arbitrary, the main thing is to know the ID of the extended properties.

3. Amend script (\custhtml\sql\script.sqlfrom archive 1):
   Important: at the moment, the script is unique for each database, since it is necessary to specify the IDs of categories and extended properties from the RK7 management station in the scripts.
4. Execute the script script.sql on the current SQL-database (using SQL Management Studio is recommended);
   Important: after executing the script. sql script, be sure to execute the stored procedure RK7SQLPROC_REP_CALC. This procedure should be added to the scheduler and run every time after the general shift is closed.
   Figure 3. Executing a stored procedure
5. In the properties of the reference (reports) server, specify the HTTP port and address (the "Settings - OLAP reports - Report servers" reference book in the "HTTP Server" section).
   Note: it is recommended to read the article http://tracker.ucs.ru:8080/redmine/projects/-helpdesk-/wiki/R-keeper-7-xmlinterface-ru.
   Figure 4. HTTP Port of the directory/report server
6. In the manager station, fill in the extended property IPAddress, which contains the IP address of the report server (this way you can change the address of the server);
7. In the folder with the report server exe file, a folder /custhtmlis created, into which files from archive 1are placed (except for the folder with scripts);
8. A script is created in the manager station, which is bound to a custom operation, which in turn is bound to a button, the button is posted to the selector;
   The script is:
   Figure 5. Startup script fsWeb2.exe
9. Copy the fsWeb2.exe and *.dll files from archive 2;
10. By clicking on the created button at the checkout, fsweb2.exe is launched, which demonstrates the reports.

Figure 6. Example of how reports work

ATTACHMENT FILES:

custhtml.7z

fsweb2.7z

 Adding VAT fields to the food consumption cube  Creating a new fact in a cube