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,854 questions
3 answers
One of the answers was accepted by the question author.
How to show hidden row in ssrs report
I need to show hidden row in report. How can i do it?
asked 2023-08-19T16:57:26.17+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(140.8, 13%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
Marco Dell'Oca
61
Reputation points
accepted 2024-06-27T15:11:04.7566667+00:00
Marco Dell'Oca
61
Reputation points
3 answers
One of the answers was accepted by the question author.
SQL Server Reporting Services 2019 licensing
Hello Can someone please help clarify the below for me. I know SSRS installed separately, My question is, isn´t SQL Server Reporting Service (SSRS) delivered as a part of the SQL Server Standard and Enterprise editions? Or does it require a…
asked 2022-07-27T08:08:52.157+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(153.6, 28.000000000000004%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVN%3C/text%3E%3C/svg%3E)
Vieira Nicki
36
Reputation points
answered 2024-06-27T09:41:32.61+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(265.6, 93%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
Kilimandjaro
0
Reputation points
6 answers
Best Report Tools for Blazor
My company is transitioning from legacy software that makes extensive use of Crystal Reports and we are looking for a tool compatible with Blazor. Many options come up in a Google search, but we don't have enough experience with the platform to make an…
asked 2023-02-09T02:52:54.0333333+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(220.8, 35%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
RussDFM
5
Reputation points
edited a comment 2024-06-25T19:41:14.6233333+00:00
Nishantha Hettigoda
5
Reputation points
2 answers
Unable to install SQL Server 2022 (setup.exe). Exit code (Decimal): -2147467259.The system cannot find the path specified.
Please help me solve this error. Cant install SQL Server 2022: Unable to install SQL Server 2022 (setup.exe). Exit code (Decimal): -2147467259.The system cannot find the path specified.
asked 2024-04-17T03:19:46.4966667+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(67.2, 51%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
JOANNAH MARIE ZARAGOZA
0
Reputation points
commented 2024-06-25T15:40:37.2666667+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(204.8, 57.00000000000001%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
jean carlo herrera delgado
0
Reputation points
2 answers
One of the answers was accepted by the question author.
Matrix's backgroud color
HI, I NEED A HELP I HAVE A MATRIX, AND I WOULD LIKE TO CHANGE THE BACKGROUND COLOR WHEN THE AGREGATED VALUE IS UNDER THAN 92K. I TRYED TO USER A SIMPLE SWITCH OR IIF (IN TABLIX ITS WORKS FINE), BUT IT CHANGE ALL CELLS IN THE MATRIX... HOW CAN I DO THIS…
asked 2024-06-21T16:06:29.46+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(291.2, 95%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELI%3C/text%3E%3C/svg%3E)
Luciana Iura de Oliveira Mello de Melo
25
Reputation points
commented 2024-06-25T13:32:39.04+00:00
Luciana Iura de Oliveira Mello de Melo
25
Reputation points
2 answers
One of the answers was accepted by the question author.
Steps to use Cyber Ark to manage Data Source Credentials with on Prem Power BI report server
Hello, I am getting mixed results when trying to determine if Power BI report Server can use Cyber ARK PVWA for managing Data Source account passwords. Using PVWA enables Web application to connect to a credential managed Vault to retrieve service…
asked 2024-06-21T13:27:08.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(12.8, 92%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENC%3C/text%3E%3C/svg%3E)
NORRIS, CHIP
20
Reputation points
commented 2024-06-25T11:27:26.5066667+00:00
NORRIS, CHIP
20
Reputation points
1 answer
How to show "Design a new Report" in Report Viewer tool in Microsoft Visual Studio 2022. Need help ASAP.
I already search some tutorials in youtube but i cant find anything. In my machine, i cant see the "Design a new Report" in Report viewer tool like i saw in my tutorial video that i follow in youtube. i will paste pictures so you can see it. I…
asked 2024-06-21T16:19:04.6166667+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(220.8, 17%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDM%3C/text%3E%3C/svg%3E)
Daniel Mendoza
0
Reputation points
answered 2024-06-24T06:15:31.3733333+00:00
ZoeHui-MSFT
34,756
Reputation points
2 answers
how to schedule power bi reports for email delivery?
how to schedule power bi reports for email delivery?
asked 2024-06-21T13:00:40.66+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(172.8, 59%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Anita Amick
0
Reputation points
answered 2024-06-24T01:25:53+00:00
ZoeHui-MSFT
34,756
Reputation points
4 answers
Cannot connect to SQL Database. Please contact SQL server team for further support
Hi, I'm getting below error while connecting sql server using private endpoint and AZURE IR and Active Dir authentication Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'sqlsrv-XXXX', Database:…
asked 2022-12-20T17:10:54.27+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, 80%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVY%3C/text%3E%3C/svg%3E)
Venkateswarlu Y
6
Reputation points
answered 2024-06-21T23:15:03.6666667+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, 61%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Jeevan Srikanth Nalla
0
Reputation points
1 answer
Place Rounded Border in Reporting Services
I am currently using Report Builder, and I would like to know the way to place a rounded border in the corner of a table or text box Currently it can only be squared and I would like a border like this: is it possible to do this? if possible how would…
asked 2023-06-22T05:04:18.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(118.4, 43%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Marco Tulio Chavez Maradiaga
0
Reputation points
commented 2024-06-21T18:12:45.7566667+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(284.8, 57.00000000000001%, 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)
Kathern Wilenski
0
Reputation points
2 answers
Error on report after upgrading to build 16.0.1115.92
Current environment: SSRS: 16.0.1115.92 SQL Server instance: Microsoft SQL Server 2019 (RTM-CU26) (KB5035123) - 15.0.4365.2 (X64) Enterprise Edition (64-bit) on Windows Server 2016 Datacenter 10.0 <X64> (Build 14393: ) (Hypervisor). In early May…
![](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, 15%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
3 answers
One of the answers was accepted by the question author.
Errors on some reports after upgrading to16.0.8886.1775 (SQLServerReportingServices_16.0.1115.92.exe dated 5/1)
After upgrading we get this error on multiple (not all) reports "The Hidden expression for the tablix 'table1' contains an error: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0,…
asked 2024-05-30T16:41:17.3866667+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(272, 0%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKT%3C/text%3E%3C/svg%3E)
Kehoe, Tim
20
Reputation points
commented 2024-06-21T13:29:48.24+00:00
Kehoe, Tim
20
Reputation points
2 answers
How to upgrade an eval installation of SSRS to full
I have an installation of SQL 2019 and SSRS 2019. The SSRS is an eval installation and has expired. I have the ssrs key from the installation of SQL. I have tried the modify option in Apps And Features but it is greyed out. I used the sql installation…
asked 2024-06-20T16:41:48.7+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(240, 28.000000000000004%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
PhilD
0
Reputation points
answered 2024-06-21T02:54:26.51+00:00
ZoeHui-MSFT
34,756
Reputation points
2 answers
Setting up SQL Auth for Azure SQL DB via SSRS
Hello, I am referring the below MSFT doc : https://learn.microsoft.com/en-us/sql/reporting-services/report-data/sql-azure-connection-type-ssrs?view=sql-server-ver16 wherein confused with the below statement: SQL Database supports only SQL Server…
asked 2024-06-10T08:28:06.8433333+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(140.8, 39%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Rohit
226
Reputation points
commented 2024-06-19T06:53:30.39+00:00
ZoeHui-MSFT
34,756
Reputation points
3 answers
Highlight cell or row in SSRS Tablix
Hello, I have a Tablix with multiple temperatures values for a patient taken in a day. Was wondering if I can highlight the row/cell with the highest temperature, in this case 101.5 Let me know if this can achieve via expression. Thanks, Ali.
asked 2024-06-12T02:04:52.5266667+00:00
Ali Ahad
111
Reputation points
commented 2024-06-19T06:46:02.1766667+00:00
ZoeHui-MSFT
34,756
Reputation points
1 answer
One of the answers was accepted by the question author.
Upgrading SQL Server having multiple instances
Our SQL is of 2014 RTM. Planned to upgrade it to 2014 SP3 in the first place later to 2022. And our SQL Server do have extra 2 instances as being used for replication DBs. I saw rolling upgrade as solution to HA environment. But nowhere could I see…
asked 2024-06-12T06:56:26.71+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(70.4, 75%, 16%)' 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)
Radhai Krish
191
Reputation points
accepted 2024-06-17T05:29:07.57+00:00
Radhai Krish
191
Reputation points
2 answers
One of the answers was accepted by the question author.
Need to filter data in Tablix
I have created a tablix where I need to filter the data, I have used the following expression in the Tablix properties and I am not getting the expected results IIf(IsNothing(field1.Value) OR IsNothing(field2.Value), 1, 0) The above formula is…
2 answers
One of the answers was accepted by the question author.
Finding SQL Server 2022 Web Edition License Key for SSRS
I am presently licensing SQL Server 2022 Web Edition on an SPLA license on a hosted cloud server. The hosting partner does not presently offer a cloud server image for SQL Server 2022 which includes Reporting Services. I understand that a SSRS license…
asked 2023-08-28T13:23:49.4966667+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(208, 86%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETB%3C/text%3E%3C/svg%3E)
Tom Bixby
20
Reputation points
commented 2024-06-11T17:31:15.26+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(224.00000000000003, 89%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVI%3C/text%3E%3C/svg%3E)
Vic in NYC
0
Reputation points
0 answers
Hey team, I am using uaa login url for custom authentication while accessing web reports.
The problem is that when I am using windows authentication, I am able to see the cookie for the ServiceState API, but if I configure it to use the custom authentication which is by using uaa as mode of authentication mechanism I am not able to see the…
asked 2024-06-11T10:07:54.39+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(198.4, 96%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vuppala, Sahit
0
Reputation points
commented 2024-06-11T10:11:17.6933333+00:00
Vuppala, Sahit
0
Reputation points
1 answer
SRSS REST API get the content of the Report
Hello, I am new to SRSS and we were introduced REST API being available. I am confused about the swagger/OpenAPI document with regards to this endpoint /Reports({{Id}})/Content/$value Here are my questions: What does this return? Is this the content…
asked 2024-06-06T02:08:04.9866667+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(137.6, 95%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Aileen Sable
0
Reputation points
commented 2024-06-11T02:20:30.4966667+00:00
ZoeHui-MSFT
34,756
Reputation points