Problems with SSRS data not showing

Problem Description:

Wrote a stored procedure for the data source of SSRS, but it was very slow to run the report every time, there was no problem checking the settings, and there was no problem with the individual stored procedures.

Problem Analysis:

The newly written stored procedure can not be resolved for some reason, in general, the database software will find the SQL statement to run the fastest way. These are performance optimizations that are automatically run by the software.

Solution:

1. Run the default stored procedure directly in the current database: EXEC sp_updatestats

2. Set the Auto Create statistic,auto updata statistic in the current database properties to True

Problems with SSRS data not showing