RexHeadlong
Programmer
Hi, all.
I have an image column in the database that is being used to store variable-length ASCII text. My application currently reads this binary data, creates a temp table where the text is now stored in a varchar field, splits up the binary data into smaller lines of text, and writes the converted text to this temp table. The Crystal report reads from this temp table to display the character data.
The question: Does anybody know if there is a way to bypass the application's steps, and just have Crystal act on the image column directly, in order to print the text? I have tried various ideas, including formulas, but Crystal doesn't seem to allow me to even bring an image column into the report at all.
I am using SQL Server (7 & 2000), VC++, and Crystal Reports 8.5 developer.
Thanks for any help.
I have an image column in the database that is being used to store variable-length ASCII text. My application currently reads this binary data, creates a temp table where the text is now stored in a varchar field, splits up the binary data into smaller lines of text, and writes the converted text to this temp table. The Crystal report reads from this temp table to display the character data.
The question: Does anybody know if there is a way to bypass the application's steps, and just have Crystal act on the image column directly, in order to print the text? I have tried various ideas, including formulas, but Crystal doesn't seem to allow me to even bring an image column into the report at all.
I am using SQL Server (7 & 2000), VC++, and Crystal Reports 8.5 developer.
Thanks for any help.