Hi,
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
my DataSource.
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