dbTalk Databases Forums  

XMLA + Reporting Services in MS SQL Server 2005

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss XMLA + Reporting Services in MS SQL Server 2005 in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Marco
 
Posts: n/a

Default XMLA + Reporting Services in MS SQL Server 2005 - 02-13-2006 , 03:04 AM






Hi,

Any idea why you can't first open a Reporting Services report and then
a XMLA OLAP report based on SQL Server 2005. No data available in the
OLAP report.

If you first open a XMLA OLAP Report and than Reporting Services report
you see both data in the report. But opening again a XMLA OLAP Report
ends with no data.

A bug in SQL Server 2005 or should a setting be changed ?

Regards, Marco


Reply With Quote
  #2  
Old   
Jorg P. Kuck
 
Posts: n/a

Default Re: XMLA + Reporting Services in MS SQL Server 2005 - 03-30-2006 , 08:31 AM






[This followup was posted to microsoft.public.sqlserver.olap and a copy
was sent to the cited author.]

Hi,

I experience the exact same problem with Reporting Server 2005 using
Analysis Server 2005 as a data source.

This issue was also addressed by another poster (JasonF) on Jan. 8th.

Here is his original message:

********************************************
I am trying to create a report in SQL Server 2005 Reporting Services
using an Analysis Server 2005 database as my Data Source. There are a
couple of issues that are happening. First after I build my query and
run a preview of the report the query is not saved when I got back into
the data tab.

Then when I try to re-create the query and go back in the preview tab VS
2005 shuts down with a fatal error.
********************************************


Is there any news on the status of this issue?

Regards
--
Jorg




In article <1139821449.955172.14030 (AT) g47g2000cwa (DOT) googlegroups.com>, you
say...
Quote:
Hi,

Any idea why you can't first open a Reporting Services report and then
a XMLA OLAP report based on SQL Server 2005. No data available in the
OLAP report.

If you first open a XMLA OLAP Report and than Reporting Services report
you see both data in the report. But opening again a XMLA OLAP Report
ends with no data.

A bug in SQL Server 2005 or should a setting be changed ?

Regards, Marco



Reply With Quote
  #3  
Old   
Marco
 
Posts: n/a

Default Re: XMLA + Reporting Services in MS SQL Server 2005 - 04-06-2006 , 02:56 AM



Hi,

Is this problem solved with ssas2005 sp1 ?

Regards, Marco


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.