SSRS2022 Custom Header Problem
Hi Guys, I found SSRS2022 16.0.1116.12 Custom Headers…
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 …
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.
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…
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…
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.
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…
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…
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…
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.
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…
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…
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…
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**:…
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…
Sign in fail when open report
Im running a report on my server, and the error occurred said sign in failed for user xxx
&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…
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:…
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…