CRM 2013 Error: Maximum record limit is exceeded. Reduce the number of records

When you open a chart in CRM 2013 and get this error "Maximum record limit is exceeded. Reduce the number of records", it's because the number of records to fetch is more than 50.000.

To solve do the following:

--****** get the number of records to be fetched ***********

Use MSCRM_CONFIG

Select IntColumn from [MSCRM_CONFIG].[dbo].[DeploymentProperties] 

where ColumnName = 'AggregateQueryRecordLimit'

--*********************** increasing the number of records to be fetched ***

Use MSCRM_CONFIG 

UPDATE [MSCRM_CONFIG].[dbo].[DeploymentProperties] 

SET [IntColumn] = '99999999' 

WHERE ColumnName = 'AggregateQueryRecordLimit'