SSRS Report Subscription Windows Share File Option Failed
We have configured SSRS Report Subscription export report automatically and place the file in shared path location, we did all the configurations but getting error like "Failure writing file acctbalrw : The permissions granted to user '' are…
Microsoft.ReportingServices.ReportViewerControl.WebForms version 150.1404.0 returns invalid HTML for Reserved.ReportViewerWebControl.axd?ResourceStreamID=Blank.gif
The HTML returned by the reporting services viewer is missing the " at the end of the src attribute. It's resulting in: <img…
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
does report builder work with AWS RDS MySQL database instances
Hi, I am trying to use ms Report builder with a AWS RDS MySQL database, but am struggling to set up the datasourse. Can you help ? Thanks
why ssms 20.1 Cannot Open ?
Why my ssms 20.1 that was downloaded on 04/14/24, always run the same popup page message as in the attatchment ? if i choose repaired and wait it finishes and then reboot the computer, the same popup message pops again. Even that I have uninstall the…
Which .NET Framework versions can be used for installing Microsoft Report Builder
My question refers to this page: https://www.microsoft.com/en-us/download/details.aspx?id=53613 I need to install Microsoft Report Builder. According to the install instructions, it says .NET framework version 4.6 needs to be installed first. If I…
SSRS 2022 upgrade breaks report
After upgrading my SSRS 2022 instances from 16.0.1113.11 to 16.0.1115.61, my reports that usually displays a few columns coming from a stored procedure does not display the results anymore (only lines with blank data in all differents browser). ->…
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…
SSRS UnhandledReportRenderingException
Current environment: SSRS: 16.0.1115.92 SQL Server instance: Microsoft SQL Server 2019 (RTM-CU26) (KB5035123) - 15.0.4365.2 (X64) Enterprise Edition (64-bit) on Windows Server 2016 Datacenter 10.0 <X64> (Build 14393: ) (Hypervisor). When we…
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
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 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…
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…