I build a small report on SQL Server report builder 2.0 (2008) and I move it to the SSRS server.
My SSRS machine is same with my PI machine and I do have PI OLEDB provider installed.
The report works fine on my computer, but when I send it to the SSRS server I get the error below:
An error occurred during client rendering.
- An error has occurred during report processing.
- Cannot create a connection to data source 'PIOLEDB'.
- For more information about this error navigate to the report server on the local server machine, or enable remote errors
Now, my computer is 32 bit and the server is 64 bit, could be a problem?
I also search into the MSDN and one of the answers was to have SP1 on the SQL server, which I did installed and the problem persists.