SQLTeam.com | Weblogs | Forums

Can You Limit Export Options In SQL Server 2017?

So, I have a request to limit the number of items that appear in the 'Export' drop down box. The request is to only have Excel show up (getting rid of Word, Powerpoint, CSV etc,). Don't ask me why.

So, I found a thread that addresses the issue, but it is for SQL Server 2008; I am using 2017 and the file they mention apparently does not exist on my Local (C) drive (I did a full search on C). Here is what the person said:


"Ok so after some digging i found the answer to my first question:

\Program Files\Microsoft SQL Server\MSSQL.\Reporting Services\ReportServer\rsreportserver.config

This is the location of the file that needs to be changed in order to limit exporting options. Within the "Render" section of the file, the formats not needed can either be commented out or have their visible value turned to False."


Does anyone know if this can be relatively easily done for 2017 - and I (obviously?) would only want this to apply for 1 SSRS report, not to all reports we have..