?
Solved

SQL ODBC Driver connecting Crystal Reports  8.5 to a Baan Database

Posted on 2003-03-19
2
Medium Priority
?
928 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
[X]
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
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

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

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

Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

764 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