Categories
SSRS

Review Security Drift in Reporting Services

Reporting Services deployments aren’t exactly the latest fashion, so any you stumble upon are probably a little dated and in need of TLC. One place to review would be the security. Security in SSRS comes in two flavours: Item level roles are what we’re digging into here. Before we start, it’s worth defining a simple […]

Categories
Power BI

Fixing and Customising Parameter Display in Power BI Paginated Reports

Parameters in Paginated reports allow for us to tailor report contents based on user selected criteria. These were inherited from Reporting Services as a precursor to the slicers and filters in Power BI reports. Coming from a Reporting Services background I have a soft spot for pre-defined paginated reports. However these parameters can sometimes get […]

Categories
SSRS

Creating a File Share Account in Reporting Services

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 […]

Categories
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 […]

Categories
SSRS

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 […]