I have created a VB 6.0 app for running a report that uses the Crystal Report Control (CR v. 8.5). The report accesses a SQL Server 7.0 database. Within the SQL Server database, I have a table which stores the document paths for up to 6 documents/record. When I run the report I need to have some data from the database table as well as the content from the files whose paths are stored; appear in the report.
When I run the report, the VB app fills a table in the database with an id and the text for each of the 6 possible documents. Then runs the report getting all the data for the report from the database.
This has worked well in the past, but now I am running into two issues. The text in the documents is exceeding the 32K size limit of the Text Object in the Crystal Report, so some of the content for some of the documents gets cut off. Also, my customer has started to create the documents in MS Word and is using highlighting and italics and wants that to carry over into the report. When I use VB to move the content from the file into a text field in the database, I lose the special formatting.
I see that Crystal Reports Formulas allow you to get information about a document like FileAuthor, FileCreationDate, etc... but no FileContent or something like it. I can't figure out a way to do what I need to do. Does anyone have any ideas or know of software that can do this?
When I run the report, the VB app fills a table in the database with an id and the text for each of the 6 possible documents. Then runs the report getting all the data for the report from the database.
This has worked well in the past, but now I am running into two issues. The text in the documents is exceeding the 32K size limit of the Text Object in the Crystal Report, so some of the content for some of the documents gets cut off. Also, my customer has started to create the documents in MS Word and is using highlighting and italics and wants that to carry over into the report. When I use VB to move the content from the file into a text field in the database, I lose the special formatting.
I see that Crystal Reports Formulas allow you to get information about a document like FileAuthor, FileCreationDate, etc... but no FileContent or something like it. I can't figure out a way to do what I need to do. Does anyone have any ideas or know of software that can do this?