Use an .rpt as a datasource

[Former Member]

I have a .rpt file from a third-party source and I need to extract its data to an Oracle database using a programming language. I want to know if something like this is documented or if it is possible. Any suggestions?

[former_member11696 · Accepted solution]

Yes you can using the .NET SDK that you can get from here:

https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads

Samples on that wiki page as well, read it all.

Don

[Former Member]

I will check that link right now, but just to be sure:

Is there a way to directly export the data from an rpt to a database?

I mean, without converting it to another formar first.

Thanks you in advance.

[Former Member]

I will check that link right now, but just to be sure:

Is there a way to directly export the data from an rpt to a database?

I mean, without converting it to another formar first.

Thanks you in advance.

[Former Member]

Hi Abhilash

Im aware of that funtionality, but im interested in doing this task in an automated way.
So, Can I export it to Excel using some programming language as Java or C#?

[Former Member]

I will check the link right now, but just to be sure and close the question:

Can I extract directly the data from an .rpt? Without converting it to another format.

Thanks in advance

[abhilash_kumar]

Hi Roelver,

You could export to Excel from Crystal Reports and then load the Excel data in Oracle.

-Abhilash