Once you’ve got a healthy collections of reports hosted in Reporting Services there’s usually a requirement to deliver these out to end users via different methods such as via email, or in our example to a file share. Delivering to a file share requires account credentials which would have permissions to the specified share. We […]
Category: SSRS
Multi-Value Parameters in Reporting Services
Last time out we looked at how to add parameters in a Reporting Services report. In there we looked at adding a parameter where only a single value was selected by the user. We also have the option to allow selection of multiple values for parameters, for example the selection of multiple sales regions or […]
Adding Parameters in Reporting Services
Adding parameters into a report or dashboard you’re publishing with Reporting Services can add that extra shine. It allows the end users to tailor their experience and can allow for the same report to meet different needs. This may require a little extra effort by the developer if you’re looking to go and retrospectively update […]
Reporting Services Execution Logs
Within the Reporting Services tool there’s the ability to store execution logs when a report is ran. This can be particularly useful from an auditing perspective whether that be to see if reports are no longer in use, or if they contain some degree of sensitive information and want to understand who may have accessed […]
Reporting Services Lookup Function
Reporting Services can be a useful tool to surface details for end users but sometimes you get a request to tag on some other data which isn’t contained within the same database or even environment. You could use cross database queries or linked servers respectively to get this data but it ends up building in […]