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,855 questions
1 answer
SSRS Installation requires Key but with preinstalled/configured you do not have a key
Deployed a VM in Azure with SQL 2019 and Server 2019 I need to get SSRS installed on the Server When running the install of SSRS you would need a key, but with the preloaded SQL we did not receive a key How do I get the key
asked 2024-05-21T08:00:50.9433333+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, 19%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELS%3C/text%3E%3C/svg%3E)
Louis Smith
0
Reputation points
answered 2024-05-22T05:05:16.8233333+00:00
Olaf Helper
42,761
Reputation points
1 answer
SQL Server 2022 Reporting Services 16.0.8886.1775 does not render map points correctly
Version 16.0.8784.14010 renders correctly. The Visual Studio SSRS extension 3.0.10 also renders the report correctly. Seems to be a bug in the latest version 16.0.8886.1775. Helped me to downgrade to version 16.0.8784.14010.
asked 2024-05-21T12:13:20.97+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(172.8, 11%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVR%3C/text%3E%3C/svg%3E)
Vavra Roman MT-CZ
0
Reputation points
answered 2024-05-22T02:12:52.87+00:00
ZoeHui-MSFT
34,836
Reputation points
1 answer
SSRS CSV export issue
I have a SSRS report with dynamic column and also Column display order is getting handle through parameter "ColumnOrder". Once I generate the report it works fine and based on column order it display columns on report. Once I export it to CSV…
asked 2023-08-25T13:16:20.0366667+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(272, 69%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Arvind Singh Gusain
5
Reputation points
commented 2024-05-21T14:36:22.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(297.6, 13%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Karthiga Murugan
1
Reputation point
4 answers
Enterprise Report Server not showing Data Driven Subscriptions
We have updgraded from Standard to Enterprise reporting services. We were expecting to have the option to create data-driven subscriptions but the option is not available. All the articles found during our web search say 'Data-driven subscriptions' will…
asked 2024-04-29T21:26:46.1566667+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(281.6, 72%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
Linda
1
Reputation point
answered 2024-05-17T07:20:47.92+00:00
ZoeHui-MSFT
34,836
Reputation points
1 answer
One of the answers was accepted by the question author.
Performance Monitoring tools used for 4 hrs
Using Performance Monitoring tool to check on the performance of the database server. I cannot extend the duration to more than 1000 secs. What are the other options for performance monitoring so that I can get the data for 4 hrs
![](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(51.2, 55.00000000000001%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
1 answer
Auditing SSRS Administrator role events
We have multiple users assigned to Administrator role of our SSRS product. So, how shall we audit what those individuals have done with the power of Administrator role, such as changing folder/report securities, deleting/adding folders/reports etc..?
asked 2023-01-17T12:10:35.6433333+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, 30%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Ayca Akcay
26
Reputation points
commented 2024-05-16T14:57:12.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(188.79999999999998, 99%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF%3C/text%3E%3C/svg%3E)
FodorT
0
Reputation points
1 answer
Emoji Rendering Issues in SSRS-Generated PDF
I'm encountering issues with emoji representation in PDF and PowerPoint outputs from SQL Server Reporting Services (SSRS). Despite successfully displaying emojis in Word documents that are rendered through SSRS, the same emojis are not appearing…
asked 2024-05-15T15:48:05.93+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(169.60000000000002, 69%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Abdullah Riaz
0
Reputation points
answered 2024-05-16T02:56:24.8966667+00:00
ZoeHui-MSFT
34,836
Reputation points
1 answer
SSRS - Unable access the Report Server Web portal URL's
We have SQL Server Reporting Services. Nothing has been changed but users are not able to access to Reports Web URL. We are unable to access the URL on the same machine where the Report Server Configuration Manager is running. Checked the SQL connection…
asked 2024-05-01T07:49:37.3766667+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(131.20000000000002, 17%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYB%3C/text%3E%3C/svg%3E)
Yashwanth Bellum
0
Reputation points
commented 2024-05-16T02:31:59.9066667+00:00
LucyChenMSFT-4874
2,825
Reputation points
2 answers
One of the answers was accepted by the question author.
Add grand total of stack bar report in SSRS
Hi Team, How to add grand total in chart reports. I need grand total as highlighted in out put screenshot Input Chart: Out put :
asked 2020-12-04T04:14:59.763+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(201.6, 0%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBN%3C/text%3E%3C/svg%3E)
Bala Narasimha Challa
466
Reputation points
commented 2024-05-15T14:27:18.7133333+00:00
Christopher George
0
Reputation points
1 answer
How to grant a single SSRS User access to multiple folders
Is there any way to grant a SSRS login the same level of access to multiple folders in one shot instead of going through each and any Folder that has "custom" security or in other words not inherited from parent "Home"? In new SSRS…
asked 2024-05-13T20:20:43.9433333+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, 54%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
Nenea Nelu
66
Reputation points
answered 2024-05-14T05:51:29.42+00:00
ZoeHui-MSFT
34,836
Reputation points
1 answer
One of the answers was accepted by the question author.
Keep getting this error regardless to the accoun tused
SQL server 2022 / SSRS 2022, getting this error even when using an admin account An error has occurred during report processing. (rsProcessingAborted) Cannot impersonate user for data source 'AutoGen__5C6349F2_4BB6_4a1b_A16E_8D69795D8602_'.…
![](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' %3EA%3C/text%3E%3C/svg%3E)
1 answer
SSRS Report Viewer windows forms - The request failed with an empty response
Dear all, we use the following component in our Windows Form (.net 4.7.2 application): Microsoft.ReportingServices.ReportViewerControl.Winforms 150.1620.0 Since we migrated our server on a new domain, we are getting sometimes the following execption in…
asked 2024-05-10T13:16:20.6633333+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(166.4, 53%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
SERIOLI, MARCO (MSTI)
0
Reputation points
edited a comment 2024-05-13T07:33:50.7866667+00:00
SERIOLI, MARCO (MSTI)
0
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
edited an answer 2024-05-13T03:01:47.04+00:00
Ed Havelaar
1
Reputation point
6 answers
One of the answers was accepted by the question author.
remove values from string
Hi Expert, how will i remove all the characters from values in sql Create table test1 (id string, details string) insert into test1 values('20kjk','3ddf') Regards
asked 2022-08-17T10:50:23.187+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(140.8, 75%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Shambhu Rai
1,406
Reputation points
answered 2024-05-11T10:29:32.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(307.2, 74%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEB%3C/text%3E%3C/svg%3E)
Ebrahim Bazarjani
5
Reputation points
2 answers
"Could not find the Database Engine startup handle" while trying to install SQL server 2022 Express Edition
Hello, I upgraded my computer to Windows 11 and that's why there was a problem in my SQL server. I deleted the SQL Server 2022 application and restarted the computer. Later, I encountered an error while trying to install SQL Server 2022 Express. Unable…
asked 2024-04-12T12:42:24.9666667+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, 50%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHK%3C/text%3E%3C/svg%3E)
Hakan KARATEKE
0
Reputation points
commented 2024-05-10T05:47:47.7+00:00
MikeyQiaoMSFT-0444
1,590
Reputation points
1 answer
How do I retain SSRS group expansion when an interactive sort is performed on a header?
I have a very simple SSRS report. Data is grouped, and upon initially running the report, the data is collapsed into two groups. I show totals for the group, and have the + sign to expand either. ALL GOOD. When I expand the first group, I see the…
asked 2024-05-09T13:59:50.4866667+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, 65%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFT%3C/text%3E%3C/svg%3E)
Feuerborn, Thomas
0
Reputation points
answered 2024-05-10T02:18:11.7266667+00:00
ZoeHui-MSFT
34,836
Reputation points
2 answers
How to share a report in SQL Server Reporting Services
I need to create a link to share a report that I created in SQL Server Reporting Services with other users. What is the best way to do this?
asked 2024-05-08T15:58:59.96+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(131.20000000000002, 2%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Susan Moore
0
Reputation points
answered 2024-05-09T02:03:38.2433333+00:00
ZoeHui-MSFT
34,836
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.…
asked 2022-11-21T10:40:33.883+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, 89%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Safa
1
Reputation point
commented 2024-05-08T15:01:35.78+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(272, 61%, 36%)' 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)
Mbahuma, Karel Rhomaanes
0
Reputation points
1 answer
How to pass multiple value for a postgres function in SSRS
I have created a report which is using postgres sql function and there are parameters for start date, end date and physician name. I am trying to pass multiple value for physician name and it is not working for me: This is how I am calling the function…
asked 2024-05-07T14:10:33.6366667+00:00
Ali Ahad
111
Reputation points
answered 2024-05-08T02:23:42.25+00:00
ZoeHui-MSFT
34,836
Reputation points
3 answers
One of the answers was accepted by the question author.
Power BI Reporting Server on Standard DB Engine
Is it possible for the .pbix files to work correctly when the Power BI reporting server (PBIRS) is installed on a Standard DB Engine? According to the below link, it looks contradictory as while it states that Standard edition is possible, it also…
![](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, 25%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)