How to: Change the Default Number of Records that Display in the Report Preview
Important
This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.
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
Start Registry Editor.
Locate the following registry subkey:
HKEY_LOCAL_MACHINE \Software\Microsoft\Dynamics\6.0\
Select the Reporting node. In the right pane, right-click DefaultDataSetSizeInPreview and click Modify…
In the Edit DWORD Value window, click the Decimal radio button.
In the Value data field, enter the default number of records that you want to display on the report preview.
Note
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.
Restart Visual Studio to update the default value of records that will display in the report preview.