In my previous blog post, I had shared how you can leverage SQL Server Performance Dashboard SSRS Reports for monitoring and point in time troubleshooting for large deployments of SQL Server. In this post, we will talk about why dbas should establish SQL Server Performance baselines for their environment and how you can leverage the… Continue reading SQL Server Performance Baselining Reports Unleashed for Enterprise Monitoring !!!
Category: SSRS
SSRS Report in Sharepoint Integrated Mode times out execution after 110 sec with unexpected error
Recently we faced a weird error while deploying an SSRS Report in a document library in SharePoint. The SSRS Report was meant to be a Drill Through Report which was to be used as Detailed Report in PPS Dashboard exposed via SSAS Reporting Action. Being a Detailed Report it was expected to fetch a lot… Continue reading SSRS Report in Sharepoint Integrated Mode times out execution after 110 sec with unexpected error
SAML Authentication support with SQL Reporting Services
Couple of days back I received the following set of questions from a customer and in this blog post I would like to discuss the answer to his question for the benefit of others How to get SSRS working with SAML Claims Authentication? If SSRS in Native Mode doesn’t support SAML Authentication how does Microsoft… Continue reading SAML Authentication support with SQL Reporting Services
SQL Reporting Services Performance Tuning Tips & Tricks
It has been really long time since I have blogged. However I will try to blog as often as I can. Very Recently, I performed a SSRS Performance Review to tune performance reports for one of our customers. While analyzing some long running reports we identified some usual issues which may not be aware while we are… Continue reading SQL Reporting Services Performance Tuning Tips & Tricks
Improving the Performance of the reports by simplifying Drilldown Report to Drill through Report
Recently one of my customers in IT industry, had a P&L drilldown report aggregating the P&L metrics from the company level->client level ->account level -> project level -> employees at the row level while aggregating the data across date hierarchy Calendar Year->Calendar Semester ->Calendar Quarter -> Month at the Column Group Level with Adjacent Column… Continue reading Improving the Performance of the reports by simplifying Drilldown Report to Drill through Report
Placing a Drillthrough Report in a different folder in SQL Server Reporting Services
When you design a drillthrough report in your reporting server project using BIDS, while adding the drillthrough actions for the report, in the dropdown you only get option to select the reports (rdl files ) designed in the same project. Hence when the entire project is uploaded, all the drillthrough reports can deployed in the… Continue reading Placing a Drillthrough Report in a different folder in SQL Server Reporting Services
How to prevent firing of subscriptions when there is no data in Report?
Many times it is annoying to receive email alert when there is no data in the report. Generally such cases happen when you have scheduled an email subscription for a report which fires at the specified schedule and delivers the report. However as an end user you might be interested to receive an email alert… Continue reading How to prevent firing of subscriptions when there is no data in Report?
Analytics for Report Server Execution Log using PowerPivot
As we all know, Report Server Execution Log plays a significant role and is the first place to look into in order to analyse & optimize the Performance of Reporting Services. Hence in each version of SQL Server, the ExecutionLog view in Report Server database is enhanced to gather more and more information. If you… Continue reading Analytics for Report Server Execution Log using PowerPivot
Unable to use Calculated Measures in MDX inside Category Groups of Chart Report Item in Reporting Services
Recently, one of our customers came across an interesting issue which many of us face while working with Reporting Services which fetches the data from Analysis Services cube using MDX. So I thought I will share this in this blog post for the benefit of the community. We have a following MDX query with Calculated… Continue reading Unable to use Calculated Measures in MDX inside Category Groups of Chart Report Item in Reporting Services