How to: Change the Default Number of Records that Display in the Report Preview [AX 2012]

Updated: September 28, 2011

Applies To: Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

You can preview a report design to be sure that the layout and data look the way that you intended. The preview will return 1000 records by default. This makes the processing of large amounts of data for the preview more efficient. If you want to see all the data in the preview of your report, in the Preview window, click the Load data sets fully link.

The following procedure describes how to change the default number of records that display in the report preview.

To change the default number of records in the preview

  1. Start Registry Editor.

  2. Locate the following registry subkey:

    HKEY_LOCAL_MACHINE \Software\Microsoft\Dynamics\6.0\

  3. Select the Reporting node. In the right pane, right-click DefaultDataSetSizeInPreview and click Modify…

  4. In the Edit DWORD Value window, click the Decimal radio button.

  5. In the Value data field, enter the default number of records that you want to display on the report preview.


    Enter 0 if you want all records to display in the report preview.

    The value will be reset to 1000 if you repair Visual Studio tools.

  6. Restart Visual Studio to update the default value of records that will display in the report preview.

Community Additions