SQL ODBC Driver connecting Crystal Reports  8.5 to a Baan Database

Posted on 2003-03-19
Medium Priority
Last Modified: 2007-12-19

When connecting Crystal 8.5 Report designer to the SQL Baan database, text tables are returned to the crystal report in hexadcimal format. I would like to be able to covert this data to ASCII text, Baan must convert this data as this is the fromat that the data is shown in the Baan application.

At a previous client they were able to use the formula HexToText in the Crystal formula editor, in the format Hextotext {filename}.  This then converted the text to ASCII format.  I have contacted crystal and they have said this is not Crystal functionality.  The only way to do this would be to create a User Defined Function in VB.

Does anyone know how this UDF.dll is created?

Many thanks,


Baan 5c
Crystal 8.5 Profesional
Question by:claral

Author Comment

ID: 8171243
please contact on alastair.clark@hsv.com.au

Accepted Solution

modulo earned 0 total points
ID: 8194728
Answer from claral:

I have created a UDL file in VB6 that loads a dll in to crystal 8.5 that converts Hex text to ASCII a function.  I'd be happy to share this file if anyone requires it.  The text for the VB script is

Public Function hex2ascii(ByVal hextext As String) As String
For y = 1 To Len(hextext)
   num = Mid(hextext, y, 2)
   Value = Value & Chr(Val("&h" & num))
   y = y + 1
Next y

hex2ascii = Value
End Function

PAQ'd and points refunded


Community Support Moderator
Experts Exchange

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Microsoft Jet database engine errors can crop up out of nowhere to disrupt the working of the Exchange server. Decoding why a particular error occurs goes a long way in determining the right solution for it.
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses

612 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