Link varchar and numeric cols in database expert
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22216
Printed Date: 01 May 2024 at 8:43pm
Topic: Link varchar and numeric cols in database expert
Posted By: stonewall63
Subject: Link varchar and numeric cols in database expert
Date Posted: 31 Jan 2017 at 10:02am
I'm using CR 2013 and have a report that was designed with Database Expert to link the tables. The DB is Oracle.
We found that we need to link two of our tables on a different set of columns. Now we have to link from varchar to numeric. When trying to do so I get the "Data types are not compatible" error.
Granted, we could do it with a SQL Command instead of the Database Expert visual method. Just convert one of the fields to the other format. But it's a rather complicated (vendor supplied) report and we don't want to go down that avenue if it can be avoided.
Is there another way around this?
Thanks.
|
Replies:
Posted By: kevlray
Date Posted: 31 Jan 2017 at 11:38am
|
Not that I am aware of. Unless you can do something on the database side.
|
|