Hi JijuR575, 

Generally if you use an unexposed property(a property which is in the database, but not in blob), it will take some time to load. you have three ways

1. try limiting your search with usage of filters

2. increase the time to retrieve from Data Access->General data access settings and set Maximum elapsed time in seconds

3.use a Top/bottom rank and mention the based on field with a property mentioning the number of rows to be fetched

Unexposed property Or I could say more precisely UnOptimized property usually is the primary cause of performance issues. And they are inside the BLOB object(pzpvstream).

Optimizing means, creating a dedicated column in the database table and mapping the corresponding property to the database column.

Suggestions:-

- It's advisable to optimize all the property used in the report definitions(You could verify by checking the respective property entries Log-System-PropertyOptimization(pr_changelog). This table stores all the optimized properties.

- Fine Tuning Reports

Hope it helps.