In AS2k I found myself writing 2 separate MDX expressions for doing this - I even had 2 separate cubes for this purpose. I found this easier for me and...

Thanks Steve.

It seems it's an Office2k issue. I installed Office 2003 and without touching my OLAP side everything seems to work the way I want. BTW, I did check the...

Thanks Steve.

I checked the example and it gives me less than what I'm trying to get.

My business case is that the user choses a Time level (year, quarter or month)...

If I understand the requirement, it's simple if the report is already defined in RS. From "Report Manager" if you chose to export to Excel, you get the tables and...

Good news!

The settings I had were correct and I did not need to setup the SMTPAuthenticate. The email subscriptions work BUT only if I remove the flag to include the report...

Hi there.

I'm having the same problem with publishing reports via email. Checking this issue for the last week I've been offered to install RS SP1, which I did. This did...

Hi Susan.

I assume that the report has been designed and previewed. You then need to DEPLOY the report. It goes to the Report Manager (find it on the Reporting Services leaf...

It works now - don't know why!

Still, it's only copying the data and replacing the info in the table. Anything I need to do to "append" the data in the...

I've installed SQLXML 3.0 but still no success. Maybe someone has done this before? I'm trying get some grip on this process so I can use it in a Business...

Thanks for the hint but...

The SQLBulkLoad.3.0 does not work on my machine, so I replaced the statement by BulkLoad.2.0

The error remains. It's referencing the line of the objBL.Execute even if...

I've litterally copied the example code from the MS web site. Here it is (with my parameters)

Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad")

objBL.ConnectionString = "provider=SQLOLEDB.1;datasource=JMRSQLBI;database=MyDatabase;uid=test;pwd=test"

objBL.ErrorLogFile = "c:\xml\MyError.log"

objBL.Execute "c:\xml\MyCustomermapping.xml", "c:\xml\MyCustomers.xml"

Set objBL = Nothing

MyCustomermapping.xml stores...

I tried the suggestion of the MS article 316005 and I can not go past the described error "Error connecting to the data source" even though I copied the code...

Thanks for replies. I think that I had a bogus version of the SQL Server engine. It come from the fact that I installed MSDE and Analysis Services only (did...