Home > SSRS > Limit Report Rendering Extension in Report Manager (PDF Only)

Limit Report Rendering Extension in Report Manager (PDF Only)

SQL Server Reporting Services (SSRS) provides web tool named Report Manager. Report Manager is used for managing reports.

When we run the report published on report server we have “save” icon where we have different rendering option like Excel, Word, PDF, XML etc.

ExportOptions

We can limit the report rendering extensions. For example if we want to disable all the format and want only PDF then we need to configure some settings in config file.

Go to the ReportServer installed directory. path is somewhat similar to C:\Program Files (x86)\Microsoft SQL Server\MSRS11.SQL2012\Reporting Services\ReportServer

Edit rsreportserver.config file.

Got to Export Option in the file as shown below:-

RenderingOptions

In above screen , with all render option there is visibility option, set it to false whichever we want to hide.

let say our user wants PDF only then,

We need to modify the above file as given below:-

RenderingOptionsModified

Adding condition Visible=false/> in front of Rendering options which are not required.

Lets Run the report on reportserver and see the export options.

ReportWithPDFOptionOnly

Topic added in this website http://msbitips.com

Thanks
Prasad

Learn Different BI Tools
Subscribe my YouTube Channel : BI Tools

Advertisements
Categories: SSRS Tags:
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: