SQL Server Reporting Services

Subscription

Hi all, I hv a question about SSRS subscription under mssql 2022 STD, I saw when i subscript to a report, it will create a job under SSMS jobs. I would like to manage the report subscription not run on the specified date store in some table in the…

SSRS2022 Custom Header Problem

Hi Guys, I found SSRS2022 16.0.1116.12 Custom Headers…

SSRS Reusing a Shared Schedule through database

Hello! I am running some tests with MSSQL and SSRS where I have some shared schedules that expired last year. I used this update statement to try and bring those reports back to life to run. UPDATE Schedule SET      StartDate = '2025-01-09 00:00:00.000',…

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 …

How to generate a QR Code in basic table report SSRS reprt using the Report Server Project

I created a basic table report (SSRS report) to be integrated with the Model-driven App. As per user requirement, I need to have a QR code in my SSRS report but I cannot find any way to achieve it. Hence, my question is "How to generate a QR Code in…

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,339 questions

Sign in to follow

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,967 questions

Sign in to follow

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…

how to solve this problem, please tell me

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