Exporting a report to Excel, Word or PDF was fine using Admin account. However, using a non-admin account, exporting report to Excel or Word will returned a blank/empty page but PDF was fine.
Solution
Navigate to the folder "C:\Users\<App Pool Identity>\AppData\Local\Temp", edit the security of this folder and add "Authenticated Users" with "Full Control " permissions.
How to check App pool identity?
In IIS Manager, click on Application Pools. Check the Identity for the particular app pool under the Identity column.
