[SSRS] ToDo List when new fields doesn't show on report
When newly added fields doesn't show up on your SSRS Report or just with empty values but the record in the temporary table get's filled, try the following points to solve the problem:
- Refresh DataSource on Report Design
- Synchronize the Tables
- Refresh Caches under Tools\Caches (all 4)
-- Check again -- - Remove Report from Server (via Report-Manager)
- Refresh Caches again under Tools\Caches (all 4)
- Deploy Report again
-- Check again -- (All previous steps together till here normally solves the problem) - Restart the SSRS Instance (Service)
-- Check again -- - If using Query: Remove Report related data from table SRSReportQuery
- Remove related records from table SysLastValue
- Forward-Compile DataProvider class
-- Check again -- - Last resort: Restart AOS (not neccesary in most cases)