Microsoft Q&A

SQL Server Reporting Services

2,221 questions

A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.

2,221 questions with SQL Server Reporting Services tags

Sort by: Updated
0 answers

How to Calculate Incentives on the basis of Reporting Matrix?

Dear Experts, I need your expert help as my knowledge is limited w.r.t. following stated problem. I need to calculate incentives on given sales target depending on Reporting Matrix. A = > Highest Level of Designation B=> Middle Level of…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,029 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,054 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,221 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,943 questions
asked 2023-03-20T15:16:21.0466667+00:00
Manish Papreja 41 Reputation points
commented 2023-03-21T02:21:21.7466667+00:00
PercyTang-MSFT 2,921 Reputation points Microsoft Vendor
1 answer

Is there a matrix of Microsoft Supported/Unsupported Applications for Win 2012 to 2016 Upgrade?

We have a number of 2012 servers hosting MS applications including SP, SSRS, SQL, and others. We are determining which servers to in-place upgrade and which to build and migrate. I'm looking for a matrix of MS applications for which in-place is…

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
1,606 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.
9,029 questions
Windows Server 2016
Windows Server 2016
A Microsoft server operating system that supports enterprise-level management, data storage, applications, and communications.
1,847 questions
Windows Server 2012
Windows Server 2012
A Microsoft server operating system that supports enterprise-level management, data storage, applications, and communications.
1,175 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,221 questions
asked 2023-03-20T17:10:48.6433333+00:00
sco gordo 221 Reputation points
answered 2023-03-21T02:01:28.4966667+00:00
AllenXu-MSFT 4,966 Reputation points Microsoft Vendor
1 answer

Error reported when creating a new SQL Server Reporting Service database

I'm using the SSMS Configuration Tool to create a new ReportServer database. The database is a SQL Server Managed Instance in Azure. In the SQL Managed Instance version is: "Microsoft SQL Azure (RTM) - 12.0.2000.8 Jan 18 2023 08:44:24" When…

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,221 questions
asked 2023-03-20T15:38:10.28+00:00
JohnSebastian-3934 121 Reputation points
answered 2023-03-21T01:45:56.1333333+00:00
AniyaTang-MSFT 2,976 Reputation points Microsoft Vendor
1 answer

Data driven subscription feature not available on standard edition???

I've developed a few reports on a test server where we have SQL Server 2019 developer edition installed with the intent to migrate them over to our production server. I used the data-driven subscription feature to timestamp the file name for one report…

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,221 questions
asked 2023-03-13T21:34:31.79+00:00
Rick A. Anderson 0 Reputation points
commented 2023-03-20T15:07:50.5633333+00:00
Rick A. Anderson 0 Reputation points
1 answer One of the answers was accepted by the question author.

Do you know if builtin ConfigMgr reports are created after installing the Reporting Services Point role on a PowerBI server?

Hi, I've read this Microsoft doc. regarding ConfigMgr and Power BI integration: https://learn.microsoft.com/en-us/mem/configmgr/core/servers/manage/powerbi-report-server But I still have a question for which I didn't find any answer yet. We have a new…

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,221 questions
Microsoft Configuration Manager
asked 2023-03-17T20:46:55.45+00:00
Patrick Dube 20 Reputation points
commented 2023-03-20T12:21:08.3666667+00:00
Patrick Dube 20 Reputation points
2 answers

I need access http://opsbissrs/ReportS/browse/

I need access http://opsbissrs/ReportS/browse/

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,221 questions
asked 2023-03-20T09:06:01.08+00:00
Daliang Qi (Accenture Japan Ltd) 0 Reputation points Microsoft Vendor
answered 2023-03-20T09:51:25.3933333+00:00
Olaf Helper 27,051 Reputation points
2 answers

how to make two tablix same size?

Hello all, I have a paginated report withing Report Builder, and they are laid out in this manner: When I go into run mode, it is rendered like this: How can I achieve that first table is the same length as the second one, without manually adjusting…

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,221 questions
asked 2023-03-15T11:12:24.9033333+00:00
Vashko 20 Reputation points
commented 2023-03-20T09:42:52.7866667+00:00
AniyaTang-MSFT 2,976 Reputation points Microsoft Vendor
2 answers

When attempting to access SSRS report via remote web browser get 'connection refused' error

Reports can be run from the browser on the VM and inbound port rules are configured for port 80 to allow all connections.

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,221 questions
asked 2023-03-16T15:36:10.1433333+00:00
Tim Brault 0 Reputation points
commented 2023-03-20T09:41:56.8533333+00:00
AniyaTang-MSFT 2,976 Reputation points Microsoft Vendor
1 answer

Embedding Courier New font to a pdf when using WebForms library

I am unable to create a pdf document that uses 'Courier New' true-type font, using LocalReport class in Microsoft.Reporting.WebForms lib. The pdf is generated with CourierStd, Type 1, font. Is this a bug in the lib or am I missing a config? I will…

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,221 questions
asked 2023-03-15T13:16:44.7333333+00:00
Bijaya Rai 0 Reputation points
commented 2023-03-20T09:41:31.93+00:00
AniyaTang-MSFT 2,976 Reputation points Microsoft Vendor
1 answer

How to Fix IIS Short Filename Vulnerability in Web Services of Microsoft SQL Server Reporting Services Version 13.0.4199.0

The IIS 8.3 short file name vulnerability exists in the SSRS web service, and the setting of the iis root node cannot be repaired. Where can I fix the vulnerability of this dummy site

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,221 questions
Internet Information Services
asked 2023-03-20T06:25:43.9666667+00:00
炜 张 0 Reputation points
answered 2023-03-20T07:56:04.26+00:00
AniyaTang-MSFT 2,976 Reputation points Microsoft Vendor
1 answer

Tablediff utility not found on SQL SERVER 2022 installation path

Hi All, I am looking for tablediff.exe utility on the sql server 2022. Check many posts on internet to search the utility file. But could not locate it in my system. I have checked installing different sql server versions 2019 ,2022, express and…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,943 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.
9,029 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,054 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,221 questions
asked 2023-03-20T05:54:41.2733333+00:00
Pralhad Parkar 0 Reputation points
edited the question 2023-03-20T07:40:17.0033333+00:00
ShaktiSingh-MSFT 5,681 Reputation points Microsoft Employee
1 answer

How to control multiple subreport from a tablix

I got a tablix where I am displaying 9 different reports. Users wants to click on months to review the raw data of the report for that reporting month. I have created 9 different sub reports to show that. Each sub report columns are different so I…

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,221 questions
asked 2023-03-20T04:21:01.0533333+00:00
Ali Ahad 66 Reputation points
edited an answer 2023-03-20T06:28:13.6366667+00:00
AniyaTang-MSFT 2,976 Reputation points Microsoft Vendor
1 answer

Translate the text in REPORTVIEWER 15 Print Box

Hi, I'm generating a report in REPORTVIEWER 15. When I click on the PRINT button, the print dialog appears. On my computer, the texts appear in Portuguese, but on the Windows Server 2016, they appear in English. The regional configuration of the 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,221 questions
Windows Server Printing
Windows Server Printing
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Printing: Printer centralized deployment and management, scan and fax resources management, and document services
531 questions
asked 2023-03-18T17:07:11.0233333+00:00
ALBERTO CARIBÉ 0 Reputation points
answered 2023-03-20T02:07:55.8233333+00:00
AniyaTang-MSFT 2,976 Reputation points Microsoft Vendor
3 answers

Create data entry form and design report

Hello, I am new to visual studio. At work I have a project in which we want to create a form that we can input data and then run a report using ssrs. Is there a template out there that I can use to get started? Thanks for your help.

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,221 questions
Windows Forms
Windows Forms
A set of .NET Framework managed libraries for developing graphical user interfaces.
1,386 questions
asked 2022-07-24T21:20:28.077+00:00
Walker, Jonathan 6 Reputation points
commented 2023-03-19T20:16:59.7266667+00:00
Reza Aghaei 4,801 Reputation points MVP
1 answer

How to Export SSRS Reports to sharepoint Office 365

Hi How to schedule SSRS subscriptions to save reports directly into a SharePoint Document Library. SharePoint (Office 365) is running on cloud and we can't get UNC. The Reporting Services Report server version is on 14.0 and is it is on Native mode…

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,221 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
6,417 questions
asked 2020-10-21T23:17:03.3+00:00
jambai 6 Reputation points
commented 2023-03-19T16:34:17.6433333+00:00
SCOTT Kevin -PICKERING 0 Reputation points
1 answer

How to write expression for bold a field based of two criteria's.

I have a report that tells me what customers moved out of rental space and who move in after the move-out occurred. What I am trying to do is come up with a way to bold the last names of someone who moved in 30 min after someone move out. Also, need 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,221 questions
asked 2023-03-07T20:28:10.5866667+00:00
Jannette Jones 161 Reputation points
commented 2023-03-17T08:47:26.19+00:00
AniyaTang-MSFT 2,976 Reputation points Microsoft Vendor
1 answer

Product(s) for form design with smart reporting.

Looking for a product to create a form flow to a smart report. For example: Plaintiff Name: Mary Jones, everywhere the word plaintiff is in the questionnaire or form should be prepopulated with Mary Jones. I am very familiar with using Conditional…

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,221 questions
Azure Form Recognizer
Azure Form Recognizer
An Azure service that applies machine learning to extract text, key/value pairs, tables, and structures from documents.
687 questions
asked 2023-03-12T11:52:56.57+00:00
Bert Barber 0 Reputation points
commented 2023-03-17T08:41:56.5333333+00:00
AniyaTang-MSFT 2,976 Reputation points Microsoft Vendor
1 answer

SSRS; Report rendering empty when using url to pass field value to a parm in another report

I am trying to pass a field value in one report to a parm value in another report using a url in the Action feature. The field on first report should be hyperlink. I test everything with values hard coded in the url and the second report runs with no…

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,221 questions
asked 2023-03-13T18:57:25.05+00:00
142041 0 Reputation points
commented 2023-03-17T08:40:16.39+00:00
AniyaTang-MSFT 2,976 Reputation points Microsoft Vendor
1 answer

Cannot create a connection to data source (rsErrorOpeningConnection)

We have two servers with SSRS and SSAS. Both are running 2008R2. On SSRS server there are quite a few data sources using SSAS databases. All reports based on these data sources are working when I connect to Report Manager on SSRS server but when I try 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,221 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,054 questions
asked 2023-03-14T18:39:08.4233333+00:00
Marin Kostadinovic 0 Reputation points
commented 2023-03-17T08:38:43.1533333+00:00
AniyaTang-MSFT 2,976 Reputation points Microsoft Vendor
1 answer

SSRS report - export to HTML

I need to run a report in the backend using C# and export it into an HTML. I can do with Excel, but not sure about HTML extension name. Thanks

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,221 questions
asked 2023-03-14T20:48:21.58+00:00
Zolotoy 191 Reputation points
commented 2023-03-17T08:38:01.6+00:00
AniyaTang-MSFT 2,976 Reputation points Microsoft Vendor