Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
 Posted - 2009-09-01 : 08:09:59
|
| Does anyone know of a way to remove or block output types on the export report option?We are trying to allow just PDF and TIFF options.We know you can still copy from a PDF and Paste to excel but we don't want to give them an "easy" way to do it.John"The smoke monster is just the Others doing barbecue" |
|
|
slihp
Yak Posting Veteran
61 Posts |
Posted - 2009-09-09 : 04:49:32
|
| if you edit the web.config file you will see the output types (search for pdf, xls etc). coment thes out and restart the service and these should then be disbaled. |
 |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-09-09 : 08:00:18
|
| slihp,I found the web.config in my C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportManager folder but there is no reference to the file extensions. I did not set up the server so I am wondering if it could have been an option upon install?John"The smoke monster is just the Others doing barbecue" |
|
|
|
slihp
Yak Posting Veteran
61 Posts |
Posted - 2009-09-09 : 09:45:18
|
| Hi; sorry the config file is \Reporting Services\ReportServer\rsreportserver.config and not as i said the web.config. You want to look for the <Render> tag that holds all the extensions and add the visible="false" property to each one you dont want to be displayed in the export dropdown so if you dont want to see csv then<Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>becomes<Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering" Visible="false" />but remember the service must be restarted. |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-09-09 : 11:40:01
|
| Perfect. Exactly what I was looking for. Thank you!John"The smoke monster is just the Others doing barbecue" |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-09-10 : 08:18:22
|
| Although I must caution anyone who sees this that there are already entries with Visible="false" embedded (not at the end) and if you inadvertently add a second reference and save the file the Reporting Services service immediately dies. Once you fix the problem and save you can restart. But it does work, thanks again.John"The smoke monster is just the Others doing barbecue" |
|
|
|
|
|
|
Eliminate output types on Export Report list