This was posted just to share an experience of tackling a problem we encountered when we needed to connect an SSRS Server 2016 to an older SQL Server database (Windows Server 2008 R2) and what steps we took to troubleshoot the issue. After all the reports were migrated to the new SSRS server, upon creating a new Data Source, I got an error message something along the line to enter the user id … [Read more...]
SSRS Doesn’t Render Reports in Chrome and Safari
Just earlier today I encountered an issue where SSRS reports that works fine in IE and FireFox were showing blank in Chrome and Safari and interestingly enough the common denominator for these two browsers are that they are based on WebKit. Fortunately this is a known issue and someone already came up with a working solution by adding a javascript snippet in ReportingServices.js file under this … [Read more...]
A Quick Way to Hide TopBar Navigation Link in SSRS
This is just a quick hack to hide the breadcrumb and navigation links in SSRS. Under default installation, locate ReportingServices.css file under the following path: C:\Program Files\Microsoft SQL Server\MSRS10_50\Reporting Services\ReportManager\Styles This path is for SSRS version 2008 R2. If you use a different version of SSRS, then you need to replace the path MSRS10_50 to … [Read more...]
How to Create SSRS Report with Dynamic Query and Multi-Value Parameters
Continuing from the last SSRS tutorial on creating a SQL Server Reporting Services report with dynamic query and parameters, one caveat about the report is that it only works for one record search at a time. While this may be fine for a customer who needs to search a particular record specific to the person, this is not generally useful for office use, where one person may need to search … [Read more...]
How to Create SSRS Report with Dynamic Query and Parameters
Requirement: Produce an SSRS report the is searchable by the values of any fields in the report as shown below: This type of report can be created using parameters input into a dynamic query in a stored procedure. We'll use employee records from AdventureWorks database to demonstrate the report setup so it can be searchable by a search key and a search string as its value. Create Stored … [Read more...]