I am using Crystal 8.5, with SQL Server 2000. I am trying to create an OLAP report in Crystal, but I am running into a problem. Here are the steps I go through when trying to get it to work: choose OLAP Report Exert, click Server Type button, choose OLE DB for OLAP, Provider is MS OLAP, enter server name, available cubes appear for the chosen server, choose cube. My problem is when I drop-down list of cubes appears in the data tab of the OLAP Report Expert. Not all of my cubes appear in the drop-down box.
I heard that there might be an issue with SQL Server 2000 not working with OLAP cubes in Crystal. Has anyone had this problem or one like it? Any help would be greatly appreciated.
I heard that there might be an issue with SQL Server 2000 not working with OLAP cubes in Crystal. Has anyone had this problem or one like it? Any help would be greatly appreciated.