?
Solved

SQL ODBC Driver connecting Crystal Reports  8.5 to a Baan Database

Posted on 2003-03-19
2
Medium Priority
?
947 Views
Last Modified: 2007-12-19
Hi,

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,

Alastair

SQL7
Baan 5c
Crystal 8.5 Profesional
0
Comment
Question by:claral
2 Comments
 
LVL 1

Author Comment

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

Accepted Solution

by:
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

modulo

Community Support Moderator
Experts Exchange
0

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