5 thoughts on “SQL Server Pro Article: Custom Programming to Enhance SSRS Reports

  1. I am trying to devise a way to dynamically add category(y-axis) striplines, so I can empower users to add a stripline to a chart to tell its story (i.e. when methodologies change, significant events happen, etc…) based on a dataset that queries a StripLineProperties table. Im using SSRS 2012, but I can’t for the life of me figure out the correct Assembly and Class entry to begin the custom code. Have you ever used the ‘System.Web.DataVisualization’ assembly in SSRS?

  2. Paul, we have built some 2008 R2 SSRS reports and have run into the “No ActiveX controls in Firefox” issue with no Print button showing for the reports. I have located a plugin call ff-activex-host but not much else. Do you have any hints/suggestions on how my Firefox and Chrome users can print our SSRS reports?

    1. Wayne, I’ve seen several programmatic approaches for printing reports. You can write a simple application that uses the RS web service to save a report or selected reports to a folder on the server in PDF or image format. We built a whole custom report menu app for a customer that included this capability. There are several different commercial apps or free script-based solutions that will look for files in a folder and then print them server-side. I’ve put some feelers out and will reply if I can find something more concrete.

  3. Gary, this question comes up a lot and unfortunately there is no way to parameterize a shared data source connection string. The reason is that parameters are defined in a report and a shared data source runs at a level above the report. If you switch to using embedded data sources (contrary to “best practice”, I know), you can then build the connection string as an expression using parameters.

  4. Paul

    Your timing is excellent as usual as I want to use paramitorized data connection strings to create shared data sources. Can then be done in 2008 R2 or is this a new feature?

Leave a Reply