2,735 questions with SQL Server Reporting Services tags

Sort by: Updated
2 answers

Error while modifying SSRS report using Report Builder: Data extension ORACLE is not installed

While trying to modify a SQL Server Reporting Services (version 13.0.5026.0) report using the Microsoft Report Builder, I am receiving the error: "The selected data extension ORACLE is not installed or cannot be loaded." I installed ODAC 18c…

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,735 questions
asked 2024-02-22T16:10:53.6+00:00
cship 0 Reputation points
edited an answer 2024-03-02T01:49:56.3666667+00:00
Greg Low 600 Reputation points Microsoft Regional Director
2 answers One of the answers was accepted by the question author.

Can't open SQL Server Management Studia 19.1 on Windows 11

Hello, I installed SQL2022-SSEI-Dev and then SSMS-Setup-ENU on my Windows 11 laptop. When I try to open SSMS I get a window with the options to Repair, Uninstall and Close. I have clicked Repair, waited for the repair to take place and then restarted my…

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,319 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,735 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
7,656 questions
asked 2023-06-11T10:50:05.13+00:00
Lisa Li 25 Reputation points
commented 2024-03-02T00:03:51.73+00:00
Ahmed Abdullah 0 Reputation points
1 answer

Can Azure Migrate handle other SQL Server components?

Hello, I have just started to work on a migration project for a client that has the current onpremise environment on Win/SQL 2012 and want to replatform (migrate & upgrade) to Win/SQL 2019. They have cubes (SSAS), Reports (SSRS) and SSIS that need to…

Azure Migrate
Azure Migrate
A central hub of Azure cloud migration services and tools to discover, assess, and migrate workloads to the cloud.
698 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.
12,319 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,735 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,417 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,237 questions
asked 2024-02-26T17:48:38.31+00:00
Abimbola Adeniran 21 Reputation points
commented 2024-03-01T23:20:13.1033333+00:00
Marcin Policht 1,300 Reputation points MVP
3 answers

Something went wrong. Please try again later SSRS 2019

Hello, I have updated SSRS 2019, and whenever I try to access the Subscription I end up with the error message "Something went wrong. Please try again later" as shown in below image. I am running the Reports in Internet Explorer …

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,735 questions
asked 2022-12-06T06:28:46.58+00:00
Tejash Patel 6 Reputation points
answered 2024-03-01T17:48:48.0433333+00:00
Vickey Rajpoot 0 Reputation points
3 answers

Getting "Something Went Wrong" error on SSRS/PowerBI 2022 instance when creating subscription

This one seems to be pretty specific... If I create a subscription, or modify an existing subscription, and the schedule is set to "report specific", I get a popup saying "An Error Has Occurred. Something Went Wrong. Please Try Again…

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,735 questions
asked 2023-06-27T14:32:41.4033333+00:00
Craig Hite 1 Reputation point
answered 2024-03-01T17:44:30.2933333+00:00
Vickey Rajpoot 0 Reputation points
4 answers

SSRS/PBI Report server still linked to old certificate even after binding new certificate

Hello, I have some trouble changing a certificate for Power BI (or SSRS) Report Server. The current certificate was due to expire on 12 July 2022, so i had to renew it. After getting the new certificate, i added it to the MMC console (with…

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,735 questions
Windows Server Security
Windows Server Security
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Security: The precautions taken to guard against crime, attack, sabotage, espionage, or another threat.
1,684 questions
asked 2022-07-13T01:29:23.58+00:00
Ayman Achoua 11 Reputation points
edited a comment 2024-03-01T14:28:03.5966667+00:00
Gerber Patrick BIT 1 Reputation point
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,319 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,735 questions
asked 2023-12-08T01:13:44.01+00:00
Bruce Cauchi 46 Reputation points
commented 2024-03-01T11:29:29.9233333+00:00
Dag Hagen 45 Reputation points
2 answers

How to remove blank cells from a Report Builder Report when displaying daily data?

Is it possible to edit the report to display dates that only have data and not everyday?

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,735 questions
asked 2024-02-21T13:46:38.5066667+00:00
Camponeschi, Alan William 0 Reputation points
commented 2024-02-29T07:58:35.3066667+00:00
ZoeHui-MSFT 30,881 Reputation points
2 answers One of the answers was accepted by the question author.

how to change the edition of SSRS

I have already installed SSRS develop edition, now i want to change it to standard edition. Should i uninstall the develop and install the new? Or any other?

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,735 questions
asked 2024-02-29T06:56:25.6966667+00:00
Leon L 20 Reputation points
commented 2024-02-29T07:40:56.2466667+00:00
Leon L 20 Reputation points
1 answer

Do I change RS dbs' compatibility level after movement to a newest MSSQL?

I will move Reporting Services' databases from MSSQL 2016 server to a new MSSQL 2019. Should I manually change dbs' compatibility level to 2019 at some point or it's recommended to leave it in 2016 compatibility level? Thanks in advance.

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,319 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,735 questions
asked 2023-10-04T18:19:30.9233333+00:00
Miroshnichenko, Valentin 20 Reputation points
answered 2024-02-29T07:37:37.3933333+00:00
Greg Low 600 Reputation points Microsoft Regional Director
3 answers

Cannot connect to SQL Management studio 19.3

Hi Microsoft team, I have been trying to connect to the SQL server for a long time now and i have been getting error message cannot connect to.... How can i overcome this challenge?

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,319 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,735 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,417 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,237 questions
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
24 questions
asked 2024-02-08T16:10:07.1266667+00:00
Boluwaji Olusegun 0 Reputation points
commented 2024-02-29T05:56:26.4866667+00:00
CosmogHong-MSFT 20,901 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

报表预览界面与部署到服务器上的报表样式不一致

我有一张报表,左边是一张表格,右边是折线图,两个部分是紧贴在一起的,预览的时候没有问题,但是我发布到服务器上之后,两个之间产生了很大的间隔,这是为什么,该怎么办?

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,735 questions
asked 2024-02-29T05:25:30.1133333+00:00
San S 20 Reputation points
accepted 2024-02-29T05:48:11.5933333+00:00
San S 20 Reputation points
0 answers

How would I add Subaru account to SQL reporting service for Toyota EquipmentListByTractor

Currently running [http://ryderopsreports/Reports/browse/] service for LMS Toyota Toyota EquipmentListByTractor to determine tracking services listed for tractor inventory. I am unable to query Subaru equipment while performing this task. Can it be added…

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,735 questions
asked 2024-02-28T20:11:02.7933333+00:00
Norman W. Kirk 0 Reputation points
commented 2024-02-29T01:40:53.18+00:00
Norman W. Kirk 0 Reputation points
1 answer

Microsoft Report Viewer winforms version 15 assembly not packing into exe for click once

It used to work until the version 150.1620.0 update of the nuget package of Microsoft Reporting Services ReportViewControl Winforms. Deploying a click once I was able to run the standalone exe by itself. After the update it is requiring the dlls for the…

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,735 questions
asked 2024-02-22T12:18:58.1533333+00:00
Matt Boehm 0 Reputation points
commented 2024-02-28T16:25:26.29+00:00
Matt Boehm 0 Reputation points
1 answer

How to Hide Blank Column and Row

As you can see, the row and column in blue and white are blank; there is no data. I grouped the data by rows and columns to achieve this table format, but somehow, when I select the parameter value to 'select all,' it results in a blank column in every…

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,735 questions
asked 2024-02-27T20:44:01.8266667+00:00
Niya Shah 0 Reputation points
commented 2024-02-28T15:31:42.8366667+00:00
Niya Shah 0 Reputation points
1 answer

Adapting Excel formula to Calculated Measure for % of Fiscal Year Elapsed

I have an Excel formula that calculates % of fiscal year elapsed, and I want to use it in a calculated measure to add it as a dimension field on a PivotTable Cube. However, Copilot generated an error when I tried to adapt it to a calculated measure.…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,328 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.
12,319 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,735 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,417 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,618 questions
asked 2024-02-27T23:49:02.5433333+00:00
James Stone 0 Reputation points
answered 2024-02-28T07:30:08.97+00:00
Jiajing Hua-MFST 2,765 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

multiple merge condition

Hey, due to multiple merged condition in same query, it is taking lots of time to run in sql tried partition but did not work . what can be best approach?

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,319 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,735 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,417 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,237 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,524 questions
asked 2024-02-27T23:50:13.4333333+00:00
Vineet S 85 Reputation points
accepted 2024-02-28T02:09:44.1233333+00:00
Vineet S 85 Reputation points
1 answer

Display number of records in Email body and attached detailed report in SSRS subscription

Hi Team, We got the requirement to display the number of rows/records in email body and attach the detailed excel report in same email. Could you please assist us if we have any alternative option to achieve this requirement. Below would be the sample…

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,735 questions
asked 2024-02-27T06:10:33.8833333+00:00
Krishna Reddy 0 Reputation points
edited an answer 2024-02-28T02:05:45.46+00:00
ZoeHui-MSFT 30,881 Reputation points
2 answers One of the answers was accepted by the question author.

Unable to Upload the RDL to PowerBI portal via POST method

Hello Team, We are unable to upload a paginated report that has simple custom code to the PowerBI portal using the POST Method (Powershell script). ![133364-image.png][1] The below is the compilation error we are getting while trying to upload the rdl…

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,319 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,735 questions
asked 2021-09-19T18:42:57.64+00:00
Rajesh 21 Reputation points
commented 2024-02-27T21:28:42.8466667+00:00
Rabota, Alexandr 0 Reputation points
1 answer

SSRS Report renders HTML with header and footer embedded images swapped

I've created a report in SSRS (v.15) that has a header and footer defined; I've added two embedded images to the report, one of which I've placed in the header and the other in the footer. When the report is exported from the report server as a PDF, 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,735 questions
asked 2023-10-05T20:52:11.5833333+00:00
Cole Smith 0 Reputation points
edited an answer 2024-02-26T09:47:18.0233333+00:00
Andrzej Strzała 0 Reputation points