2,878 questions with SQL Server Reporting Services tags

Sort by: Updated
1 answer One of the answers was accepted by the question author.

SSRS 2022 download issue

Hi, I am not able to download SSRS 2022 version from the site and getting this error. Is there any issue? link: https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/install-reporting-services?view=sql-server-ver16 Internal Server…

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,878 questions
asked 2024-07-16T02:03:46.6933333+00:00
nagarjuna palika 40 Reputation points
commented 2024-07-16T21:13:12.82+00:00
Erland Sommarskog 107.2K Reputation points
5 answers

Where can I download SQL Reporting Service 2019?

When I click on the link to Download the SQL Reporting Services for 2019, it says it is no longer available. SQL Reporting Services for 2017 is still available. Why isn't 2019???

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,878 questions
asked 2023-02-04T00:03:01.2733333+00:00
Tim McKay 10 Reputation points
commented 2024-07-16T21:11:39.3+00:00
Erland Sommarskog 107.2K Reputation points
1 answer One of the answers was accepted by the question author.

Analyze SSRS crash dump file

Any idea what's causing this ? PROCESS_NAME: ReportingServicesService.exe ERROR_CODE: (NTSTATUS) 0x42ac - <Unable to get error code text> EXCEPTION_CODE_STR: 42ac STACK_TEXT: 000000ae`82636490 00007ffa`3b213b40 : 00000000`00000004…

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,878 questions
asked 2024-07-11T12:41:47.99+00:00
Dipendra Budhathoki 20 Reputation points
accepted 2024-07-16T10:22:47.1+00:00
Dipendra Budhathoki 20 Reputation points
1 answer

Using the SSRS REST API, how do you get values of a report parameter when ValidValuesQueryBased=true?

Hello, I have a report with two parameters. The second parameter is filtered based on the user selection of the first. All works well in the stock ReportViewer UI but we are building a web page for users without direct access to that UI. The request…

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,878 questions
asked 2023-02-10T19:29:06.34+00:00
Fred Spataro 0 Reputation points
commented 2024-07-16T09:45:23.6066667+00:00
Clément D 0 Reputation points
1 answer

Export to XML in SSRS Report Builder: Create an XMLTag that contains both attribute(s) and content

I want to use SSRS Report Builder to export generated reports to XML The problem I encounter is that whatever I try, the result is always something like: <project projectcode="2400928"> <element2>TEST</element2> …

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,878 questions
asked 2024-07-11T08:18:14.01+00:00
Wesley Viaene 0 Reputation points
commented 2024-07-15T05:56:46.45+00:00
Wesley Viaene 0 Reputation points
1 answer

User 'DESKTOP-2GDSF37\dell' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

User 'DESKTOP-MY PC' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed. And The permissions granted to user 'DESKTOP-MY PC' are insufficient…

Microsoft Edge
Microsoft Edge
A Microsoft cross-platform web browser that provides privacy, learning, and accessibility tools.
2,241 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,375 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,878 questions
asked 2024-07-12T07:58:33.4133333+00:00
Vaibhav Jagtap 0 Reputation points
edited an answer 2024-07-12T09:30:36.31+00:00
ZoeHui-MSFT 35,556 Reputation points
4 answers

Data from integer column not displayed in SSRS report but data from string columns displayed.

Hello All, I Have a SSRS report that pulls data from and embedded query in a dataset. The query receives a date parameter and runs okay in SSMS. The query refreshes okay in and generates the fields. However when I click preview report it displays all…

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,878 questions
asked 2024-07-10T12:08:01.26+00:00
Olutimi 5 Reputation points
answered 2024-07-11T12:53:44.1633333+00:00
Olutimi 5 Reputation points
1 answer

email not been send to all in the ssrs report subscription

HI there I have a very bizarre situation in production environment of my work space where not all of the emails are been sent when the ssrs report is been published to go out. For example i have three emails(not real emails) like…

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,878 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,602 questions
asked 2021-05-26T09:46:56.46+00:00
Farhan Jamil 421 Reputation points
commented 2024-07-11T05:35:03.8966667+00:00
Radhai Krish 191 Reputation points
3 answers

SSRS 2019 "The permissions granted to user '' are insufficient for performing this operation"

Trying to add/run a subscription to a existing SSRS 2019 report I'm getting the error below in the SSRS log file where the ONLY thing I changed was my actual login to Domain\username. ` library!WindowsService_0!2154!01/26/2024-14:28:03:: e ERROR:…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,375 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,878 questions
asked 2024-01-26T20:10:05.35+00:00
Nenea Nelu 66 Reputation points
commented 2024-07-11T03:38:12.96+00:00
Vicky Shi 0 Reputation points
1 answer One of the answers was accepted by the question author.

create the dateid table in sql server

Hi , how to populate the dateid and date in dimtime table using script as below output upto 2029 excluding saturday and sunday create table table (dateid int,day varchar(23), dateid | day 20240601 | 2024 June 01 20290601 | 2029 June…

Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,082 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
771 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,375 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,878 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,528 questions
asked 2024-07-10T14:38:36.3933333+00:00
Vineet S 445 Reputation points
accepted 2024-07-10T18:52:57.11+00:00
Vineet S 445 Reputation points
2 answers

Error while installing SQL Server 2022(Express Edition)

Kindly need help with SQL 2022 installation process. This is my summary.txt file, Overall summary: Final result: Failed: see details below Exit code (Decimal): -2068774911 Exit facility code: …

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,375 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,878 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,602 questions
asked 2022-12-19T06:24:16.09+00:00
Mohd Azam Ikhwal Bin Azmi 6 Reputation points
answered 2024-07-10T12:15:29.9633333+00:00
Ijaz Muhammad 81 Reputation points
2 answers

No "Run Now" button in SSRS Subscriptions

Hi, I have SSRS v13.0.5026.0 but do not have a "Run Now" button that I can use when I select a subscription in the list of subscriptions or in the individual report subscription page. There is only New Subscription, Enable, Disable and…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,375 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,878 questions
asked 2024-07-05T09:58:48.4366667+00:00
Tony Wright 0 Reputation points
answered 2024-07-08T06:47:59.12+00:00
ZoeHui-MSFT 35,556 Reputation points
2 answers

SSRS 2022 - Subscription Error when Scheduling to Run each Month on 10th 20th or 30th (Error: Invalid Days)

Unable to create/modify SSRS 2022 report subscription to run each month on the 10th, 20th or 30th. Example Schedule settings (See screenshot below): Schedule: Month Months: All months selected On calendar day(s): 20 (But is the same result if 10 or…

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,878 questions
asked 2024-02-15T04:43:13.83+00:00
commented 2024-07-06T13:25:52.68+00:00
Vig Vaidianathan 0 Reputation points
2 answers

Create a report in SCCM to query machines without a specific software

I am needing to create a report to all machines WITHOUT Microsoft Edge installed. I am fairly novice with SCCM and not a SQL guy. I'd like to use the creation wizard in SCCM and report builder, but I get lost. Ideally we would like to be able 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,878 questions
Microsoft Configuration Manager
asked 2022-05-03T15:53:15.117+00:00
Kai Lantiegne 1 Reputation point
commented 2024-07-06T02:06:05.34+00:00
Ryan 0 Reputation points
7 answers

How to resolve this "Microsoft.ReportingServices.WmiProvider.WMIProviderException:...." error?

I keep getting this error. Microsoft.ReportingServices.WmiProvider.WMIProviderException: An error occurred when attempting to connect to the report server remote procedure call (RPC) end point. Verify that the Report Server Windows service is…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,375 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,878 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
517 questions
asked 2021-05-10T21:06:09.8+00:00
CharlieLor 551 Reputation points
commented 2024-07-04T03:49:54.77+00:00
Ryan 0 Reputation points
6 answers

SQL Server Reporting Service Web Service URL not working

I have installed SQL Server 2019 Developer edition on my Windows 11 PC. And I installed Reporting Services also. I got the report server to say it is "Report Service Status: Started". When I try to access the Web Service URL I get an HTTP…

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,878 questions
asked 2022-11-02T02:26:26.907+00:00
Fred Schmid 6 Reputation points
commented 2024-07-03T06:47:11.4833333+00:00
Sonali Kurdekar 0 Reputation points
7 answers

Best Report Tools for Blazor

My company is transitioning from legacy software that makes extensive use of Crystal Reports and we are looking for a tool compatible with Blazor. Many options come up in a Google search, but we don't have enough experience with the platform to make an…

Blazor
Blazor
A free and open-source web framework that enables developers to create web apps using C# and HTML being developed by Microsoft.
1,504 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,878 questions
asked 2023-02-09T02:52:54.0333333+00:00
RussDFM 5 Reputation points
answered 2024-07-02T16:20:20.1366667+00:00
David Thielen 2,796 Reputation points
5 answers One of the answers was accepted by the question author.

How to pass multi value parameters in SSRS for the Oracle Database using OLEDB Connection

Hi , We have created a parametrized report that has to take multiple values. Created two data sets ( One for report Data Set and the other for report paramarter dataset) Below is the screenshot for report data set where :id is the parameter. …

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,878 questions
asked 2020-12-07T09:28:55.863+00:00
Rajesh Chittineni 141 Reputation points
commented 2024-07-02T10:44:12.81+00:00
Shirley 0 Reputation points
3 answers One of the answers was accepted by the question author.

How to show hidden row in ssrs report

I need to show hidden row in report. How can i do it?

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,878 questions
asked 2023-08-19T16:57:26.17+00:00
Marco Dell'Oca 61 Reputation points
accepted 2024-06-27T15:11:04.7566667+00:00
Marco Dell'Oca 61 Reputation points
3 answers One of the answers was accepted by the question author.

SQL Server Reporting Services 2019 licensing

Hello Can someone please help clarify the below for me. I know SSRS installed separately, My question is, isn´t SQL Server Reporting Service (SSRS) delivered as a part of the SQL Server Standard and Enterprise editions? Or does it require a…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,375 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,878 questions
asked 2022-07-27T08:08:52.157+00:00
Vieira Nicki 36 Reputation points
answered 2024-06-27T09:41:32.61+00:00
Kilimandjaro 20 Reputation points