Using dynamic data fields in reports

As a reporting administrator, you can create a report to view information from dynamic data fields that are used in cases. The dynamic data field report is based and filtered on a case template. The dynamic data fields that you want to use in the report must be added to the case template. You can use the dynamic data fields as columns and filters in the report.

To create a report with dynamic data fields, complete the following steps:

1. Create a view for the dynamic data fields.
2. Publish the view.
3. Create the report to view dynamic data fields.

To create a View for dynamic data fields from a case template

1. In Smart Reporting, right-click Case - Cases View and select Make a copy.
   All out-of-the-box data structure is copied to the new view.
2. Specify a name for the view and publish it.
   All dynamic data field related configurations are copied to the new view. You can also add other case-related fields from the existing view into the new view. Learn more about creating views in Defining views for report creation .
3. Click Create > Report.
4. Use the view that you created as a copy of the Case - Cases View in step 1.

5. Select the Columns that are required for the report.

    Examples

   The following examples show the different dynamic data fields that you can use for the dynamic data field report:

   • For the case ID to be displayed in the report, select the Display ID field. To enable users to click the case ID to open the case, add ID as a column, right-click the column name, and change the format to Link to URL. Hide the ID column if you do not want the GUID to be visible.
   • For a date to be displayed in the report, add the Date and Date Time fields in the view. If you want to enabling filtering in the report based on date, add the fields to the Filters section. To enable users to select a date range, complete the following steps:
     1. Right-click the Date field, and select the Operand as Between.
     2. For a predefined list of dates, expand Entry style, and select Value List Selection for Value Entry Method.
     3. For Value List Setup select Predefined Periods.
        The default values for a drop-down list are displayed for selection in the report.
     4. For custom values to be displayed, select Cached Values on Demand.
        Custom values are displayed based on the field type from the data source.
6. Complete the following steps for all dynamic data fields that you want to add to the report:
   
   1. Expand Case Dynamic Data in the left navigation, select Dynamic Data Value, and drag and drop them to the Columns field on the right.
   2. Click Dynamic Data Value, and select Advanced Function.
   3. From the Select Function drop-down list, select Text, and select Get Dynamic Data Fixed Value.
      

   4. Enter the field name in Dynamic Data Field, and click Save.

      Important

      • The value that you specify for the dynamic data field must be the Field Name value from the case template.
      • Adding a dynamic field that is part of a dynamic group as a column in a report is not supported. The getDynamicDataValue function accepts only Dynamic Field Key and returns the Dynamic Value. It is not designed to accept Dynamic Group Name as a input.
   5. Click the Dynamic Data Value column, and select Format > Edit.
   6. Specify the column label in the Display text field.
   7. From the left navigation, expand Case Template, and add the Template Name field as a column and as a Filter.
      You can hide the Template Name column in the view. For more information about filters, see Filters .
   8. In the Filter section, right-click Template Name, select Value > Search Values, and select the case template.
   9. Click Submit.
7. Proceed to publish the view.

To publish the View

After the view is created for the dynamic data fields, you must publish the view to use it in reports.

1. Open the newly created view.
2. On the top menu bar, click Publish.
   
   
3. On the Report Settings tab, enable the Use as View setting.
4. Click Save.
   Two records are created when you publish the view: a Dynamic Report Child View view and Dynamic Report Child View report.
5. Open the Dynamic Report Child View report, and click Edit.
6. (Optional) If you do not want the child report to be visible in the list of reports, on the Report Settings tab, disable the Browse Page setting.
7. View the dynamic data field columns in the report.
8. Create the report.

To create and run the final report for dynamic data fields

1. In Smart Reporting, click Create > Report.
2. Select the view that you published.
   Only those dynamic data fields that you added in the View are available for selection.
3. Drag and drop the dynamic data fields as the columns for the report.
   The properties and advanced functions that you defined in the earlier report for the dynamic data fields are retained in this report and you do not need to define them again.
4. Define the filters for the report, and save the report.
5. Run the report to view the dynamic data fields in cases.
   You can use the filters that you defined to view the data in the report.