Thursday, December 13, 2012

SSRS reports on the IPad or IPhone has been improved since SQL 2012 SP1

Almost 2 years ago I wrote a blogpost about SQL Server Reporting Service (SSRS) Reports on the IPad or IPhone. I was the first time you could display SSRS reports on the IPad. Unfortunatly not everything was rendered in a correct way. In SQL Server 2012 SP1 this has been improved.

Here is an example of a report in SQL 2008 R2

 Here is an example of the same report in SQL 2012 SP1
As you can see, the strange Blue Question marks are gone.

Starting with SQL 2012 Service Pack 1 (SP1), Reporting Services supports viewing and basic interactivity with reports on Apple iOS devices like IPad en Iphone, with the Apple Safari browser.
Viewing reports in Report Manager (http://myserver/reportserver) is not suppported. You need to start the reports from the report server via http://myserver.reports. Here you can browse to the report and tape the report name to open the report. After opening the report yiu can see that the Export to PDF and TIFF file is supported. More information about the support for Apple iOS devices on SSRS can be found here.
For a video of using SSRS on your Ipad please see:

Monday, December 3, 2012

PowerPivot fieldlist is grey and not selectable

Sometimes my PowerPivot field list is grey and can't be selected. It can happen when you are busy in an existing PowerPivot sheet. It looks like a bug because a restart of Excel solved my situation.

  • Save your Power Pivot Sheet
  • Close all other Excel sheets
  • Close Excel
  • Check in task manager if Excel.exe is not running
  • If Excel.exe is still running, kill this task
  • Start Excel
  • Open your Power Pivot sheet
  • Click on a graph and you should be able to select the Field list.
Unfortunatly, is is not clear when and how this happens. I'm using Power Pivot version 11.0.3000.0