Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2008-10-16
5
470 Views
Last Modified: 2013-12-19
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 ?
0
Comment
Question by:aemlimited
  • 3
  • 2
5 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 22732143
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
 

Author Comment

by:aemlimited
ID: 22738555
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
 
LVL 100

Expert Comment

by:mlmcc
ID: 22741259
Are the ERP reports using Crystal?

Any idea what format the image is in?

mlmcc
0
 

Accepted Solution

by:
aemlimited earned 0 total points
ID: 22765692
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
 
LVL 100

Expert Comment

by:mlmcc
ID: 22770334
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

837 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question