RS2005 reports to AS2000 cubes

Hello,

I am using RS 2005 to design reports.

There's no problem when I connect to an Analysis Services 2005 cube.

But when I try to connect to an AS 2000 cube (Foodmart)...

I have read in this forum that I can use "Microsoft SQL Server Analysis Services" provider (or OLE DB)...

Can someone help me please!!

Thank you

What happens when you connect to 2000 cubes? Do you get any error ?

Raj

|||

hello,

I've got SQL 2000 and AS2000 in a machine

And, SQL 2005 and AS2005 in other machine

both are in the same net

I do a new "report server project".

Start generating a new datasource

I select "Microsoft SQL Server Analysis Services" type

And edit the "connection properties"

In the server name, I introduce the IP address

But no database is displayed in the combo

Thanks,

urtzi