Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Example: Create a Report Design with Resource-Based Translation

Example: Create a Report Design with Resource-Based Translation

This example illustrates how to create a report design that uses resource files to translate label text based on the user's location.
A colleague asks you to create a report design for a high-level summary of the current employment situation at Global Modern Services, using resource files to enable translation. You need to create a custom report in Workday to select the relevant data. The design uses a single data set. The default locale language for the report is English. The target language is German.
  1. Sign in to your Workday GMS tenant.
  2. Access the
    Create Custom Report
     task. Configure these values:
    Option
    Value
    Report Name
    Positions Vacant
    Report Type
    Advanced
    Data Source
    Companies
    Enable As Web Service
    Select this check box.
  3. On the
    Columns
     tab, configure these values:
    Business Object
    Field
    Column Heading Override
    Column Heading Override XML Alias
    Company
    Name
    Name
    Name
    Company
    Position Count - Total including Subordinate Organizations
    Positions - Total
    Positions_-_Total
    Company
    Positions Filled - Count
    Positions - Filled
    Positions_-_Filled
    Company
    Position Count - Fillable
    Positions - Vacant
    Positions_-_Vacant
    Company
    Average Age
    Average Employee Age
    Average_Age
  4. Open Report Designer in Workday Studio.
  5. Create a report project named
    Positions Vacant
    . In that project, create a report file named
    Positions Vacant.rptdesign
    .
  6. Create a Workday data source and download some sample data:
    1. Create a new
      Workday Report Data Source
       named
      Positions Vacant Data
      .
    2. Download the report description for the
      Positions Vacant
       custom report from Workday.
    3. Download sample report data from Workday and name the file
      Positions Vacant Sample.xml
      .
  7. Create the data set relating to the primary business object, Company:
    Option
    Value
    Data Source Selection
    Positions Vacant Data
    Data Set Type
    Workday Primary Report Data Set
    Data Set Name
    Positions
    Report Designer displays XML schema element values and names for the columns that you added as rows to your custom report for the Worker business object in Workday.
  8. Create a table using the
    Positions
     data set:
    1. Drag the
      Positions
       data set to the
      Layout
       tab of the main window.
    2. Select all available binding columns.
    3. Delete the footer row.
    4. On the
      General
       tab of the table's
      Property Editor
       view, enter
      Positions
       in the
      Name
       field.
  9. Create a translation resource file for the default locale language and associate it with the report design file:
    1. Select
      File
      New
      Other...
      . Expand the
      General
       node and select
      Untitled Text File
      .
    2. Add keys to the text file. Use the format
      Key=Value
      , where
      Key
       is the name you supply for the resource key and
      Value
       is the appropriate text in English. Give each key its own line in the text file:
      Key
      Value
      Name
      Name
      Total
      Positions - Total
      Filled
      Positions - Filled
      Vacant
      Positions - Vacant
      Age
      Average Age
    3. Save the text file in the
      Positions Vacant
       project folder with the filename
      translations.properties
      .
    4. On the
      Resources
       tab of the report design file's
      Property Editor
       view, add the
      translations.properties
       properties file.
  10. Create a translation resource file for the target language:
    1. Select
      File
      New
      Other...
      . Expand the
      General
       node and select
      Untitled Text File
      .
    2. Add keys to the text file. Use the format
      Key=Value
      , where
      Key
       is the name you supply for the resource key and
      Value
       is the appropriate text in German. Give each key its own line in the text file:
      Key
      Value
      Name
      Name der Firma
      Total
      Positionen - Total
      Filled
      Positionen - Gefüllt
      Vacant
      Positions - Frei
      Age
      Durchschnittsalter
    3. Save the text file in the
      Positions Vacant
       project folder with the filename
      translations_de_DE.properties
      .
  11. Associate column headings with resource file key pairs:
    1. Select the
      Name
       column heading.
    2. On the
      Localization
       tab of its
      Property Editor
       view, click
      Browse
      .
    3. Select the
      Name
       key pair.
    4. Repeat substeps a through c for each column heading.
  12. Delete the date expression from the footer in the
    Master Page
     view.
  13. Preview the translation in Report Designer.
    1. Save your design and preview it as normal by selecting
      Run
      View Report
      As PDF
      . The table's header row displays in English.
    2. Change Report Designer's locale by selecting
      Window
      Preferences
      Report Design
      Preview
       and then selecting
      German (Germany)
       from the
      Choose your locale
       drop-down list.
    3. Preview the design again. The table's header row displays in German.
Deploy your design to Workday for use as business form layout.