I am running Crystal Reports 8.5.
I'm trying to connect my crystal report to my Oracle database using ADO (database -> add database to report -> more data sources -> active data (ADO) -> make new connection.
In the resulting "select data source" box, I select "ADO and OLE DB" and build the connection string by choosing Oracle Provider for OLE DB, plugging in my data source, my user name and my password. After logging in, things look wonderful.
In my data explorer window, I can see my data source and the ado database icon. When I double-click the ado icon, I can fix the sql select statement so that my schema is correct. OK and closing that box pops up the Visual Linking Expert box, as expected.
The Visual Linking Expert box has all 98 of my Oracle data items.
Then life gets weird!
When I click OK on the visual linking expert box, then try to insert -> field object from my ado data source, only 59 of my Oracle data items are available. Coincidentally, all of the missing data fields are classified as "number".
I tried the "Answers By E-Mail" from Crystal Decisions and was told to use the .TTX file method, but said nothing about the missing number fields.
Note that my datasource is an Oracle "view". I just tried the report using one of the tables that is used to create the view, and all of the "number" fields are there. Unfortunately, there are multiple tables involved in the view, so using "just" the table is not an option.
Has anyone run into this problem? Am I seriously being told that number fields from Oracle don't work in ADO recordsets? Is there something that my Oracle DBA needs to do to make the "number" fields work?
I'm trying to connect my crystal report to my Oracle database using ADO (database -> add database to report -> more data sources -> active data (ADO) -> make new connection.
In the resulting "select data source" box, I select "ADO and OLE DB" and build the connection string by choosing Oracle Provider for OLE DB, plugging in my data source, my user name and my password. After logging in, things look wonderful.
In my data explorer window, I can see my data source and the ado database icon. When I double-click the ado icon, I can fix the sql select statement so that my schema is correct. OK and closing that box pops up the Visual Linking Expert box, as expected.
The Visual Linking Expert box has all 98 of my Oracle data items.
Then life gets weird!
When I click OK on the visual linking expert box, then try to insert -> field object from my ado data source, only 59 of my Oracle data items are available. Coincidentally, all of the missing data fields are classified as "number".
I tried the "Answers By E-Mail" from Crystal Decisions and was told to use the .TTX file method, but said nothing about the missing number fields.
Note that my datasource is an Oracle "view". I just tried the report using one of the tables that is used to create the view, and all of the "number" fields are there. Unfortunately, there are multiple tables involved in the view, so using "just" the table is not an option.
Has anyone run into this problem? Am I seriously being told that number fields from Oracle don't work in ADO recordsets? Is there something that my Oracle DBA needs to do to make the "number" fields work?