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,988 questions
2 answers
One of the answers was accepted by the question author.
SSIS package failed to run
Fail to run the package from agent job. It said unexpected error. But when i run it in VS project it works.
![](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(272, 45%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
1 answer
SSRS 2019 permissions granted to user domain\user are insufficient
Reporting Services Error The permissions granted to user 'DOMAIN\user' are insufficient for performing this operation. (rsAccessDenied) Get Online Help I had this issue in the past with Windows 10 and the solution was to run it in IE 11 under…
asked 2023-02-14T03:24:48.44+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(16, 84%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYS%3C/text%3E%3C/svg%3E)
Yosef Shellim
21
Reputation points
commented 2025-02-03T19:39:48.62+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(124.80000000000001, 22%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Jay McKinney
0
Reputation points
2 answers
One of the answers was accepted by the question author.
SSRS Report Server Connection refused
Hello, i have trouble with SSRS, when i try to connect on the local Server via http://localhost/reports or http://localhost/reportserver the connection is refused. On the machine there are SQL Server2022 and SSRS 2022 installed. I checked the services…
asked 2025-01-24T10:22:22.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(268.8, 18%, 36%)' 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)
Martin Wegner
20
Reputation points
accepted 2025-02-03T06:39:05.5666667+00:00
Martin Wegner
20
Reputation points
4 answers
Transient error in SSRS reports.
When we open a report in SSRS web service url it sometimes fails with the below error. When the same report is opened in web portal url with the same account, it opens with no errors. If we open an SSMS session with the same user and run any stored…
asked 2025-01-22T05:16:44.49+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(294.40000000000003, 41%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENR%3C/text%3E%3C/svg%3E)
Nivedita Rao
0
Reputation points
answered 2025-02-03T06:03:43.1533333+00:00
ZoeHui-MSFT
40,131
Reputation points
1 answer
extensionfactory!ReportManager_0-13!5100!01/24/2025-08:59:30:: w WARN: The extension Report Server Email does not have a LocalizedNameAttribute. extensionfactory!ReportManager_0-13!5100!01/24/2025-08:59:30:: w WARN: The extension Report Server FileShare d
extensionfactory!ReportManager_0-13!5100!01/24/2025-08:59:30:: w WARN: The extension Report Server Email does not have a LocalizedNameAttribute. extensionfactory!ReportManager_0-13!5100!01/24/2025-08:59:30:: w WARN: The extension Report Server FileShare…
asked 2025-01-24T05:55:20.9466667+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(102.4, 82%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Shubham Sunil Mehetre-MIBS
0
Reputation points
answered 2025-02-03T05:46:06.78+00:00
ZoeHui-MSFT
40,131
Reputation points
asked 2025-02-02T00:42:16.32+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, 50%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMC%3C/text%3E%3C/svg%3E)
Malla, Cydrx Ian
0
Reputation points
answered 2025-02-03T02:48:02.1766667+00:00
ZoeHui-MSFT
40,131
Reputation points
2 answers
sql server reporting services - sub reports appearing over top of each other / lots of blank pages.
I have 2 places in my main report where 2 sub reports are appearing on top of each other. I have checked the tablix in the main report and selected: Add a page break before. I event tried checking add a page break after, but that does not separate the…
asked 2025-01-29T21:06:30.9033333+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(291.2, 52%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERW%3C/text%3E%3C/svg%3E)
RCDA Webmaster
291
Reputation points
answered 2025-02-03T01:27:32.0266667+00:00
ZoeHui-MSFT
40,131
Reputation points
2 answers
Microsoft Report Builder - Full width summary row in a child group
I have an SSRS report containing a parent and child row group. At present, this displays as: I want to add a summary row to the "Child Group" but have it span the entire row. For example: I also want the data for the "Parent Group" to…
asked 2025-01-30T13:01:55.2366667+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(44.800000000000004, 59%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPB%3C/text%3E%3C/svg%3E)
Peter Bishop
181
Reputation points
answered 2025-02-03T01:15:50.75+00:00
ZoeHui-MSFT
40,131
Reputation points
3 answers
asked 2024-06-03T08:19:20.6533333+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(57.599999999999994, 46%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Cydrx Malla
5
Reputation points
commented 2025-02-02T00:33:11.85+00:00
Malla, Cydrx Ian
0
Reputation points
2 answers
SSRS Subscription issue - fail with permission issue
HI, I am facing issue with SSRS subscription, it use to work for different user but I have changed the user/owner and it is not working. It is giving below error and the new user has same role as old user. The user used for shared…
asked 2021-10-25T09:36:16.163+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, 23%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
Eshwar
196
Reputation points
answered 2025-01-31T10:41:49.08+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(182.40000000000003, 62%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENB%3C/text%3E%3C/svg%3E)
Nathan Bolstad
0
Reputation points
2 answers
Configuration Manager Notification SQL version
CM v2403. Why does "Configuration Manager Notification" warn us that we need to update "SQL" if our installation is version 2019 ? https://go.microsoft.com/fwlink/?linkid=2280831 Is anyone else receiving this notification despite…
asked 2024-11-27T10:15:59.8433333+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, 24%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
Vid3al
181
Reputation points
answered 2025-01-29T11:50:20.63+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(0, 99%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Mr M Bridger
0
Reputation points
2 answers
SSRS sub reports passing values
I have a main report with a bunch of sub reports. I'm trying to pass a parish ID to the sub report from the query field [par_num]. Sub Report: The query's Parameter: Parameter Name @ParishID Parameter Value @ParishID Query…
asked 2025-01-27T18:24:32.15+00:00
RCDA Webmaster
291
Reputation points
answered 2025-01-28T16:40:32.9566667+00:00
RCDA Webmaster
291
Reputation points
1 answer
Wire up a shared dataset in SSRS REST API
Using the SSRS REST API , I can deploy a report from PowerShell in an automation pipeline. But how do I use the API to wire it up to our predefined Shared DataSources? The PUT Reports({Id})/DataSources endpoint doesn't seem to be for Shared…
asked 2024-05-10T03:57:09.2633333+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(108.80000000000001, 65%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEH%3C/text%3E%3C/svg%3E)
Ed Havelaar
1
Reputation point
commented 2025-01-27T22:19:34.1666667+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(99.2, 47%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Siddhartha Thirunagari
0
Reputation points
2 answers
Installed Software Inventory Count without being broken up by version information SCCM
Installed Software Inventory Count without being broken up by version information SCCM
asked 2025-01-23T17:59:40.9466667+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(278.4, 57.00000000000001%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDJ%3C/text%3E%3C/svg%3E)
Denning, James
0
Reputation points
edited an answer 2025-01-24T06:27:28.45+00:00
AllenLiu-MSFT
47,706
Reputation points Microsoft Vendor
3 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
answered 2025-01-23T14:28:46.1766667+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, 19%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
Garth
806
Reputation points
1 answer
One of the answers was accepted by the question author.
What will be the REST API URL for the SSRS to be embedded in the Blazor Server Application?
I am working on adding the SSRS based reports into the Blazor Sever Application. SSRS Configuration is working fine and I can access SSRS on browser as well. I searched for different methods to implement the SSRS reports (created using MS Report…
asked 2025-01-22T10:49:43.2466667+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, 53%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Aima Maqsood
25
Reputation points
edited an answer 2025-01-23T07:56:44.1466667+00:00
ZoeHui-MSFT
40,131
Reputation points
2 answers
How to export from SSRS some blank columns in a report that user will be entering data into appear as text?
Currently, the exported Excel columns are of type General and when user enters values like 06-71, iit converts it to a date format. However, it should be treated as text and remain as is.
asked 2025-01-22T23:47:43.7+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, 70%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Manveet Kaur
0
Reputation points
answered 2025-01-23T06:26:52.0333333+00:00
Olaf Helper
45,786
Reputation points
1 answer
One of the answers was accepted by the question author.
Get month name in report
How to get current month name in SSRS report？For today i want to get the value like January
asked 2025-01-22T08:16:45.3+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, 96%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ2%3C/text%3E%3C/svg%3E)
Jefferson-2765
586
Reputation points
accepted 2025-01-23T06:05:47.9233333+00:00
Jefferson-2765
586
Reputation points
2 answers
Can SSRS 2022 Developer edition will be installed with SQL Server 2019 standard edition?
We would like to know: Can we install the SSRS 2022 developer edition with SQL Server 2019 Standard Edition? We have SQL server 2016 standard edition license already procured, Can we use the same to install the SSRS 2022 standard edition?
asked 2025-01-22T09:18:00.22+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(294.40000000000003, 44%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Chirag Maheshwari
0
Reputation points
commented 2025-01-22T10:58:55.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, 38%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERG%3C/text%3E%3C/svg%3E)
Ravi Garg
0
Reputation points
6 answers
One of the answers was accepted by the question author.
AdventureWorksDW2020 DB is missing a table
Hi, I'm trying to go through the PowerBI lab at this url: https://learn.microsoft.com/en-gb/learn/modules/get-data/lab-prepare I downloaded the AdventureWorksDW2020 from GitHub and loaded into SQL server management studio. 6 tables are…
asked 2020-10-18T18:54:21.503+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(230.39999999999998, 90%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPO%3C/text%3E%3C/svg%3E)
Philip O'Donnell
26
Reputation points
answered 2025-01-21T14:55:54.0433333+00:00
Scott Hay
15
Reputation points