Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    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:

    https://influence.sap.com/sap/ino/#/campaign/891

    Don

    Add comment
    10|10000 characters needed characters exceeded