SSRS - Regular vs Sharepoint Integrated Mode

[ddavyjr]

I have an SSRS report which uses Greenplumb as a data source which runs just fine in Report Manager.

When I move the RDL over to a Sharepoint site however, I get a message saying that my report query cannot be parsed.

Other methods for connecting are working. Reports using other sources also working. When I pull the report SQL out of the SSRS logs and run it against GP it also works.

I'm in the process of eliminating the causes of this error, and I am wondering if you are aware of any differences in behavior for PGNP for reports run in Sharepoint Integrated Mode.

Using 1.3.0.2228 version of the driver.

[Moderator]

It is hard to say what is different that causes the issue. Version 1.3.0.2228 looks very old, and the issue might have been resolved in a later version (current is 1.4.0.3054).

I'd recommend updating PGNP provider to a later version. Please contact Support at pgoledb.com to obtain the updated module.

Also, would you run PGNP Profiler and collect errors trace? It could help us find what caused the issue. Thank you!