Java Plug-in URL from the crystal reporting tool

[Former Member]

Hi,

Currently I am working in crystal reporting tool. As I am fresh to this concept, I need your input for the below requirements.

In case of unstructured data/file attachments, we just need to check if the Java plug-in can be integrated(can we trigger the Java Plug-in URL from the crystal reporting tool)?

Here are the detailed explanation:

1. I am using IBM Optim for the archived file. That file contains some file attachments(let's sat .txt file).

2. Integrated that archive file in crystal report through ODM.

3. I can access all the the tables data except attached file. Because its datatype is BLOB.

Please help me on how to access BLOB data type in reporting tool.

Thanks,

Sachin

[former_member292966]

Hi,

What version of Crystal Reports are you using? 

What database are you using? 

Crystal only supported BLOB with .bmp and I think .jpg files. 

BLOB fields are deprecated in the newer SQL Server versions so I haven't worked with them in a very long time.  I don't think this has changed. 

So as a BLOB, I don't think your attachments will be able to work.  If you can convert them to a varbinary the filestream should be able to open it. 

If the attachments could be saved to a network and have the address in a field then Crystal can format that address to a hyperlink. 

Good luck,

Brian