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,972 questions
1 answer
How to login the SQL server authentication?
I can only access my database via the SQL Database Query Editor via the "Microsoft Extra Authentication". I tried logging in using the "SQL server authentication" but that doesn't allow me to do so. Question: Where do I generate or…
asked 2025-01-17T18:34:44.3566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 64%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBT%3C/text%3E%3C/svg%3E)
Brian Thomas
0
Reputation points
answered 2025-01-17T21:06:12.8966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com)
69,501
Reputation points
0 answers
Export SSRS report from 2207 to a new 2409
I am trying to export custom reports from an old site and bring them into the new site, what would be the best option to do so?
asked 2025-01-17T17:20:12.6766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 70%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Belgian Malinois
421
Reputation points
asked 2025-01-17T17:20:12.6766667+00:00
Belgian Malinois
421
Reputation points
1 answer
Can an SSRS cumulative update (15.0.9098.6826) be rolled back or uninstalled without uninstalling SSRS?
If an SSRS cumulative update has been installed on a server, such as 15.0.9098.6826, 2025/01/06, is there any way to uninstall it or roll it back to the previous version without completely uninstalling SSRS? Obviously, some sort of system restore point…
asked 2025-01-14T20:19:55.7133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 53%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Harry Sauers
0
Reputation points
answered 2025-01-15T02:17:55.88+00:00
ZoeHui-MSFT
39,671
Reputation points
2 answers
One of the answers was accepted by the question author.
How do I lock files in a Git repository to prevent others from working on the same file?
Hello, I'm very new to Azure DevOps, and I've used TFS for version control in the past for our .rdl files. Now we are using Git in Azure DevOps for source control. I have a repository with several files that will be used by more than one developer. We…
asked 2021-10-19T15:37:46.01+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 37%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETA%3C/text%3E%3C/svg%3E)
Tezino, Angelique
21
Reputation points
commented 2025-01-14T20:02:17.4933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 6%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Randall Spychalla
0
Reputation points
1 answer
SSRS2022 Custom Header Problem
Hi Guys, I found SSRS2022 16.0.1116.12 Custom Headers…
asked 2025-01-07T02:59:18.05+00:00
Wilson Shen
0
Reputation points
commented 2025-01-14T06:16:47.55+00:00
Wilson Shen
0
Reputation points
1 answer
Measure grand total
Hi community, I work with report builder, I trying to calculate grand total, but I don't make a correct calculation. The Source is actually semantic model in power bi service, I have on semantic model this dimensions: Country, City and measures : stock,…
asked 2025-01-13T20:35:23.1966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 8%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPQ%3C/text%3E%3C/svg%3E)
Pedro Quiroz
0
Reputation points
commented 2025-01-14T05:36:13.6366667+00:00
ZoeHui-MSFT
39,671
Reputation points
3 answers
How to merge multiple SSRS instance into one new single SSRS instance?
I'm migrating and consolidating two SQL instances into one new SQL Server 2022 instance. For user databases these are fine as I can just backup and restore them to new instance. But how about the SSRS currently running on both source instance? Each of…
asked 2025-01-12T10:31:02.86+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 85%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMW%3C/text%3E%3C/svg%3E)
Marcus Wong Theen Nam
1,141
Reputation points
answered 2025-01-13T08:42:14.41+00:00
Olaf Helper
45,626
Reputation points
2 answers
Subscription
Hi all, I hv a question about SSRS subscription under mssql 2022 STD, I saw when i subscript to a report, it will create a job under SSMS jobs. I would like to manage the report subscription not run on the specified date store in some table in the…
asked 2025-01-10T09:50:11.9933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 57.99999999999999%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJT%3C/text%3E%3C/svg%3E)
Joey Tsui
0
Reputation points
answered 2025-01-13T05:45:05.8633333+00:00
ZoeHui-MSFT
39,671
Reputation points
1 answer
SSRS Reusing a Shared Schedule through database
Hello! I am running some tests with MSSQL and SSRS where I have some shared schedules that expired last year. I used this update statement to try and bring those reports back to life to run. UPDATE Schedule SET StartDate = '2025-01-09 00:00:00.000',…
asked 2025-01-09T16:29:29.26+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 49%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Matt Tobino
0
Reputation points
answered 2025-01-10T06:30:34.7733333+00:00
ZoeHui-MSFT
39,671
Reputation points
1 answer
SSRS Bing Maps Error: "The underlying connection was closed"
The SSRS report's map visual displays an error message. Although the Point Layer data region is showing correctly, Bing Maps encounters an error. Details: Report Server Version: 15.0.1102.675 TLS 1.2 Server: Enabled TLS 1.2 Client: Enabled …
asked 2025-01-03T12:56:17.8333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 97%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJG%3C/text%3E%3C/svg%3E)
Jayamurali Ganeshan
0
Reputation points
commented 2025-01-09T11:26:31.49+00:00
Jayamurali Ganeshan
0
Reputation points
2 answers
One of the answers was accepted by the question author.
How to generate a QR Code in basic table report SSRS reprt using the Report Server Project
I created a basic table report (SSRS report) to be integrated with the Model-driven App. As per user requirement, I need to have a QR code in my SSRS report but I cannot find any way to achieve it. Hence, my question is "How to generate a QR Code in…
asked 2023-11-06T10:09:34.58+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 69%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYZ%3C/text%3E%3C/svg%3E)
Yue Zhen Khor
20
Reputation points
commented 2025-01-08T17:41:46.9966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 15%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJW%3C/text%3E%3C/svg%3E)
Jason Walters
5
Reputation points
1 answer
When will the Dynamics 365, version 9.0 Report Authoring Extension be available for vs2022?
When will the Dynamics 365, version 9.0 Report Authoring Extension be available for vs2022? Up untill now the latest version it is available for is vs2019.
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,360 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,972 questions
asked 2025-01-02T14:51:08.7733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 9%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
victor sijtsma
0
Reputation points
answered 2025-01-03T03:13:31.7666667+00:00
ZoeHui-MSFT
39,671
Reputation points
1 answer
SSRS 2022 does not show barcode when printing to PDF
We are using SSRS 2022. We have a report that has a barcode on it using BCC3OF9N.TTF. The barcode shows in preview mode when we run the report, but when it prints to PDF or exports to PDF the barcode does not show. I have verified the barcode is on the…
asked 2024-12-30T23:24:09.87+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 73%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED3%3C/text%3E%3C/svg%3E)
DoveConnieDES-3786
1
Reputation point
answered 2024-12-31T02:13:11.0066667+00:00
ZoeHui-MSFT
39,671
Reputation points
2 answers
How to connect the Powerbi Report Server to sqlserver with "force encryption" enabled
Dear Support: we are trying to setup the PowerBI report server on our local environment, and according to our security policy, we are forced to activate the "force encryption" in SQL server, which makes us not able to connect to database…
asked 2024-12-26T11:09:08.14+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 22%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Sun, Dong Wei (IN IT CN RS)
0
Reputation points
commented 2024-12-27T06:19:36.4766667+00:00
Sun, Dong Wei (IN IT CN RS)
0
Reputation points
1 answer
How to display different percent in report
I have set the percentage as 5.2%, when it is 5%, it will show as 5.0%. I want to remove the decimal when it comes with whole value.
asked 2024-12-24T06:39:08.7633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 3%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EY%3C/text%3E%3C/svg%3E)
Yun
40
Reputation points
commented 2024-12-26T02:34:30.77+00:00
ZoeHui-MSFT
39,671
Reputation points
1 answer
One of the answers was accepted by the question author.
Changing the x-axis properties in a SSRS chart does not work when there are negative values.
I want to emphasize the x-axis of a chart in SSRS by increasing its point size. When there are negative values, the axis that shows the emphasis is not the zero value as shown in the picture. The zero line is the one I want to be dark. The labels at the…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(182.40000000000003, 44%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
1 answer
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…
asked 2024-11-07T13:49:08.8166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 79%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBP%3C/text%3E%3C/svg%3E)
Bobby P
231
Reputation points
answered 2024-12-24T03:34:42.0033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 60%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Naveen Kumar M
75
Reputation points
1 answer
SSRS 2019 Custom Form Based Authentication: An error occurred when invoking the authorization extension
Hi, I am upgrading SSRS 2014 to 2019 and custom form based authentication is implemented with SSRS 2014. I followed the steps https://github.com/microsoft/Reporting-Services/tree/master/CustomSecuritySample and implemented same for SSRS 2019. While Web…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 82%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E3%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Go to url does not work
Does anyone kown why go to url doesn't work in my report. I'm using "http://www.test.com" in the expression. But it does not go to the url when clicking.
1 answer
SSRS no longer sorts History snapshots
WE have several reports in Microsoft SQL Server Reporting Services that are on a snapshot schedule. The history snapshots no longer view sorted by created and Created can no longer be clicked to force a sorting. Is there a way to default a sort on the…
asked 2024-12-20T14:00:22.68+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 23%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
Claudia Rodrigues
0
Reputation points
answered 2024-12-23T03:08:59.2533333+00:00
ZoeHui-MSFT
39,671
Reputation points