2,944 questions with SQL Server Reporting Services tags

Sort by: Updated
2 answers

Error occurred during local report processing

Hi Experts, i am getting error while generating the report: I have used parameters like : and getting error as below screenshot The 'Value' expression for the query parameter '?' contains an error: Overload resolution failed because…

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,944 questions
asked 2022-11-29T06:28:37.413+00:00
Rathore, Vaibhav Singh 1 Reputation point
commented 2024-11-22T19:06:13.44+00:00
BremerhavenRocks 0 Reputation points
2 answers

Critical Error for SharePoint_Config Database

Hi, I searched all forums for three days but can't find the answer. These topics won't work : Answer 1 Answer 2 Answer 3 The server returns this critical error: SQL database login for 'SharePoint_Config' on instance 'ServerSql' failed.…

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,944 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
3,071 questions
asked 2022-11-21T10:40:33.883+00:00
Safa 1 Reputation point
commented 2024-11-22T09:36:12.8+00:00
Sudhir Singare 0 Reputation points
2 answers

How to create a Database for Power BI Report Server

Hi All, I am using SQL Server 2022 with Windows Authentication. I have downloaded the Power BI Report Service instance on my machine. I am trying to create a new database using the Report Server Configuration Manager. As Service Account, I have…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,071 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,944 questions
asked 2024-11-15T16:17:04.8766667+00:00
Jorziño Barradas 20 Reputation points
commented 2024-11-22T06:27:05.0766667+00:00
ZoeHui-MSFT 38,066 Reputation points
4 answers

Where and how do I add the SQL license key when SQL server reporting services expire

Our SQL 2022 reporting services stopped working. We figured out it had expired, and I must add the SQL license key. I need to know the process of adding the license key to SQL reporting services.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,071 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,944 questions
asked 2024-11-20T21:34:40.0933333+00:00
Dennis Huston 0 Reputation points
answered 2024-11-22T01:31:36.73+00:00
ZoeHui-MSFT 38,066 Reputation points
1 answer

How to install Reporting Services in an Azure SQL VM

Hello, I have an Azure SQL VM and i need to install SQL Reporting Services. I downloaded the setup but it asking for a serial number that i don't have. How do i know the serial number of SQL to insert in the instalation process? Or there is another way…

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,944 questions
asked 2023-11-21T15:33:23.5+00:00
Sérgio Raposo 0 Reputation points
edited a comment 2024-11-20T23:29:38.1833333+00:00
Daniel Montero 0 Reputation points
1 answer

SCCM 2012 sql query

Need assistance to pull a report that can provide the asset name, domain, username, product, warranty, cpu, total size HDD, free disk space, OS,

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,944 questions
Microsoft Configuration Manager
asked 2024-11-18T13:12:50.9533333+00:00
Bruce Meyer 20 Reputation points
commented 2024-11-19T07:39:49.3+00:00
AllenLiu-MSFT 45,761 Reputation points Microsoft Vendor
1 answer

Ssrs server changes nls language randomly.

Hi, I have a very stramge issue every now and then the server decides to change the languade settings for my oracle datasource. Nothing happens on the oracle database. The issue happens and my datasource that notmally works fine swaps to Czech or Brasil…

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,951 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,944 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,602 questions
Microsoft Configuration Manager
asked 2023-10-25T08:56:17.5933333+00:00
Vincent Jonkers 0 Reputation points
commented 2024-11-19T02:33:42.9133333+00:00
Wilson Shen 0 Reputation points
0 answers

Identifying Unused Tables in AAS Cube Over the Last 30 Days

I have a question regarding identifying unused tables in Azure Analysis Services (AAS). In our organization, we’re using AAS, and due to limited storage, our cube refresh is failing. I’ve been tasked with finding a list of tables that haven’t been used…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
461 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,014 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,944 questions
asked 2024-11-07T16:03:40.6433333+00:00
madmax 0 Reputation points
commented 2024-11-19T00:56:57.1966667+00:00
Chandra Boorla 3,535 Reputation points Microsoft Vendor
3 answers

SQL Server Reporting services 2019 Slow on new server

Moving SSRS from Windows Server 2016 to new Windows Server 2019. Looking at the XML from ExecutionLog3 (Below). Connections take around 20 seconds before it moves on to actually running the report, instant on 2016 server. Testing data sources takes…

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,944 questions
asked 2021-07-10T03:33:51.787+00:00
Ted Schnieders 6 Reputation points
answered 2024-11-15T14:59:42.7066667+00:00
Joe Andersen 0 Reputation points
4 answers

VS Version 17.11.5 - SSRS report RDLs open BLANK

Hello, Version 17.11.5 - SSRS report RDLs open BLANK I have submitted this from VS but have not received any help. It gets set to Triaged or marked as a duplicate and I have not heard back. I am a tad surprised this is not a widespread issue because…

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,231 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,944 questions
asked 2024-10-11T18:40:50.0633333+00:00
Linda 21 Reputation points
answered 2024-11-14T13:09:54.6966667+00:00
Linda 21 Reputation points
1 answer

Can SSRS cached shared-datasets be accessed from backend database table?

Is the cached dataset available inside the SSRS TempDB or anywhere in the database? This way, the cached SSRS datasets can be accesssed from backend DB, instead of web portal So need only to execute 1-time DB query, and subsequent accesses will be from…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,071 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,944 questions
asked 2024-11-13T05:28:09.03+00:00
MrCool 0 Reputation points
answered 2024-11-14T06:56:17.2466667+00:00
ZoeHui-MSFT 38,066 Reputation points
6 answers

How to download Sql Server Configuration Manager

Hello, BRAND NEW to SQL Server. I was following along with a tutorial and downloaded the SSMS, however, doesn't seem like i have the configuration manager installed properly. I tried entering the credentials first prompted once SSMS was done…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,071 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,944 questions
asked 2022-09-25T07:02:10.793+00:00
Zach Hadjah 26 Reputation points
commented 2024-11-13T14:23:23.85+00:00
Onur SEVİNÇ 0 Reputation points
1 answer

SSRS 15.0.8760.20928 causes errors in data driven subscriptions

My Server SSRS 2019 was upgraded with a windows update to version 15.0.8760.20928 The SSRS Wed looks completely different, but that's OK (I don't like the new look but that's just me :)) I tried to change a Data driven subscription, and I get the below…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,071 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,944 questions
asked 2024-01-25T15:25:46.38+00:00
Joe Fischer 0 Reputation points
commented 2024-11-10T14:04:20.23+00:00
Arbo 0 Reputation points
0 answers

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,071 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,944 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,663 questions
asked 2024-11-07T13:49:08.8166667+00:00
Bobby P 231 Reputation points
edited the question 2024-11-08T08:24:32.69+00:00
ZoeHui-MSFT 38,066 Reputation points
3 answers One of the answers was accepted by the question author.

How to Connect Microsoft Report Builder with Apache Druid?

Iam Trying to connect with my Microsoft Report Builder with Apache Druid, Is any roadmap to follow or step and any alternative solutions with any tools that i require to connect them is avalilable then please ping me

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,944 questions
asked 2024-11-08T05:49:45.74+00:00
Yallappa Basavaraj Nesarikar 20 Reputation points
accepted 2024-11-08T06:56:51.35+00:00
Yallappa Basavaraj Nesarikar 20 Reputation points
2 answers

Running RDL results in System Out Of Memory Error

I'm running SSRS on SQL Server 2016. I'm using Visual Studio 2017 for development (these versions are both restrictions from my company). When running a particular report (RDL) I'm getting the following error. Before I go to my IT department, I just want…

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,944 questions
asked 2024-11-07T16:08:16.73+00:00
Dom 836 Reputation points
answered 2024-11-08T05:50:46.9+00:00
ZoeHui-MSFT 38,066 Reputation points
2 answers

Unable to send scheduled email using the SSRS - Report Server error

Had setup the email configuration for a report to auto schedule email due to some error unable to move forward, have tried with everything - are we missing something here? Does this Guide is enough from the Stackoverflow forum in anyway? or else any…

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,944 questions
asked 2024-11-05T14:47:46.8366667+00:00
Kadher Meera Sahib 0 Reputation points
answered 2024-11-06T02:09:50.7566667+00:00
ZoeHui-MSFT 38,066 Reputation points
1 answer

Unable to install sql server 2022 express on my Personal laptop. Could you please help with it? Iam struggling here. Any amount of help is appreciated

The following is the message i see in my log file Overall summary: Final result: Failed: see details below Exit code (Decimal): -2147467259 Start time: 2024-10-31 14:13:52 End time: …

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,071 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,944 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,602 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,292 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,663 questions
asked 2024-10-31T19:40:38+00:00
Harshini Reddy Bobbala 0 Reputation points
answered 2024-11-04T01:39:52.6033333+00:00
ZoeHui-MSFT 38,066 Reputation points
2 answers

Does SQL Server Reporting Services 2019 (Enterprise Ed or Dev Ed) really still support mobile reports?

A colleague and I have stumbled across something confusing regarding SSRS 2019 Ent Ed. According to the MS site, mobile reports are still supported in 2019, see: SQL Server Reporting Services features supported by editions - SQL Server Reporting…

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,944 questions
asked 2024-10-30T09:13:01.5266667+00:00
Dirk Hondong 871 Reputation points
commented 2024-11-01T10:50:01.2733333+00:00
Dirk Hondong 871 Reputation points
1 answer One of the answers was accepted by the question author.

Powebi license

HIf i want to publish my ssrs report to powerbi service, Which lisence should i pay for?

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,944 questions
asked 2024-10-30T08:04:11.0833333+00:00
Jefferson-2765 526 Reputation points
accepted 2024-10-30T13:14:23.0066667+00:00
Jefferson-2765 526 Reputation points