There is a great post by Haroon Choudry on LinkedIn, talking about whether SSRS’s days are numbered. In particular, is the use of PowerBI overshadowing the need for SSRS – and where do the respective data tools live, and where are they headed? These are clearly very different tools, and clearly very different applications. Or are they? It’s interesting that […]
Tag: ssrs
Tips for using SQL Server 2019 Reporting Services
Tips for using SQL Server 2019 Reporting Services SQL Server 2019 Reporting Services (SSRS) is a server-based reporting platform that provides comprehensive reporting functionality. You can download SSRS 2019 at here: https://www.microsoft.com/en-us/download/details.aspx?id=100122 Consider hosting a database catalog used for SSRS in an Azure SQL Managed Instance. In SSRS 2019 you can host a database catalog used for SSRS in an...
Troubleshooting SQL Server 2017 Reporting Services
Troubleshooting SQL Server 2017 Reporting Services If you have problems with SQL Server 2017 Reporting Services (SSRS 2017), review this troubleshooting checklist to find potential solutions. 1. Check the SSRS logs if you have problem with Reporting Services. SSRS records many internal and external events to log files that record data about specific reports, debugging information, HTTP requests and responses,...
Troubleshooting problems with connection to SQL Server 2016
Troubleshooting problems with connection to SQL Server 2016 If you have problems with connection to SQL Server 2016, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many SQL Server 2016 connection bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the...
Troubleshooting Upgrading to SQL Server 2016
Troubleshooting Upgrading to SQL Server 2016 Should you have problems with upgrading to SQL Server 2016, review this troubleshooting checklist to find potential solutions. 1. Check the hardware requirements. To upgrade to SQL Server 2016, you should have the following hardware: – Intel or compatible platform with processor speed: 1.4 GHz minimum for a 64-bit x64 2.0 GHz or faster...
Troubleshooting SQL Server 2016 Reporting Services
Troubleshooting SQL Server 2016 Reporting Services If you have problems with SQL Server 2016 Reporting Services (SSRS 2016), review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many SQL Server 2016 Reporting Services bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At...
Developing Report Models – (Part 1)
Developing Report Models – (Part 1) Author: Basit A. Farooq A report model is a metadata description of a data source. It contains a business model of a data, a physical model of the underlying database, and a mapping between the two. The business model, also known as a semantic model, describes the data by using familiar business names, usually...
Guidelines and Best Practices for developing and implementing a Reporting Solution with SQL Server 2014 – (Part 2)
Guidelines and Best Practices for developing and implementing a Reporting Solution with SQL Server 2014 – (Part 2) Author: Basit A. Farooq Editor’s Note: In the first of this three part article series, I discussed the considerations for creating reports. In this part, I will talk about the guidelines and best practices for implementing data sources and report layouts. Guidelines...
Getting Started with SSRS
Pro-Center Video Programming for IT Professionals
SharePoint and SSRS Integration: The Hows and Whys
Pro-Center Video Programming for IT Professionals