186 views

Description

A report containing variables in the columns generates a database query that can take several minutes to process, making the report look unresponsive.

Steps to Reproduce

 

  1. Crete a report with the following values:

    • Report name: Variable Report
    • Source type: Table
    • Table: Requested Item [sc_req_item]
  2. On the Available list, select Variables [+] and click the plus sign.

  3. Choose Service Category Request, and then Comments, and move them to the Selected list. Click Save.

    When you run the report, try to export to CSV, PDF, Excel. The report will show the download dialog for a long time without progress. This process will be significantly slower than the same report without variables.

 

 

Workaround

Remove the variables from the report.

 


Related Problem: PRB1169942

Seen In

There is no data to report.

Intended Fix Version

New York

Safe Harbor Statement

This "Intended Fix Version" information is meant to outline ServiceNow's general product direction and should not be relied upon in making a purchasing decision. The information provided here is for information purposes only and may not be incorporated into any contract. It is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at ServiceNow's sole discretion.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2018-08-27 06:34:01
Published:2017-10-13