July 25, 2003 at 9:01 am
I have been trying to connect Crystal Reports to an Analysis Services Cube. Although utilizing Ole Db OLAP Services allows me to see the Cube I am getting all kinds of errors.
Can someone please tell me where I need to go in order to get the Driver (I believe it is Version 8).
I really need help soon.
Thx, Scott
July 27, 2003 at 1:34 am
Hi Scott,
have you got the latest MDAC installed on the client machine (ie where the crystal is installed)?
When you try to connect, do you see one or two MSOLAP drivers? If you see two, and you're trying to connect to AS2000, then ensure you use the driver with the higher number.
HTH,
Steve
Steve.
July 29, 2003 at 6:20 am
Steve, I am utilizing Microsoft OLE DB Provider for OLAP Services 8.0. It makes the connection, sees the cube, but when I drag and drop a field onto the crystal report and run it I get a "no rowset returned" AND a "DLL" error.
Any Ideas as to what I am doing wrong.
Thx, Scott
Hi Scott,
have you got the latest MDAC installed on the client machine (ie where the crystal is installed)?
When you try to connect, do you see one or two MSOLAP drivers? If you see two, and you're trying to connect to AS2000, then ensure you use the driver with the higher number.
HTH,
Steve
[/quote]
July 31, 2003 at 7:04 am
Did you validate and process the cube before trying to connect. The error "no rowset returned" is normally indication of the cube definition which does not fetch data. Using the right driver is always the key anyway..
-Sravan
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply