-
Scenario: You need to configure a Power View report to show data for a dynamic date, such as the current date or the last date with data. However, as it stands Power View doesn't support expressions. Workaround: Add a Boolean calculated column to the Date table that returns TRUE for the date of interest...
-
Nevron was kind enough to show me their chart and gauge for Reporting Services. In certain areas, their products exceed the charting capabilities of Reporting Services. Here are the highlights: The product provides support for SQL Server Reporting Services (SSRS) 2005, 2008, 2008R2 and SQL Server Data...
-
Microsoft announced yesterday the availability of the Community Technology Preview (CTP) of Microsoft SQL Server 2012 With Power View for Multidimensional Models (aka DAXMD). As a participant of the CTP program and I'm very excited about this enhancement. Now customers can leverage their investment...
-
7762.Geography.xlsx Power View in Office 2013 brings the following new features: Integration with Excel 2013 – Microsoft has decoupled Power View from SharePoint and included it in Excel so you can create ad-hoc reports connected to BI models, just like you can create pivot reports. I hope the...
-
In a current project, international users indicated that they prefer dates and numbers to be formatted using their regional settings. Localization is a big and complicated topic and we've been fortunate that the scope was limited to just number and date formatting … or, at least so far. Localizing...
-
A long time ago, I wrote a blog about possible reasons for Reporting Services reports to time out. This issue raised its head again; this time in SharePoint 2010 environment where long running reports would time out after about 2 minutes. To resolve: On each Web Front End (WFE) server, edit the web.config...
-
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...