Siebel Hospitality Guide > Managing Hospitality Reports > Process of Converting the Banquet Event Order Report to a 12-Hour Format >

Configuring the Banquet Event Order Report Template

Use this procedure to modify the sections in the Banquet Event Order Report template that control the display of function times in the report. The modifications change the time display from a 24-hour format to a 12-hour format in specific parts of the report.

NOTE:  To perform this task, you must have Oracle BI Publisher Desktop and Microsoft Word installed.

This task is a step in Process of Converting the Banquet Event Order Report to a 12-Hour Format.

To configure the Banquet Event Order Report template

1. Start Microsoft Word and open the TNT_BEO.rtf file.
2. In the application menu bar, choose Oracle BI Publisher, then choose Field Browser.

   The Field Browser pop-up window opens. This window shows the code for the fields of the template.

3. In the Field Browser pop-up window, click Show All.
4. Change the display of function times by performing the following steps.
   1. In the Find field in the top right of the window, enter Stime and click Find Next.

      The Stime character string appears in the For Each Function section of the template code. This section controls the display of the function details such as name, type, time, and so on. The line that contains STime and the next line appear as follows:

   <?STime?>
   <?xdofx:if ETime!='' then ' - '||ETime end if?>

   2. Select the line with STime, and in the Edit box at the bottom of the window, replace STime with STimeCalc and click Update.

      The line now appears as follows:

   <?STimeCalc?>

   3. Select the next line, and in the Edit box, replace each of the two occurrences of ETime with ETimeCalc and click Update.

      The line now appears as follows:

   <?xdofx:if ETimeCalc!='' then ' - '||ETimeCalc end if?>

5. Change the display of order item times by performing the following steps.
   1. In the Find field in the top right of the window, enter BEOSTET and click Find Next.

      Two instances of the BEOSTET character string appear in the Report Header section. This section groups the order items by report header and displays the function times with the items. Each line that contains BEOSTET appears as follows:

   <?../../ListOfTNTSHMFunction_BEOOrderItem/TNTSHMFunction_BEOOrderItem[xdoxslt:get_variable($_XDOCTX, 'Count2')]/BEOSTET?>'

   2. Select each line that contains BEOSTET, and in the Edit box, replace BEOSTET with RHLFST and click Update.

      The lines now appear as follows:

   <?../../ListOfTNTSHMFunction_BEOOrderItem/TNTSHMFunction_BEOOrderItem[xdoxslt:get_variable($_XDOCTX, 'Count2')]/RHLFST?>'

6. Click Close to close the Field Browser pop-up window.
7. Save and close TNT_BEO.rtf.