Embedding EXCEL

The MICROS Retail OSCAR POS program also allows reports to be drawn up for hand-over and for the Excel program. The prerequisite for this type of report is that an FNL file is created for the relevant report data.

Proceed as follows to create FGL files for EXCEL forms:

Change to program Application -> System -> Database tables.
Select a database table for which an FGL file is to be created for the EXCEL form. Then press button "Excel".
Define the reports and store the file. The subsequently created FGL files are stored in directory "..\fgluser".
4GL files which have already been created and stored for reports and the export of statistics data to Excel can also be called up via menu Application -> Misc. -> Excel/Print (see Excel/Print).
Please note that the standard path (..\fgluser) for the function "Excel/Print" " can be changed with the environment variables in file "oscar.ini".
EXCEL_FILE_NAME_PATH=..\fgluser (or any other path name)
EXCEL_TARGET_FILE_NAME_PATH=..\fgluser\Datei.fgl (or any other path name and file name)
When these reports are called up with function "LstExcel" (Excel/Print) within a report chain a path and/or path and file name up to a length of 254 pos. can be entered.

Selecting the Database Table

The following example describes how to select the statistical data of the item turnover for operators for transfer to the application EXCEL or process it for printing of an individual report.

In order to be able to select statistical data you have to open the window System -> Database -> Database Tables.
An overview of the available statistical data can be found in the update program Parameters -> Misc. Params ->Statistic parameter.
Enter the desired name of the database table in the field Name or activate the search function to select the file ArtTurnOper in which the item turnover of the operators is stored.
After selecting the desired file, click on the button <Excel>.
Window Item statistics operator appears.
In the left-hand section of the window you will see the database fields to be selected. You can select them by a mouse click.
Every field will be transferred to the right-hand window via a mouse click in order to allow you to collect all the data of your report.

You can also activate additional options to design the report as you like.

The following options are available:

Field name = Name of the database field.

Compare = Selection field for comparisons like "=", "<>", "<", ">=" etc.
Value(s) = Values like date or section values
As in report chains where a minus interval can be entered it is also possible here to enter prefixes to date entries, e.g.

Year in date -1 = prev.year

Quarter in date -1 = last quarter

Month in date -1 = prev.month

Week in date -1 = prev.week

Day in date -1 = yesterday

Weekday in date -1 = weekday before today

Function = Selection field for the following functions: Sum = Total, Avg = Average", Min = Minimum, Max = Maximum, Count = Quantity

Sort = When this field is activated, the report is sorted according to this field/ these fields.
Not = When this field is activated, it will not be displayed as a column in Excel.

The following buttons are available on the menu bar:

Open = Opens a stored report mask. The corresponding report masks are stored in the directory fgluser in the 4GL format.
Save = Saves a report mask in the directory fgluser in the 4GL format.
Start Excel = Starts the application EXCEL and opens the spreadsheet analogous to the report mask. (EXCEL Version 8 =EXCEL 97 must be installed on the PC).
Start Report = A report analogous to the report mask created beforehand will be displayed on the screen.
Print = The report will be printed.
Help = The MICROS Retail OSCAR POS Online Help will be started.
New = Opens a new report mask.
Cancel = Cancels the present report mask.

Embedding EXCEL

Selecting the Database Table

Table Display in Excel directly after program start:

Display of a table edited in Excel:

Display of a report on the screen: