SQL Server Reporting Services

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…

while installing sql server developer , shows up error decompressing media server ?

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

"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…

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…

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?

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?

Visual Studio

Visual Studio

A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.

4,667 questions

Sign in to follow

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,818 questions

Sign in to follow