Skip to page contentSkip to chat
ServiceNow support
    • Community
      Ask questions, give advice, and connect with fellow ServiceNow professionals.
      Developer
      Build, test, and deploy applications
      Documentation
      Find detailed information about ServiceNow products, apps, features, and releases.
      Impact
      Accelerate ROI and amplify your expertise.
      Learning
      Build skills with instructor-led and online training.
      Partner
      Grow your business with promotions, news, and marketing tools
      ServiceNow
      Learn about ServiceNow products & solutions.
      Store
      Download certified apps and integrations that complement ServiceNow.
      Support
      Manage your instances, access self-help, and get technical support.
Specifying a Drilldown view for a Pivot report does not display the data in the specified view - Known Error
  • >
  • Knowledge Base
  • >
  • Known Error (Knowledge Base)
  • >
  • Specifying a Drilldown view for a Pivot report does not display the data in the specified view
KB0657274

Specifying a Drilldown view for a Pivot report does not display the data in the specified view


1438 Views Last updated : Apr 7, 2024 public Copy Permalink
KB Summary by Now Assist

Description

When drill down view is specified in the Pivot report, clicking on the link in the pivot table does not open the record with the specified view.

Steps to Reproduce

  1. Navigate to Report > Create New
  2. Create  a report of Type Pivot from the incident table
  3. Select Active field on Rows and Assigned to on columns
    2. Click on the cog wheel next to Type field, which opens up a box Style your chart
  4. Select a view e.g. portal and Close
    3. Run the report
    4. Click on any of the links from the pivot report

Note that the data displayed in the subsequent page does not show the specified view

Looking at the URL , it can be seen that the parameter sysparm_view does not have the view name assigned to it. Setting the value for the parameter sysparm_view=portal shows the results in the correct view

Expected Result: The data is displayed in the subsequent page in the specified view.

Workaround

Instead of using the pivot, use the Multipivot widget. The new multipivot widget is faster, prettier, has more features and is less buggy then the very old pivot widget. This issue does not occur on the multipivot.


Related Problem: PRB741192

The world works with ServiceNow.

Sign in for more! There's more content available only to authenticated users Sign in for more!
Did this KB article help you?
Did this KB article help you?

How would you rate your Now Support digital experience?

*

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

What can we improve? Please select all that apply.

What are we doing well? Please select all that apply.

Tell us more

*

Do you expect a response from this feedback?

  • Terms and conditions
  • Privacy statement
  • GDPR
  • Cookie policy
  • © 2025 ServiceNow. All rights reserved.