The posts about SSRS that were written for this blog can be found below. For quick reference only.
SSRS – Refresh the report at a set time
I created dashboards using SSRS that include graphs, key performance indicators, and other business KPIs in my previous organizations. Wide-screen televisions throughout the call center, back office, and management office showed them during business hours. There was a requirement to refresh the data every 5 minutes. Let’s talk about it in this article. Simply entering…
SSRS Error – Something went wrong
The following error message has occasionally been reported by SSRS users who are trying to generate the report. Something went wrong. please try again later. The error message doesn’t make the issue clear. However, the common reasons and the solution could be – The account that you set up doesn’t have access to the machine’s administrative…
SSRS Error – An error occurred during local report processing
The following error message has occasionally been reported by SSRS users who are trying to generate the report. An error occurred during local report processing. An error has occurred during report processing. Cannot create a connection to data source ‘xyz’. You have specified integrated security or credentials in the connection string for the data source,…
SSRS Error – cannot open a connection to the report server
The following error message has occasionally been reported by SSRS users who browse the online portal after installing it. The report server cannot open a connection to the report server database. The error message makes the issue quite clear. It claims that the SSRS service is unable to connect to the “report server” database that…
SSRS – Highlight cell color based on values
SSDT is a cutting-edge development tool for creating relational databases in SQL Server, databases in Azure SQL, data models in Analysis Services (AS), packages in Integration Services (IS), and reports in Reporting Services (RS). Yes, it’s one of my favorite tools, and I’ve worked on it with great pleasure for many years while producing reports…
Types of Reports in SSRS
Using SQL Server reporting services, you may build various reports, render them in various formats, plan the report-generating process, schedule the delivery of the report to the recipients, and more. In this article, you’ll learn what kinds of reports you may produce using SSRS to compile and deliver. Parameterized reports: For the purpose of processing…
SSRS Presentation (PPT)
Here is a power-point presentation on SSRS which I recently used to give a demonstration to the students. Notes Slide-1:Microsoft SQL Server Reporting Services is a server-based report-generating software system that allows administrators to share reports with users or integrate the reports into internal or web applications based on access permissions and user groups. It…
SSRS Architecture
Microsoft SQL Server Reporting Services is a server-based report-generating software system that allows administrators to share reports with users or integrate the reports into internal or web applications based on access permissions and user groups. It is used as a solution to build custom reports from a variety of data sources, such as Flat files,…
SSRS – Allow multiple values in the parameter
Users may occasionally want to choose numerous values from a list or a dropdown menu. Those many parameters should be taken into consideration while displaying the report or the page’s content. You’ll learn how to create a report with numerous values that users can choose from the provided parameters, in this post. Allow Multiple Values:…
Display Everything for an SSRS Report on a Single Page
At times, users want the entire content of dashboards or reports to be visible on a single page. The report, however, spans numerous pages if the page’s contents are greater than what can really fit on one page. Set the Height in InteractiveSize attribute of the report to zero to render the entire contents of…
SSRS Report Header – Display Report Criteria
Some reports can require the proper headers and footers to let readers know the selection criteria and the date the report was written. You can learn how to supply the parameters that have been chosen to generate the report, in this post. Once a text box has been placed, right-click it, choose expression, and then…
SSRS Dashboard Auto Refresh
The steps listed below can be used if you’ve developed a dashboard using SSRS and want the report to be automatically refreshed after a certain amount of time. Go to the report properties page. Scroll down to find the AutoRefresh property. It will have 0 as a default value which denotes that the report should…
SSRS Report Generation Date
The report generated date is one of the crucial headers or footers that must be included once the report has been designed. Once a text box has been placed, right-click it, choose expression, and then type one of the following expressions. =FORMAT(Cdate(today), “yyyy-MM-dd”) =FORMAT(Cdate(today), “MM-dd-yyyy”) =FORMAT(Cdate(today), “dd-MM-yyyy”) =Format(Now(), “dd/MM/yyyy hh:mm tt”) =”Report Generation Date: “…
Report Generation Date in SSRS
In addition to the data, there are a few more elements that should be in the report. “Report Generation Date” is among them. This will inform others when the report that was shared is being prepared. Take a text box in the report’s data section and enter the following expression. =”Report Generated Date: ” &…
SQL Server Reporting Services (SSRS) Configuration
Following the previous piece about SSRS Installation, this article will take us through the configuration of SQL Server Reporting Services Configuration. Step 1You can either click on “Configure Report Server” at the end of your SSRS installation or simply open “Report Server Configuration Manager” from the Start menu. Step 2You will select the SQL server on which…
SQL Server Reporting Services (SSRS) Installation
In this article we are going to learn how to install SQL Server Reporting Services. To begin with, we may first define what SQL Server Reporting Services means? SQL Server Reporting Services commonly known as SSRS, is basically a collection of on-premises tools and services for creation, deployment and management of reports. These reports can…
It’s all about SSRS
This is a collection of articles that will explain what SSRS is, how it works, and how to install and configure reporting services either locally on your computer or remotely on a server. What is SSRS? Microsoft SQL Server Reporting Services is a server-based report-generating software system that allows administrators to share reports with users or…
Big Data & SQL 