2,756 questions with SQL Server Reporting Services tags

Sort by: Updated
1 answer

SSRS 2022 subscription - user can't enter a Comment

My user can create a subscription but if she tries to enter anything in the Comment field, she sees an error message "A delivery error has occurred". Looking in the log on the Report Server, I found this message: One of the extension parameters…

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,756 questions
asked 2024-03-17T21:46:00.3+00:00
Nick Ryan 191 Reputation points
answered 2024-03-19T06:47:11.1533333+00:00
ZoeHui-MSFT 31,271 Reputation points
1 answer

existing ssrs reports work however when we try to create a new or modify the existing file it won't work

existing ssrs reports work however when we try to create a new or modify the existing file it won't work. It throws the error Value does not fall in the certain Range Database using - Postgres SQL Connector - PGNP OLEDB Provider This issue happened even…

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,756 questions
asked 2024-03-18T22:49:05.2+00:00
Charan Reddy 0 Reputation points
answered 2024-03-19T05:43:19.33+00:00
ZoeHui-MSFT 31,271 Reputation points
1 answer

Can SSRS 2019 consume data from databases on SQL server 2022?

Is is possible for SSRS 2019 to consume data from databases created with SQL server 2022?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,405 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,756 questions
asked 2024-03-18T14:18:43.8+00:00
Rob Attrill 0 Reputation points
answered 2024-03-19T03:17:57.79+00:00
ZoeHui-MSFT 31,271 Reputation points
3 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,756 questions
asked 2022-12-20T17:10:54.27+00:00
Venkateswarlu Y 6 Reputation points
answered 2024-03-18T22:09:27.1+00:00
Sunny Kr Gupta 0 Reputation points
1 answer

HSTS for Default page on SSRS

Hi, Our SSRS server is failing a vulnerability (Nessus) scan for HSTS. I have been able to add the SQL CustomHeader for HSTS and I can confirm this is working. SQL CustomHeader XML string…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,405 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,756 questions
asked 2024-03-15T03:39:19.55+00:00
Craig Garland 286 Reputation points
commented 2024-03-17T21:36:06.1466667+00:00
Craig Garland 286 Reputation points
2 answers

SSRS Dataset using #Temp Tables

I could have sworn I have done this before. I have multiple Datasets in my SSRS .rdl. The first Dataset creates the #Temp Tables which subsequent Sub-Reports and SQL Server Stored Procedures and Datasets utilize. Also, utilizing the Use single…

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,756 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,532 questions
asked 2024-03-14T21:39:06.71+00:00
Bobby P 221 Reputation points
answered 2024-03-15T06:01:18.5866667+00:00
Olaf Helper 39,886 Reputation points
0 answers

Powershell script to report user OneDrive site collection

Good afternoon,  I’m looking for help with scripting a report to show all users OneDrive Notebooks storage usage.   I’m aware of the usage reports in admin, but I would like to drill down further to the users site collection for notebooks.   The reason…

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,756 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,372 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
1,921 questions
asked 2024-03-14T14:18:29.3633333+00:00
LouD 6 Reputation points
edited the question 2024-03-15T01:40:36.5833333+00:00
Emi Zhang-MSFT 20,741 Reputation points Microsoft Vendor
1 answer

SQL Server 2022 Kurulum Hatası

Microsoft SQL Server Geliştirici indirip 3. seçenekten Basic olanı seçtim. Ekran Görüntüsünde görüldüğü üzere bu hatayla karşılaştım.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,405 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,756 questions
asked 2024-03-14T09:35:38.1566667+00:00
Kadir Veysel SAYAR 0 Reputation points
commented 2024-03-15T01:11:18.7266667+00:00
ZoeHui-MSFT 31,271 Reputation points
1 answer

After upgrading PBIRS to jan 2023, can't use report server configuration manager "Provider load failure"

Hi, I upgraded Power BI report server to the latest version (January 2023), after that I launched the report server configuration manager, I have the server name which is the name of the server where PBIRS is installed but the instance field is grayed…

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,756 questions
asked 2023-05-18T19:14:18.0166667+00:00
Tammame AZZAROUAL 10 Reputation points
commented 2024-03-14T10:37:15.3933333+00:00
Mihai Caragea 0 Reputation points
1 answer

How to install Report Authoring Extension in Visual Studio Community 2022? Tried all methods available on Blogs.

How to install Report Authoring Extension in Visual Studio Community 2022? Tried all methods available on Blogs.

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,756 questions
Visual Studio Extensions
Visual Studio Extensions
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Extensions: A program or program module that adds functionality to or extends the effectiveness of a program.
165 questions
asked 2024-03-08T07:40:46.4333333+00:00
Raju 0 Reputation points
commented 2024-03-14T06:29:10.8733333+00:00
Anna Xiu-MSFT 24,141 Reputation points Microsoft Vendor
2 answers

Deploying dashboard to power bi report server using power shell script

when try to execute the above query it's showing the Failed to create a session to the report server. Could someone please help to this issue. Actually I try to deploy the power bi report server dashboard with power shell script.

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,756 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
1,921 questions
asked 2024-03-13T06:06:19.4566667+00:00
Kaviyarasan J 0 Reputation points
answered 2024-03-14T01:19:41.94+00:00
ZoeHui-MSFT 31,271 Reputation points
3 answers One of the answers was accepted by the question author.

SQL 2018 SSRS not able to display X-Frame-Options set to sameorigin

Hello All, I am facing an issue where our web app is calling sql server and it was all working fine until we used ssms 2012, Now we have upgraded to sql server 2018 and now I am not able to embed my ssrs report in web page. It says refused to connect 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.
12,405 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,756 questions
asked 2024-03-12T19:10:22.78+00:00
Sinch Am 20 Reputation points
edited a comment 2024-03-13T19:07:37.9666667+00:00
Sinch Am 20 Reputation points
2 answers

has inline function got any catch?

hi, I heard many people saying "functions are denounced in tsql" is there any catch? q1) need to know what are the cases where we should not use? q2) should we avoid scaler functions also? q3) should we avoid scaler functions if we have 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.
12,405 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,756 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,426 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,239 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,532 questions
asked 2024-03-11T05:57:35.8533333+00:00
Rajesh Kumar Yadav 0 Reputation points
commented 2024-03-13T08:56:06.0133333+00:00
Rajesh Kumar Yadav 0 Reputation points
2 answers

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…

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,756 questions
asked 2024-03-08T17:39:51.67+00:00
Ali Ahad 91 Reputation points
commented 2024-03-13T05:30:26.1633333+00:00
ZoeHui-MSFT 31,271 Reputation points
1 answer

Maps in SSRS coming back with status 401: Unauthorized

We have reports written in SSRS that have Map components in them. They have been working well, but recently they have been producing intermittent 401: Unauthorized and not displaying the base map layer (Bing map imagery), see the attached image. No…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,405 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,756 questions
asked 2023-12-08T01:13:44.01+00:00
Bruce Cauchi 46 Reputation points
commented 2024-03-12T21:19:17.5433333+00:00
Bruce Cauchi 46 Reputation points
2 answers

SSRS not available in Azure VM with SQL Web version

SSRS not available in Azure VM with SQL Web version

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
6,929 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,756 questions
asked 2024-03-07T18:29:06.7166667+00:00
Mahendra Suru 0 Reputation points
commented 2024-03-08T04:11:47.97+00:00
vipullag-MSFT 23,561 Reputation points Microsoft Employee
1 answer

SSRS stops exporting to Excel

We are having a weird issue with SSRS where by reports stop exporting to Excel from time to time. We are using SQL 2016 standard, SP2 Every few days we experience this and sometimes multiple times in a day. The report runs to screen without issue but…

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,756 questions
asked 2020-08-28T11:01:06.12+00:00
Richard Gardner 6 Reputation points
commented 2024-03-07T19:14:46.7666667+00:00
Mr.IT 0 Reputation points
4 answers

SCCM Report issue

Dear All, Could you please assist with the issue I'm encountering in Report Server Configuration Manager? I have configured the Report Server Configuration Manager, and both the web service URL and web portal URL are working fine. However, I can't find…

Microsoft System Center
Microsoft System Center
A suite of Microsoft systems management products that offer solutions for managing datacenter resources, private clouds, and client devices.
777 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,756 questions
Microsoft Configuration Manager
asked 2024-03-06T11:56:43.1933333+00:00
Muneer Jahangeer 341 Reputation points
answered 2024-03-07T15:17:00.12+00:00
Muneer Jahangeer 341 Reputation points
2 answers

SSRS Report 2014- Dynamic Image Pagination

I have a report in SSRS 2014 that has Tablix table with dynamic images being populated from a SQL stored procedure (url's). When I view the report I can see all the images in the right order... basically ex: Accessible route 1 scrolls all the 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,756 questions
asked 2024-03-05T22:55:42.6533333+00:00
GKCarbie 0 Reputation points
answered 2024-03-07T02:37:44.35+00:00
ZoeHui-MSFT 31,271 Reputation points
1 answer

Why does SSRS Report Viewer control render error on some machines?

Using ReportViewerControl 150.1449.0 to render SSRS (rdl files) in a Delphi application Click the report from the Delphi application and it opens the parameter box. Enter in parameters and it renders results on working machine. Click the report from…

Windows Server 2019
Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
3,380 questions
Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
10,358 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,756 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
7,825 questions
asked 2024-03-06T17:15:57.81+00:00
Jerry VanDreumel 0 Reputation points
commented 2024-03-06T21:07:14.0233333+00:00
Michael Taylor 45,801 Reputation points