2,965 questions with SQL Server Reporting Services tags

Sort by: Updated
1 answer

SSRS2022 Custom Header Problem

Hi Guys, I found SSRS2022 16.0.1116.12 Custom Headers…

SQL Server Reporting Services
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,965 questions
asked Jan 7, 2025, 2:59 AM
Wilson Shen 0 Reputation points
answered Jan 7, 2025, 6:38 AM
ZoeHui-MSFT 39,271 Reputation points
1 answer

SSRS Bing Maps Error: "The underlying connection was closed"

The SSRS report's map visual displays an error message. Although the Point Layer data region is showing correctly, Bing Maps encounters an error. Details: Report Server Version: 15.0.1102.675 TLS 1.2 Server: Enabled TLS 1.2 Client: Enabled …

SQL Server Reporting Services
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,965 questions
Windows Maps
Windows Maps
A Microsoft app that provides voice navigation and turn-by-turn driving, transit, and walking directions.
258 questions
asked Jan 3, 2025, 12:56 PM
Jayamurali Ganeshan 0 Reputation points
answered Jan 6, 2025, 2:22 AM
ZoeHui-MSFT 39,271 Reputation points
1 answer

When will the Dynamics 365, version 9.0 Report Authoring Extension be available for vs2022?

When will the Dynamics 365, version 9.0 Report Authoring Extension be available for vs2022? Up untill now the latest version it is available for is vs2019.

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,329 questions
SQL Server Reporting Services
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,965 questions
asked Jan 2, 2025, 2:51 PM
victor sijtsma 0 Reputation points
answered Jan 3, 2025, 3:13 AM
ZoeHui-MSFT 39,271 Reputation points
1 answer

SSRS 2022 does not show barcode when printing to PDF

We are using SSRS 2022. We have a report that has a barcode on it using BCC3OF9N.TTF. The barcode shows in preview mode when we run the report, but when it prints to PDF or exports to PDF the barcode does not show. I have verified the barcode is on the…

SQL Server Reporting Services
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,965 questions
asked Dec 30, 2024, 11:24 PM
DoveConnieDES-3786 1 Reputation point
answered Dec 31, 2024, 2:13 AM
ZoeHui-MSFT 39,271 Reputation points
2 answers

How to connect the Powerbi Report Server to sqlserver with "force encryption" enabled

Dear Support: we are trying to setup the PowerBI report server on our local environment, and according to our security policy, we are forced to activate the "force encryption" in SQL server, which makes us not able to connect to database…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,254 questions
SQL Server Reporting Services
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,965 questions
asked Dec 26, 2024, 11:09 AM
Sun, Dong Wei (IN IT CN RS) 0 Reputation points
commented Dec 27, 2024, 6:19 AM
Sun, Dong Wei (IN IT CN RS) 0 Reputation points
1 answer

How to display different percent in report

I have set the percentage as 5.2%, when it is 5%, it will show as 5.0%. I want to remove the decimal when it comes with whole value.

SQL Server Reporting Services
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,965 questions
asked Dec 24, 2024, 6:39 AM
Yun 40 Reputation points
commented Dec 26, 2024, 2:34 AM
ZoeHui-MSFT 39,271 Reputation points
1 answer One of the answers was accepted by the question author.

Changing the x-axis properties in a SSRS chart does not work when there are negative values.

I want to emphasize the x-axis of a chart in SSRS by increasing its point size. When there are negative values, the axis that shows the emphasis is not the zero value as shown in the picture. The zero line is the one I want to be dark. The labels at the…

SQL Server Reporting Services
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,965 questions
asked Dec 23, 2024, 8:57 PM
Khanna 20 Reputation points
edited the question Dec 24, 2024, 7:11 PM
Khanna 20 Reputation points
1 answer

Using Temporary Tables and Re-Using Temporary Tables in a SSRS Report

So we need to standardize Member Eligibility by using a SQL Server Stored Procedure that will be called, Executed by our Patient/Member SSRS Reports. The SQL Server Stored Procedure currently uses a Global Temporary Table to pass its result set back to…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,254 questions
SQL Server Reporting Services
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,965 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,672 questions
asked Nov 7, 2024, 1:49 PM
Bobby P 231 Reputation points
answered Dec 24, 2024, 3:34 AM
Naveen Kumar M 75 Reputation points
1 answer

SSRS 2019 Custom Form Based Authentication: An error occurred when invoking the authorization extension

Hi, I am upgrading SSRS 2014 to 2019 and custom form based authentication is implemented with SSRS 2014. I followed the steps https://github.com/microsoft/Reporting-Services/tree/master/CustomSecuritySample and implemented same for SSRS 2019. While Web…

SQL Server Reporting Services
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,965 questions
asked Aug 26, 2023, 9:12 AM
31297832 0 Reputation points
edited the question Dec 23, 2024, 8:28 PM
TP 101K Reputation points
1 answer One of the answers was accepted by the question author.

Go to url does not work

Does anyone kown why go to url doesn't work in my report. I'm using "http://www.test.com" in the expression. But it does not go to the url when clicking.

SQL Server Reporting Services
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,965 questions
asked Dec 23, 2024, 7:27 AM
Yun 40 Reputation points
accepted Dec 23, 2024, 9:57 AM
Yun 40 Reputation points
1 answer

SSRS no longer sorts History snapshots

WE have several reports in Microsoft SQL Server Reporting Services that are on a snapshot schedule. The history snapshots no longer view sorted by created and Created can no longer be clicked to force a sorting. Is there a way to default a sort on the…

SQL Server Reporting Services
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,965 questions
asked Dec 20, 2024, 2:00 PM
Claudia Rodrigues 0 Reputation points
answered Dec 23, 2024, 3:08 AM
ZoeHui-MSFT 39,271 Reputation points
2 answers

Access to on prem reporting services 2019 path issues when coming through app proxy URL

I have a on prem reporting site setup in ssrs 2019. when I access the site through an app proxy, we put the entire URL to /reports. we can successfully connect and display the main reporting pages fine, however when we try to open a report, its trying…

SQL Server Reporting Services
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,965 questions
asked Dec 19, 2024, 3:43 PM
Michael Michaud 1 Reputation point
answered Dec 20, 2024, 3:28 AM
ZoeHui-MSFT 39,271 Reputation points
2 answers

how to solve this problem, please tell me

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,254 questions
SQL Server Reporting Services
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,965 questions
asked Dec 17, 2024, 7:35 AM
Nguyễn Ánh Dương 0 Reputation points
commented Dec 19, 2024, 9:43 PM
Erland Sommarskog 114.9K Reputation points MVP
3 answers

SSRS error : "Invalid length parameter passed to the LEFT or SUBSTRING function."

Hello everyone, I'm facing an issue with a simple Query, that works fine on SQL Server and also on SSRS. In my Select there's a column with this structure "BANKNAME - ServiceName" (for Example: "DEUTCHEBANK - CustomerRetail"). I…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,254 questions
SQL Server Reporting Services
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,965 questions
asked Apr 4, 2023, 3:43 PM
Marco Onnis 1 Reputation point
commented Dec 19, 2024, 9:30 PM
Kenneth Goodson 0 Reputation points
1 answer

When multiple SSRS API try to access the same parent folder, get the folder does not exist error for one call, another call success, how to manage this bottle neck.

I am using report server api to access the rdl using powershell script , to upload the rdl files The below api format I am using in the script , https://{dnsname}/Reports/api/v2.0/Folders(Path='/Parentfolder/subfolder1/subfolder2/subfolder3') eg**:…

SQL Server Reporting Services
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,965 questions
asked Dec 18, 2024, 9:41 AM
Yuvaraj Duraisamy 0 Reputation points
commented Dec 19, 2024, 7:48 AM
Yuvaraj Duraisamy 0 Reputation points
1 answer

ASP.NET session has expired or could not be found (unable to find the solution) - SSRS Report

unable to find out the solution we have tried 2 things but there was no ouput: We have tried to extend the session time out to 30mins Tried to scale up the Azure speed when this error occurs Attached Screenshot for reference, kindly assist for the…

ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,559 questions
SQL Server Reporting Services
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,965 questions
asked Dec 18, 2024, 2:24 PM
Puneet Dasari 20 Reputation points
edited the question Dec 19, 2024, 3:25 AM
RDash 2,335 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

Sign in fail when open report

Im running a report on my server, and the error occurred said sign in failed for user xxx

SQL Server Reporting Services
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,965 questions
asked Dec 17, 2024, 7:50 AM
Yun 40 Reputation points
accepted Dec 17, 2024, 9:23 AM
Yun 40 Reputation points
2 answers

&rc:Toolbar=False not loading embedded images in SSRS 2022

Adding &rc:Toolbar=False to the url hides the Toolbar, however it also makes the embedded images disappear. url: ...&rs:Command=Render&rs:Embed=true&rs:Format=HTML4.0&rc:Toolbar=false Similar issue is reported as 'fixed' in Release…

SQL Server Reporting Services
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,965 questions
asked Aug 23, 2024, 1:54 PM
Pawel Musial 5 Reputation points
answered Dec 16, 2024, 7:48 PM
Chris Polito 0 Reputation points
5 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:…

SQL Server Reporting Services
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,965 questions
asked Dec 20, 2022, 5:10 PM
Venkateswarlu Y 6 Reputation points
commented Dec 13, 2024, 10:33 PM
Revathi Sai Durgam 0 Reputation points
2 answers

The permissions granted to user 'domain\user' are insufficient for performing this operation. (rsAccessDenied)

Hi, End user is getting The permissions granted to user 'Domain\User' are insufficient for performing this operation. (rsAccessDenied) error when they drill down from the main report (YTD Spending). The main report is a matrix report which collects…

SQL Server Reporting Services
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,965 questions
asked Jun 27, 2021, 2:30 PM
Brandon Ho 376 Reputation points
commented Dec 12, 2024, 7:20 PM
Wisniewski, Maria 0 Reputation points