how do I read binary fields from an oracle database with Crystal reports ver 6

Our Oracle database contains binary fields that currently can only be viewed and some can also be printed from our ERP product (Visual Manufacturing).  I would like to access these fields for reporting purposes,  using Crystal report writer version 6.  Can I achieve this ?
aemlimitedAsked:
Who is Participating?
 
aemlimitedAuthor Commented:
I have discovered an old document that was supplied by Lilly Software Associates (part of Infor, Visual Manufacturing ERP owner), and it contains a user-defined function to access the fields and a second function to create a view.  These are then stored in the database and allow Crystal reports and MS Access to retrieve the data.  The doc also contains a function for accessing Binary fields in SQLServer.
I have not had time to try them yet.
If you reply I will accept the solution for you to get the 500 points.
Almost effort free but not quite.
Thanks for your time.
Kevin
0
 
mlmccCommented:
Not sure.  CR6 is quite old.

Can you build a report against the database?

Can you drag one of the binary fields onto the report?

mlmcc
0
 
aemlimitedAuthor Commented:
We have been using CR6 quite happily for the last 11 years with the database.
We employee "If it ain't broke don't fix it" approach.

Yes, I can get the field into the report but it is blank.
The particular record I'm pulling the fields for is know to have data, as it already shows on one of our ERP reports.
The record in the table shows field BIT_LENGTH = 188, but BITS is empty in the report.

I have tried the same report output using CR10, with the same result.
Hope this helps
Kevin
0
 
mlmccCommented:
Are the ERP reports using Crystal?

Any idea what format the image is in?

mlmcc
0
 
mlmccCommented:
No need for accepting.  You can click the DELETE QUESTION link in the question block then follow the prompts to accept your comment as the answer.  The points will then be refunded to you.

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.