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 […]
Configuring SSIS projects or packages can necessitate parametering information which may include sensitive values such as authentication details. Parameters are stored as plain text in the database by default. We’ll demonstrate how to protect these values using Sensitive parameters. The problem With a SSIS project deployed, our parameters are stored in plain text in the […]
Last week we looked at project parameters in SSIS to help us configure our projects. This can help us to tailor the project to the package its in for example. Here we’ll look at using Configurations within Visual Studio to manage those parameters for multiple environments. Configuring parameters We’ll start out with the project used last time […]
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 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 […]
Andy Brownsword 