Xcelsius and SQL Server 2008 Reporting Services

I am totally and utterly p1$$3d off and surely I cannot be the only person to be using a similar setup i.e. Xcelsius along with SQL Server 2008 Reporting Services.

I have installed and tried to get working the XRS gateway and get connectivity to Reporting Services so that SSRS reports can be utilized with Xcelsius… BUT NO…

when trying to configure and use the GetReports command from the xrs.asmx web file I get an error, namely:

<?xml version="1.0" encoding="utf-8" ?> [b]*Client found response content type of '', but expected 'text/xml'. The request failed with an empty response.* [/b] at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsoft.ReportingServices.ReportingService.ListChildren(String Item, Boolean Recursive) at Microsoft.ReportingServices.CatalogManager.CreateXmlNode(XmlDocument Doc, CatalogItem Item, XmlNode ParentNode) at Microsoft.ReportingServices.CatalogManager.SerializeToXML() at Infommersion.XRS.Service.GetReports()

Only to be told when I logged a support call with SAP, that “SQL Server 2008 Reporting Services is NOT SUPPORTED”
please go back to using 2005!!!

I find this totally and utterly unbelievable, it’s not even as if its a new product… and surely i am not the only person using Xcelsius and wanting to utilise 2008Reporting Services Reports…

has anyone come across this error or understand what is not occuring to get this message and how to resolve?

yours eternally grateful if anyone can shed light on the matter

dean


DTM :new_zealand: (BOB member since 2004-03-24)

First things first! It works with MS Reporting Services 2005.
Second … when support says RS 2008 is not supported, they really mean it!
I suggest waiting for another SP/FP to come out.


aneelf (BOB member since 2006-05-15)