WEB Reports (ASP)

The MICROS Retail OSCAR POS application provides the opportunity to call all reports via internet / intranet from a web server by use of ASP scripts (ActiveServerPages). This requires the input of the server URL in the client browser and the selection of the desired report in a form.

The MICROS Retail OSCAR POS application supports web reports via ASP (ActiveServerPages) and from MICROS Retail OSCAR POS version 3.0 on also via ASP:NET.

 Further notes on web reports via ASP.NET can be found in the documentation WEB Reports ASP.NET.

Generally, all reports of the MICROS Retail OSCAR POS application can be called via internet; the browser windows will be displayed in the MICROS Retail OSCAR POS standard layout.

The web page for the selection of the reports is to be called by entering the URL in the browser:

• e.g. http://<servername>/webreport/
• Via the selection field, you can call all reports for which the corresponding parameters have been set in the update program Parameters -> Misc. Params -> Reports on Till.

The usage of web reports in MICROS Retail OSCAR POS requires:

1. Generally, web reports can only be used if the MICROS Retail OSCAR POS application works with an SQL Database (e.g. MS-SQL-Server 7.0).
2. For the installation, the generation and the access to web reports, the IIS (Internet Information Server 5) has to be installed on the MICROS Retail OSCAR POS server.
3. Configure an ODBC connection to the SQL database as follows.
   Name = oscardsn
   Login ID= oscar
   Password = adsanker
   
   Attention!
   The authentification type "With server authentification by login ID and password"" has to be selected to enable the access from the web scripts to the MICROS Retail OSCAR POS SQL database.
4. The necessary files for the creation of web reports are delivered in a zip archive along with the current MICROS Retail OSCAR POS version 2.0 (..\bin\Webreport.zip) and have to be installed as follows.
• Copy the file Webreport.zip to the MICROS Retail OSCAR POS directory.
• Unpack the zip archive.
• Start the installation script by use of the command oscar installWebreport from the "work" directoryof the current MICROS Retail OSCAR POS installation.
  
  Note:
  By the execution of the installation script, the directories \oscwebrep\assets\images; \oscwebrep\log; \oscwebrep\out for the web report scripts are generated in the root directory of the IIS (Internet Information Server ) "<drive>:\inetpub\wwwroot\" and the necessary *.asp and *.gif files are copied in these directories.
  In addition, the file "global_param.asp" is adjusted and the component studi1.dll is installed.
5. In the update program System -> User Interface -> Applications -> Report Chain, an application program called "WebChain" of the type report chain has to be configured with a free number.
6. For the reports offered for selection via internet, the appropriate parameters have to be set in the update program Parameters -> Misc. Params -> Reports on Till.

---

MICROS Retail Deutschland GmbH
Salzufer 8
D-10587 Berlin
Germany