2,960 questions with SQL Server Reporting Services tags

Sort by: Updated
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,960 questions
asked 2024-12-23T20:57:26.7166667+00:00
Khanna 0 Reputation points
accepted 2024-12-24T14:57:08.83+00:00
Khanna 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,960 questions
asked 2024-12-24T06:39:08.7633333+00:00
Yun 20 Reputation points
answered 2024-12-24T08:17:16.3433333+00:00
ZoeHui-MSFT 38,871 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,213 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,960 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,670 questions
asked 2024-11-07T13:49:08.8166667+00:00
Bobby P 231 Reputation points
answered 2024-12-24T03:34:42.0033333+00:00
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,960 questions
asked 2023-08-26T09:12:45.4966667+00:00
31297832 0 Reputation points
edited the question 2024-12-23T20:28:16.1566667+00:00
TP 100.9K 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,960 questions
asked 2024-12-23T07:27:35.1666667+00:00
Yun 20 Reputation points
accepted 2024-12-23T09:57:10.52+00:00
Yun 20 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,960 questions
asked 2024-12-20T14:00:22.68+00:00
Claudia Rodrigues 0 Reputation points
answered 2024-12-23T03:08:59.2533333+00:00
ZoeHui-MSFT 38,871 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,960 questions
asked 2024-12-19T15:43:06.9333333+00:00
Michael Michaud 1 Reputation point
answered 2024-12-20T03:28:30.2866667+00:00
ZoeHui-MSFT 38,871 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,213 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,960 questions
asked 2024-12-17T07:35:02.24+00:00
Nguyễn Ánh Dương 0 Reputation points
commented 2024-12-19T21:43:37.7933333+00:00
Erland Sommarskog 114.4K 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,213 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,960 questions
asked 2023-04-04T15:43:19.23+00:00
Marco Onnis 1 Reputation point
commented 2024-12-19T21:30:33.6733333+00:00
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,960 questions
asked 2024-12-18T09:41:49.4266667+00:00
Yuvaraj Duraisamy 0 Reputation points
commented 2024-12-19T07:48:07.6366667+00:00
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,546 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,960 questions
asked 2024-12-18T14:24:39.5466667+00:00
Puneet Dasari 20 Reputation points
edited the question 2024-12-19T03:25:04.69+00:00
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,960 questions
asked 2024-12-17T07:50:35.3966667+00:00
Yun 20 Reputation points
accepted 2024-12-17T09:23:19.81+00:00
Yun 20 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,960 questions
asked 2024-08-23T13:54:39.0166667+00:00
Pawel Musial 5 Reputation points
answered 2024-12-16T19:48:20.4633333+00:00
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,960 questions
asked 2022-12-20T17:10:54.27+00:00
Venkateswarlu Y 6 Reputation points
commented 2024-12-13T22:33:12.24+00:00
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,960 questions
asked 2021-06-27T14:30:35.17+00:00
Brandon Ho 376 Reputation points
commented 2024-12-12T19:20:58.4566667+00:00
Wisniewski, Maria 0 Reputation points
1 answer

SSRS 2019 permissions granted to user domain\user are insufficient

Reporting Services Error The permissions granted to user 'DOMAIN\user' are insufficient for performing this operation. (rsAccessDenied) Get Online Help I had this issue in the past with Windows 10 and the solution was to run it in IE 11 under…

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,213 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,960 questions
asked 2023-02-14T03:24:48.44+00:00
Yosef Shellim 21 Reputation points
commented 2024-12-12T19:17:43.74+00:00
Wisniewski, Maria 0 Reputation points
1 answer

SSRS GetParameters() returns empty string/ null.

SSRS report when requested for parameter columns using GetParameters() method returns empty string. This is inconsistently causing application errors. Looking for some help. We are invoking the below method within our PowerBuilder code by connecting to…

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,960 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,760 questions
asked 2024-12-10T13:10:22.3+00:00
Ram PS 0 Reputation points
commented 2024-12-12T07:06:00.6533333+00:00
Jiachen Li-MSFT 32,961 Reputation points Microsoft Vendor
1 answer

SCOM DW Query to retrieve Web Application Transaction requests

Management is requesting monthly inventory reports of things we have monitored in our infrastructure. I have no problem retrieving all I need from the data warehouse, but I am stuck retrieving Web application transaction requests. Some of our…

Operations Manager
Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
1,515 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,960 questions
asked 2022-09-01T07:44:03.657+00:00
Bruno Navarro 11 Reputation points
commented 2024-12-12T06:32:29.5066667+00:00
Rajesh Bhaskar W 0 Reputation points
5 answers One of the answers was accepted by the question author.

Change font in entire SSRS report

I have a SSRS report built in Visual Studio. Approx 30 pages. And I want to change the font (different size, some places bold etc.) across. are there better ways to do it other than manuallt going in each table/ text box and changing? Is there a way to…

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,960 questions
asked 2021-02-24T09:39:41.403+00:00
mukul.poonia 21 Reputation points
commented 2024-12-11T12:58:07.6+00:00
Mark Stals 0 Reputation points
5 answers

SSRS/PBI Report server still linked to old certificate even after binding new certificate

Hello, I have some trouble changing a certificate for Power BI (or SSRS) Report Server. The current certificate was due to expire on 12 July 2022, so i had to renew it. After getting the new certificate, i added it to the MMC console (with…

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,960 questions
Windows Server Security
Windows Server Security
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Security: The precautions taken to guard against crime, attack, sabotage, espionage, or another threat.
1,874 questions
asked 2022-07-13T01:29:23.58+00:00
Ayman Achoua 11 Reputation points
answered 2024-12-09T19:01:50.06+00:00
Danilo Ho 0 Reputation points