2,860 questions with SQL Server Reporting Services tags

Sort by: Updated
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,229 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,267 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,860 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 34,996 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,860 questions
asked 2024-07-11T08:18:14.01+00:00
Wesley Viaene 0 Reputation points
answered 2024-07-12T05:23:25.5333333+00:00
ZoeHui-MSFT 34,996 Reputation points
1 answer

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,860 questions
asked 2024-07-11T12:41:47.99+00:00
Dipendra Budhathoki 0 Reputation points
answered 2024-07-12T01:41:03.7266667+00:00
ZoeHui-MSFT 34,996 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,860 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,860 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,596 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,267 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,860 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,059 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
759 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,267 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,860 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,508 questions
asked 2024-07-10T14:38:36.3933333+00:00
Vineet S 325 Reputation points
accepted 2024-07-10T18:52:57.11+00:00
Vineet S 325 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,267 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,860 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,596 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 61 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,267 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,860 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 34,996 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,860 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,860 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,267 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,860 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.
509 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,860 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,492 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,860 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,751 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,860 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,860 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,267 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,860 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
2 answers

Unable to install SQL Server 2022 (setup.exe). Exit code (Decimal): -2147467259.The system cannot find the path specified.

Please help me solve this error. Cant install SQL Server 2022: Unable to install SQL Server 2022 (setup.exe). Exit code (Decimal): -2147467259.The system cannot find the path specified.

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,860 questions
asked 2024-04-17T03:19:46.4966667+00:00
JOANNAH MARIE ZARAGOZA 0 Reputation points
commented 2024-06-25T15:40:37.2666667+00:00
jean carlo herrera delgado 0 Reputation points
2 answers One of the answers was accepted by the question author.

Matrix's backgroud color

HI, I NEED A HELP I HAVE A MATRIX, AND I WOULD LIKE TO CHANGE THE BACKGROUND COLOR WHEN THE AGREGATED VALUE IS UNDER THAN 92K. I TRYED TO USER A SIMPLE SWITCH OR IIF (IN TABLIX ITS WORKS FINE), BUT IT CHANGE ALL CELLS IN THE MATRIX...   HOW CAN I DO THIS…

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,860 questions
asked 2024-06-21T16:06:29.46+00:00
commented 2024-06-25T13:32:39.04+00:00
2 answers One of the answers was accepted by the question author.

Steps to use Cyber Ark to manage Data Source Credentials with on Prem Power BI report server

Hello, I am getting mixed results when trying to determine if Power BI report Server can use Cyber ARK PVWA for managing Data Source account passwords. Using PVWA enables Web application to connect to a credential managed Vault to retrieve service…

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,860 questions
asked 2024-06-21T13:27:08.5466667+00:00
NORRIS, CHIP 20 Reputation points
commented 2024-06-25T11:27:26.5066667+00:00
NORRIS, CHIP 20 Reputation points