AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
![]() ![]() see Rendering Extensions Overview on SQLDocs for more information on individual extensions. Look for the Render section, enable or disable the export formats that you want your users to have access to. NOTE: This solution is a common workaround when rendering extensions fail to work due to your deployment configuration or environment.Ĭ:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer\nfig It will download in 'xls' format not 'xlsx' You can enable it to 'EXCEL' by default by changing the 'rsserverconfig' file under reporting services. Then it will download and work correctly. Check in the URL (once you click on excel) whether the format is EXCELOPENXML. In my case, it was HKU\%service account sid%\Software\Microsoft\Avalon.Graphics, and granting the execution account (not the account that runs the service) Read access to this key resolved the issue. It was difficult to search all of the output but you can filter by registry key access, then look for the RS executables or the result ACCESS DENIED. I was not sure what the fallout would be for existing reports, so I was not satisfied with this solution either.Įlsewhere I saw a recommendation to use Process Monitor (procmon) to watch for registry key access denials, you can download it here procmon. I removed the account from unattended execution in Report Services Configuration Manager and suddenly was able to export to XLSX. I'm using an execution account with low permissions and did not want to make it a full Local Admin permanently but I tried adding it, unsuccessfully. If you can't complete these steps, contact your system administrator.I just spent hours troubleshooting this in a fresh install of SSRS 2019 using an updated database from a prior version. Step 3: Download Chrome againĭownload Chrome again from /chrome. If you can't install Google Chrome with your antivirus software turned off, you might need to upgrade your antivirus software. Some antivirus software can prevent Google Chrome from installing on the computer. ![]()
0 Comments
Read More
Leave a Reply. |