-
Issue : Previewing a Report Builder report connected to Analysis Services works in Report Designer but it fails in Report Builder 3.0 with the following error: An existing connection was forcibly closed by the remote host ---------------------------- Unable to read data from the transport connection...
-
To continue my Report Server Settings in SQL Server 2012 SharePoint Integration Mode blog , here is another example of how to use the new PowerShell-based configuration mechanism to hide a rendering extension. In this case, the script finds an SSRS application called SQL Server SSRS (replace with the...
-
I upgraded SQL Server 2012 from RC0 to RTM today on a SharePoint application server which was configured for Reporting Services integration. The upgrade went with no errors but I got this error when requesting reports: The requested service, 'http://amatltapp02:32843/1dacf49a2f7a4a6daa8db5768539893f...
-
SharePoint is a like an ocean – the further you go, the deeper it gets Ancient proverb Scenario : Configure SQL Server 2012 Reporting Services on a multi-server SharePoint farm with the following topology: WEB1 – Web front-end Server 1 WEB2 – Web front-end Server 2 APP1 – Application...
-
As you probably now, Reporting Services doesn't allow you to create subscriptions with data sources that use Windows security because subsbscriptions are run in unattended mode. Moving to SQL Server 2012, we'll add Data Alerts to the list. This presents an issue if you use Analysis Services which...
-
I was just about to write a blog about the new features in the Release Candidate (RC) build of Power View and I saw that Robert had written a great blog already. It's great to see the product coming along so nicely. Can't wait to be able to use multidimensional cubes as data sources! One feature...
-
Well, rules have changed. As Jaime Tarquino from the SSRS team explained in his blog , "SQL Server 2012 Reporting Services SharePoint Integrated Mode", there is no rsreportserver.config file anymore moving to Reporting Services 2012 in SharePoint integration mode (there are no configuration...
-
MDXParameter is a nice little utility that captures MDX queries sent from SSRS reports and replaces parameter placeholders with the actual values. I've been using the excellent Darren Gosbell's Query Capture sample which is one of the first utilities I install when starting a new project. MDXParameter...
-
5736.Product Sales.rdl Problem: How do we stop the maddening parameter refresh for reports that use SSAS cubes? As you've probably found, nothing seems to stop it and the Never Refresh option on the Advanced parameter properties is useless. Solution : Use the OLE DB provider for Analysis Services...
-
SQL Server 2012 introduces a Reporting Services feature called Data Alerts. Data alerts notify a selected list of recipients about data changes on the report. Behind the scenes, data alerts use the report data feeds feature which was introduced in SQL Server 2008 R2. Consequently, similar to subscriptions...
-
Similar to Report Builder models (now obsolete), Power View (formerly known as Crescent) filters metadata automatically. The reasoning behind this feature is that the tool should guide the user to choose only tables that are related to the ones used on the report to avoid Cartesian joins. For example...
-
A client complained that Reporting Services ReportViewer doesn't render reports in Google Chrome or Apple Safari browsers. The magic property to apparently fix this issue was SizeToReportContent="True" < rsweb : ReportViewer ID ="reportViewer" runat ="server" Height...
-
Normally, when you export a report, the Save As dialog box will default to the report name. However, if you the SSRS LoadReportDefinition API and view the report in the ReportViewer, you'll find that when you export the report it will default the name to a system generated name, such as Report(N...
-
One welcome improvement in the forthcoming "Denali" release of Reporting Services is exporting to Excel 2007 (*.xlsx) file formats. I bet many companies will upgrade just to get this feature. In fact, the default rendering option when you export to Excel is to xlsx. The old Excel 2003 renderer...
-
A week ago, I raved about how the new PowerPivot Configuration Tool would simplify configuring PowerPivot for SharePoint. Guess what? Setting up Reporting Services for SharePoint integrated mode got simplified too! In SQL Server Denali, Reporting Services leverages the SharePoint service application...