I have a report which I want to deploy in report manager but it's not getting deployed there. Let me give you guys a bit more detail.
I have a report where I have used an OLE provider in the connectionstring to connect to a cube. The properties of the connection string are
Type - OLE, Provider - Microsoft OLE DB provider for Analysis Services 9.0. Connection string is, Provider=MSOLAP.3;Data Source=ServerName;Initial Catalog="Cube_Name".
I tried to use the Analysis services (as type) but in that case I was not able to connect itself. I have 2 servers, say A and B. I have BIDS installed in server "A", where I have created my report. In server "B"
I have the Analysis Manager (AS 2000). So while creating the report in BIDS, I had to choose the OLE provider to connect to the cube. I tried initially with the Analysis services but in that case I was not able to see the list of cubes in the wizard for creating
Now my problem is that while the report runs perfectly fine in BIDS, as soon as I deploy it in the report manager (which is in the same server as where I have created my report in BIDS, in our case server A), i get an error,
An error has occurred during report processing. (rsProcessingAborted) Cannot c
View Complete Post