Skip to Content

How to connect Crystal Reports to an Oracle VPD from within a VS 2017 project

Oct 13, 2017 at 08:11 AM


avatar image

My application runs reports with parameters set by an Oracle Stored Procedure.
Crystal Reports need to connect to the Oracle DB using a VPD enabled connection string. The string looks like:
"metadata=res://*/DataModel.csdl|res://*/DataModel.ssdl|res://*/DataModel.msl;provider=Devart.Data.Oracle;provider connection string=\"User Id=user;Password=****;Server=Server;ClientId=CLIENT\""
I'm using CrystalDecisions.Shared.TableLogOnInfo.ConnectionInfo to set up ServerName, UserId and Password
Unfortunately I'm not able to pass an Oracle VPD specific ClientID property this way.
I tested setting ConnectionInfo.LogonProperties but it ends up with a "Failed to load database information".

What is the right way of connecting Crystal Reports to an Oracle VPD?

Environment: VS2017, CrystalDecisions.CrystalReports.Engine 13.0.19, Oracle 12c

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Don Williams
Oct 13, 2017 at 10:18 PM

Hi Viktor,

Can you do this in CR Designer? If not it won't work in Cr for VS, same DB drivers used.

If CR guys don't answer go to the new Idea Place where Enhancement requests are logged and enter your request there:


10 |10000 characters needed characters left characters exceeded