Friday, November 19, 2010

CTP2 Announcement for "PivotViewer Extension for Reporting Services"

Monday, the 22nd of November 2010 we will launch "PivotViewer Extension for Reporting Services" CTP2. Here is a preview taken out of the release notes:

PivotViewer Extension for Reporting Services CTP2 brings bug fixes as well as new features. This is a list of the changes:



1. Bugfix: PivotViewer Extension for Reporting Services and its sample data does not install in a subsite. The bug was fixed in CTP2. Please follow the “Migration from CTP1 to CTP2” chapter in this document or install CTP2 on a machine that never had CTP1 installed on it. Please see the forum question http://social.msdn.microsoft.com/Forums/en-CA/sqlkjpowerpivotforexcel/thread/7664690b-ea78-488f-9703-0ffd458422f0 for a discussion on this CTP1 issue.


2. Bugfix: installBIPivot.ps1 PowerShell script is not digitally signed. The bug was fixed in CTP2 (the script is now digitally signed). Please see the forum question http://social.msdn.microsoft.com/Forums/en/sqlkjpowerpivotforexcel/thread/29aa2101-5210-4a5b-81b8-d9fadef0524d for a discussion on the CTP1 issue.


3. Bugfix: PivotViewer Extension for Reporting Services does not work if the data contain null values. In CTP1 there was the workaround to change the data in order to avoid nulls (e.g. put a special value, like -1 in lieu of null). The bug was fixed in CTP2.


4. Bugfix: PivotViewer Extension for Reporting Services does not work if numeric values have too large or too small exponent. The issue was that numeric data was considered to be double. The default serialization of doubles will change to the scientific notation if the exponent is above 14 or below -4. The bug was fixed in CTP2 (by considering numeric data as decimal instead).


5. Feature: Support for arbitrary OleDb data. CTP2 supports now generic OleDb providers (e.g. Oracle or DB2) for building applications. This is in addition to the datasources supported in CTP2: PowerPivot (and Analysis Service) via Adomd.NET and SQL Server (via SqlClient). Please see more details in the “Supported Data Sources” chapter of the “PivotViewer Extension for Reporting Services.docx” document that is part of this distribution.


6. Feature: Support for links in facet data. CTP2 supports now hyperlinks in facet data. Please see more details in the “Dataset Query Specification” chapter of the “PivotViewer Extension for Reporting Services.docx” document that is part of this distribution.


7. Feature: Support for multivalued facet data. CTP2 supports now multivalued facet string data. Please see more details in the “Dataset Query Specification” chapter of the “PivotViewer Extension for Reporting Services.docx” document that is part of this distribution.

Stay tuned for when the new bits are live!!

3 comments:

  1. Thanks Christian! We're already using it at customers with great success.

    Morten

    ReplyDelete
  2. Thanks! Don't know how anybody coped without #7 as almost every collection we have needs this feature. And nulls, so we are good to go...

    ReplyDelete