Thursday, April 30, 2015

Rendering Options for Report Specific

Hi GVRSPK,

Per my understanding that you want to get different rendering format in the rendering options for different reports when you are creating the subscription.

I have tested on my local environment and we can achieve this by adding some jquery code in the SubscriptionProperties.aspx file which path like:C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager\Pages

Details information below for your reference:

  1. Open the SubscriptionProperties.aspx file and add below code at the last:

<script src="http://ift.tt/KxYiSw; type="text/javascript"></script> <script type="text/javascript"> $(function() { var result = new RegExp('[\?&]ItemPath=([^&#]*)').exec(window.location.href)[1]; var reportName = result.split('%2f')[result.split('%2f').length - 1]; //alert(reportName); if (reportName == "Report1") { $("#RenderFormatID option[value='XML']").remove();//Remove XML render format }
if (reportName == "Report2") {
$("#RenderFormatID option[value='EXCEL']").remove();//Remove EXCEL render format
} }); </script>

You can find all the values in the option tag in the source code as below:

Once the code has been added, you can see the change immediately and if you want to roll back to default setting, just remove the code in the SubscriptionProperties.aspx file.

If you still have any problem, please feel free to ask.

Regards,
Vicky Liu


Vicky Liu
TechNet Community Support


No comments:

Post a Comment