SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,799 questions
3 answers
One of the answers was accepted by the question author.
Stored Procedures or SQL query which one is better for SSRS report Creation
Hi Team, which one is better to SSRS report Creation as a source query , Stored Procedures or SQL query and why ?
asked 2021-06-21T06:41:17.307+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 0%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBN%3C/text%3E%3C/svg%3E)
Bala Narasimha Challa
466
Reputation points
answered 2024-04-03T21:08:16.2233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 23%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKW%3C/text%3E%3C/svg%3E)
Ken Wilson
0
Reputation points
2 answers
Mangement Tools connection
Hi Team, I allow port 80 to the server so that PS can work. But security team concern in why we are not using default port By default PowerShell will use the following ports for communication (They are the same ports as WinRM) TCP/5985 = HTTP …
asked 2024-04-01T08:34:09.5166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 65%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Muhammad Safeer Saqib
1
Reputation point
answered 2024-04-03T02:26:12.0633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 11%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJZ%3C/text%3E%3C/svg%3E)
Jing Zhou
2,085
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
How to publish/Deploy a SSRS over the web and access to the page from another computer?
I'm using SQL Server SP1 2012 Standard Edition, and I'm using the SSRS web service, I have the Report Manager URL and Web Service URL in http://(namecomputer1)/Reports and http://(namecomputer1)/ReportServer respectively. I can access to both pages and…
asked 2024-03-27T17:23:16.84+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 43%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
JIMMY ALEXANDER MUNOZ CHAVES
40
Reputation points
accepted 2024-04-03T02:15:33.8566667+00:00
JIMMY ALEXANDER MUNOZ CHAVES
40
Reputation points
0 answers
asked 2024-04-02T11:04:19.1933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 18%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETG%3C/text%3E%3C/svg%3E)
T Gamage
0
Reputation points
commented 2024-04-02T21:05:37.81+00:00
Erland Sommarskog
101K
Reputation points MVP
1 answer
Report Server "Could not save changes. Something went wrong. Please try again later".
If I edit the Description field on a Data Set, I get this error when I click Apply. If I click Cancel then return to the Data Set, my changes have been applied, despite the error message. How do I get rid of this annoying error message? A search brought…
1 answer
Can't get SendGrid to work with SSRS 2012 and SMTP
I have been doing a lot of online searching to find an answer, but I can't find anything substantial. I am trying to configure SSRS 2012 to use SMTP with SendGrid. All that I am finding says that I need to go into Reporting Services Configuration…
asked 2024-03-29T21:04:51.5466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 66%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Scott Klein
141
Reputation points
answered 2024-04-01T02:54:49.2766667+00:00
ZoeHui-MSFT
32,736
Reputation points
1 answer
Timeout issue for SSRS report from Application Service
Researching/debugging a problem with an Azure Application Service getting an error when making a call to SSRS with a larger resultset. The error from the SSRS service error log is as follows: ERROR: Failed in BaseWorkerRequest::SendHttpResponse(bool),…
asked 2024-03-27T21:41:24.1166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 15%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Steve Valente
0
Reputation points
commented 2024-03-29T15:56:39.37+00:00
Steve Valente
0
Reputation points
1 answer
sql server 2022 setup encountered a failure while running job updateresult
Summary.txtDetail_LandingPage.txt
asked 2024-03-21T20:31:59.3566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBT%3C/text%3E%3C/svg%3E)
BIPIN THAPA
0
Reputation points
commented 2024-03-29T09:43:59.23+00:00
LucyChen-MSFT
885
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
SSRS failed
The error said "Scaleout deployment" is not supported in this edition of Reporting Services.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 96%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
In SSRS 2019 Can you change the background color of the Parameters pane?
In SSRS 2019 Can you change the background color of the Parameters pane? It is defaulted to white. I have been unable to find anything about it in the Branding or the SSRS Report Builder information.
asked 2024-03-28T13:25:01.0966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 57.00000000000001%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENM%3C/text%3E%3C/svg%3E)
Newman, Michael
20
Reputation points
accepted 2024-03-28T23:07:17.35+00:00
Newman, Michael
20
Reputation points
1 answer
The MSSQLSERVER service terminated unexpectedly
Dear All SQL expert, Do you know what is the case that make The MSSQLSERVER service terminated unexpectedly? Recently, The SQL server (MSSQLSERVER) and SQL Server Agent are stopped automatically during running import data to sql server. We are using…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 44%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
1 answer
SSRS Report ignoring the Data Source credentials it is given, while other reports use the credentials properly
I have an SSRS report deployed that works locally but not on the SSRS site. It is using a shared Data Source that has 40+ other reports using it as well. The issue is this report returns the following error: Query execution failed for dataset…
asked 2024-03-27T19:06:33.7833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 28.999999999999996%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Shane Kelley
0
Reputation points
answered 2024-03-28T02:50:25.7533333+00:00
ZoeHui-MSFT
32,736
Reputation points
1 answer
One of the answers was accepted by the question author.
Filter Tablix with LIKE and OR
With SSRS, I need to filter a tablix with a LIKE and an OR condition. For example: WHERE MedCampaign LIKE AffCPD_1224* OR MedCampaign LIKE AffCPD_1225* I tried the below suggestion I found, but this just returns the entire dataset. How should I go about…
asked 2023-08-22T16:15:47.6533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 23%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
Dom
751
Reputation points
commented 2024-03-27T18:25:08.6766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 32%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAV%3C/text%3E%3C/svg%3E)
Alexandre Vieira (DIF)
0
Reputation points
1 answer
Unable to install SQL Server (setup.exe). Exit code (Decimal): -2061893607;Error description: could not find the database engine startup handle
I am trying to install sql server 2022 and I keep getting the same error: Unable to install SQL Server (setup.exe). Exit code (Decimal): -2061893607;Error description: could not find the database engine startup handle This is the error log that I…
asked 2024-03-26T18:31:35.01+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 43%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJN%3C/text%3E%3C/svg%3E)
Jawahiir Nabhan
0
Reputation points
commented 2024-03-27T05:06:09.53+00:00
Jawahiir Nabhan
0
Reputation points
3 answers
has inline function got any catch?
hi, I heard many people saying "functions are denounced in tsql" is there any catch? q1) need to know what are the cases where we should not use? q2) should we avoid scaler functions also? q3) should we avoid scaler functions if we have to…
asked 2024-03-11T05:57:35.8533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 42%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Rajesh Kumar Yadav
0
Reputation points
answered 2024-03-26T17:11:52.99+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com)
55,686
Reputation points
2 answers
.NET 6.0 framwork SSRS Report Viewer.
Hi Team, I am using .Net 6.0 farmwork with MVC. Not able to bind Report viewer in razor pages. .Net 6.0 not supporting old packages and web forms. How to bind SSRS rdl in .Net 6.0 MVC framework. Kindly provide a solution with an example source…
asked 2023-09-05T14:43:03.99+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 17%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
santhosh shekar
15
Reputation points
commented 2024-03-26T05:49:20.52+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 13%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEE%3C/text%3E%3C/svg%3E)
esam elzain
0
Reputation points
8 answers
One of the answers was accepted by the question author.
SSRS Count rows in colmns to get the percentage
Hi I could do with some help in getting find the expression that will, Count the total number of Shipment_ID's in the column / by the number of 0 in GOOD_BAD_TIME * 100. to calculate the percentage. (Delivered on Time) Aim is to calculate the…
asked 2021-03-18T10:47:21.42+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 31%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECW%3C/text%3E%3C/svg%3E)
Clive Wightman
126
Reputation points
accepted 2024-03-22T09:44:24.1+00:00
Clive Wightman
126
Reputation points
3 answers
One of the answers was accepted by the question author.
SSRS Sub Reports Not passing Paramteres
HI I'm Running SQL Server 2019, with Reporting Services. I'm creating a report that only has 4 sub reports within it. When I run the sub reports indiviually they work fine. When I run the report selecting multiple sub reports it fails, 2…
asked 2022-11-21T07:57:20.98+00:00
Clive Wightman
126
Reputation points
accepted 2024-03-22T09:43:27.2833333+00:00
Clive Wightman
126
Reputation points
1 answer
One of the answers was accepted by the question author.
SSRS with Database Sizes
Hi I'm trying to create a report that will show the size of the databases, but as we have 32GB available on the Azure Managed instance I would like to have a chart that shows the % we have used, could anyone help with this please. I'm gathering the…
asked 2024-01-09T10:25:14.22+00:00
Clive Wightman
126
Reputation points
accepted 2024-03-22T09:42:55.2933333+00:00
Clive Wightman
126
Reputation points
2 answers
HSTS for Default page on SSRS
Hi, Our SSRS server is failing a vulnerability (Nessus) scan for HSTS. I have been able to add the SQL CustomHeader for HSTS and I can confirm this is working. SQL CustomHeader XML string…
asked 2024-03-15T03:39:19.55+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 38%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECG%3C/text%3E%3C/svg%3E)
Craig Garland
286
Reputation points
answered 2024-03-22T08:39:02+00:00
ZoeHui-MSFT
32,736
Reputation points