I have crystal 8.5 and am trying to connect to a cube running on SQL Analysis Services on a seperate machine. There are approximately 10 cubes on this machine. I have set up a role to allow me to access three of them. If I try and connect with Excel it all works fine, If I try and connect with Crystal 9 it all works fine. However when I try to connect with crystal 8.5 it only brings back the list of cubes I dont have access to ( even though it still wont let me connect to them ).
Any ideas?
Let me know if you need any more information
Any ideas?
Let me know if you need any more information