hello everyone.
i am currently updating a reports module for an application my company uses extensively.
first i would like to briefly describe how the application uses the crystal report files.
our company uses Oracle 7 server because the application uses this db.
1. report files (about 50 of them) have been created using an oracle 7 db in the vendor. when i open the report with crystal reports, i see two oracle tables pointing to a completely unknown Oracle server (which probably is the server at the developer company)
2. vb application populates 5 report fields from different tables that the application uses.
3. vb application sets the connection string of the report to point to the local Oracle server. it changes nothing else.
4. when it displays the report, report looks for the 5 report tables. as the tables are populated J-I-T (just in time
)) it will get the information in those tables and display them.
i need to run these reports on our SQL server 8.
i know changing the location of the tables is relatively easy. however, there are some formula fields which extensively use tablename.columnname syntax.
i would like to get rid of the report tables so i want to feed in recordsets into the reprts so that the formulas and the field objects take their info from the recordsets.
I would like to find out how i can add two recordset objects into this report with specific tables names. i also need to remove the existing oracle tables in the reports, basically replacing the ORacle tables with my recordsets. (i want to use recordsets because some of the report tables are populated from 5 other tables.)
I apologize for giving you so much trouble.
I thank you so much for your support and help in advance.
regards
Cuneyt Terzi
i am currently updating a reports module for an application my company uses extensively.
first i would like to briefly describe how the application uses the crystal report files.
our company uses Oracle 7 server because the application uses this db.
1. report files (about 50 of them) have been created using an oracle 7 db in the vendor. when i open the report with crystal reports, i see two oracle tables pointing to a completely unknown Oracle server (which probably is the server at the developer company)
2. vb application populates 5 report fields from different tables that the application uses.
3. vb application sets the connection string of the report to point to the local Oracle server. it changes nothing else.
4. when it displays the report, report looks for the 5 report tables. as the tables are populated J-I-T (just in time
)) it will get the information in those tables and display them.i need to run these reports on our SQL server 8.
i know changing the location of the tables is relatively easy. however, there are some formula fields which extensively use tablename.columnname syntax.
i would like to get rid of the report tables so i want to feed in recordsets into the reprts so that the formulas and the field objects take their info from the recordsets.
I would like to find out how i can add two recordset objects into this report with specific tables names. i also need to remove the existing oracle tables in the reports, basically replacing the ORacle tables with my recordsets. (i want to use recordsets because some of the report tables are populated from 5 other tables.)
I apologize for giving you so much trouble.
I thank you so much for your support and help in advance.
regards
Cuneyt Terzi