Creating Event Rules in Financial Reports to Display Date Titles

Open a financial report template in RDA to which you have added a variable for displaying data titles.

  1. Click the tabular section of the financial report template and select Event Rules from the Edit menu.

  2. Select the Initialize Section event from the events drop-down list box.

  3. From the Insert menu, select Business Function.

  4. On the Business Function Search form, enter B8300007 in the Source Module field of the QBE line and press Enter or click Find.

  5. Click Select to select the business function.

  6. On the Business Functions form, click in the Value field next to the data item cDateTitleType to map the data structure parameters.

  7. Double-click Literal in the Available Objects list.

  8. On the Single value form, click the visual assist in the Date Title Type field.

  9. On the Date Title Search form, select a value, and click Select.

  10. On the Single value form, click OK.

  11. Click in the Value field next to the data item szLanguagePreference.

  12. To print the date title in the user's language, double-click SL LanguagePreference in the Available Objects list.

    SL LanguagePreference is the system value for language preference in the user profile.

  13. To print the date title in a specific language, regardless of the preference of the user running the report, double-click Literal in the Available Objects list.

  14. On the Single value form, click the visual assist in the Language field.

  15. Select a value and click Select.

  16. On the Single value form, click OK.

  17. Click in the Value field next to the data item szCompany.

  18. Double-click Literal in the Available Objects list.

  19. On the Single value form, enter the company number in the Company field and click OK.

    The company that you select determines the fiscal date pattern.

  20. Click in the Value field next to the data item mnPOPeriodNumber, and then double-click PO PeriodNoGeneralLedger in the Available Objects list.

    This is the period number that is defined in the Financial Reports processing options (T83PO). The processing option appears automatically at runtime to prompt the user for a value.

  21. Click in the Value field next to the data item szPOFiscalYear, and then double-click PO szFiscalYear in the Available Objects list.

    This is the fiscal year that is defined in the Financial Reports processing options (T83PO).

  22. Click in the Value field next to the data item szDateTitle, and then double-click the report variable name beginning with RV in the Available Objects list.

    This is the name that you assigned to the alpha variable that you inserted into the Page Header.

  23. On the Business Functions form, click OK.

  24. On the Event Rules Design form, click the check mark to save and return to RDA.