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.
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
create sp to populate table from one db to another
Hi, how to create Store procedure to populate data from one database table to another database table and do we need to refresh or it will auto sync
Creating Dataset in VS2020 using SQL query rather than visual designer
I'm creating .rdlc reports using the extension in Visual Studio 2022, but when creating Datasets, I'm only able to do using the graphical designer and cannot create or edit Datasets by writing my own SQL. What am I missing?
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…
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
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..?
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…
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…
SSRS is restricting excel report to 35 tabs.
SSRS is restricting excel report to 35 tabs (pages). Workingsetmaximum is set to 8 GB. Is there some setting that i can change so that the number of pages is not restricted?
Sql server reporting issue on save and print the data
Hi Team, customer facing weired issue on reporting url that is customer can't save and print the output but customer can able to pull the data. I verified with customer for any errors but I don't see any…
How do I hide subreport option from the Reportin g Services screen?
I am a SSRS newbie, so pardon simple questions. I created two main reports. One report has hidden reports within. The other report has sub-reports. When I deployed the programs to Reporting Services, the sub-reports appear as selection options. How do I…
SSRS 2022 - Subscription Error when Scheduling to Run each Month on 10th 20th or 30th (Error: Invalid Days)
Unable to create/modify SSRS 2022 report subscription to run each month on the 10th, 20th or 30th. Example Schedule settings (See screenshot below): Schedule: Month Months: All months selected On calendar day(s): 20 (But is the same result if 10 or…
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 :
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…
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_'.…
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…
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…
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