In this article, I will explain
How to show a SharePoint Document Library files with folders and subfolders in SSRS recursively
I have a SharePoint Document Library with multiple folders and subfolders as shown below:
I have tried to retrieve all files, folders, and subfolders from this Document Library in Reporting Service (SSRS) report, but unfortunately, it doesn’t recursively read all the subfolders and files, it only read the root folder and files as shown below:
Continue reading “Show SharePoint Document Library files with folders and subfolders in SSRS”
In this article, I will elaborate How to Scale Out SQL Reporting Service (SSRS) to work with two Database Server (Always-on)?
I have a 2-Tire SharePoint 2013 Farm
- 2 WFE+ APP Servers.
- 2 Database Servers (Always-on).
If you need to use Reporting Services with SharePoint. it’s recommanded to configure SSRS SharePoint integrated mode with Reporting service application service on an indpenedent reporting server to ensure the Performance, Manageability and Security.
But in my case, the customer budget is not enough to apply the best practice, Meanwhile configuring SSRS SharePoint integrated mode with Reporting service application service on the same WFE + APP server lead to low performance.
So I have decided to work with SSRS Native mode to ensure at least the performance and show reports inside SharePoint via:
And in this case, I should configure SSRS Native mode on both SharePoint WFE Servers because as we know the Database Servers are not accessible over the internet,
Note: If you configured SSRS native mode on only one WFE server. you will get it worked properly. but sometimes when browsing the Report Manager URL you will get 404 error!
Continue reading “Scale-Out Deployment for SQL Reporting Service (SSRS)”
When I tried to deploy SSRS reports ,I got the following error:
The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database
Cause : Continue reading “SSRS Error – The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database”
In this article, I will be fixing the below SSRS error
SQL Server Reporting Service Error – Maximum request length exceeded
In SSRS 2008, when I tried to upload a report with size larger than 4 Mb to Report Manager Folder, but I got the below error
When I tried to start SSRS subscription to send weekly reports by e-mail where the prerequisites for SSRS subscription is to be sure that SQL Server Agent is working,so that I opened SQL Server Management Studio to check SQL Server Agent status but unfortunately it stopped !
It’s ease of cake to start SQL Server Agent by right click and select start ! but In my case when I tried to start it I got the following information dialog
Cause: Continue reading “SSRS Subscription Error: SQL Server Agent was unable to start”
During running a SSRS report within a Report Viewer webpart that hosted in SharePoint page via Internet Explorer, I got the following error :
s.ArgumentNullException: Value cannot be null.
Cause: Continue reading “s.ArgumentNullException : Value cannot be null. During running a SSRS report within a Report Viewer via Internet Explorer in SharePoint”
Using Internet Explorer 10 or later, I tried to browse a SharePoint page holds a Report Viewer Webpart to show a SSRS native mode report. but unfortunately, it shows with unexpected behavior as shown below :
Continue reading “Reporting Service render issue within Report Viewer Webpart in SharePoint Server 2013 with IE 10 or later”