Report Design
 Crystal Reports Forum : Crystal Reports .NET 2003 : Report Design
Message Icon Topic: Using Oracle data type "Long" in a report Post Reply Post New Topic
Author Message
wattsjr
Groupie
Groupie
Avatar

Joined: 25 Jun 2007
Location: United States
Online Status: Offline
Posts: 51
Quote wattsjr Replybullet Topic: Using Oracle data type "Long" in a report
    Posted: 31 Jul 2007 at 9:08am
I am in the process of rewriting several reports that were originally written in CR6 and run from a VB6 app. In the report I'm working on now there is a comments field that is defined in the Oracle table as data type LONG.  All of the other comment type fields that I've been using are defined as VARCHAR2(2000) and they work fine.  Is there a trick to using a LONG data type?  I should also mention that they display just fine in the CR6 version, and redefining the Database field is not an option.
 
Any help would be greatly appreciated.
-jrw
IP IP Logged
jkwrpc
Senior Member
Senior Member


Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
Quote jkwrpc Replybullet Posted: 31 Jul 2007 at 12:12pm

I am not a Oracle person but in looking on the web it seems this is  datatype that holds alphanumeric characters (a whole lot of characters).  So it is probably somewhat simitar to the Text datatype in SQL Server.

If that is true I would try the following in a formula

CStr({Yourfieldname}

 
It should convert it to a string which CR can read.
 
Best thought I have....
 
Regards,
 
John W.
IP IP Logged
wattsjr
Groupie
Groupie
Avatar

Joined: 25 Jun 2007
Location: United States
Online Status: Offline
Posts: 51
Quote wattsjr Replybullet Posted: 31 Jul 2007 at 2:34pm
Thanks for trying to help.
 
Although your suggestion "CStr({Yourfieldname}" didn't work, your reply did get me thinkiing in another direction.
 
I went over to Business Objects and poked around until I came across a solution that made me wonder if my ohoice of OLE DB Provider could be the problem.
 
I was using "Microsoft OLE DB Provider for ODBC Drivers". 
 
I created a new Q'n'D (quick n' dirty) report using "Microsoft OLE DB Provider for Oracle" and the errant Oracle Long field was able to be displayed in the report.
 
Now if I can just figure out a way to change the OLE DB Provider in my real report.
 
Any suggestions?
 
Again, thanks for the help.
-jrw
-jrw
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 31 Jul 2007 at 3:34pm
Glad to see that John got you on the right track. You can use Database > Set Datasource Location to change providers.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
jkwrpc
Senior Member
Senior Member


Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
Quote jkwrpc Replybullet Posted: 31 Jul 2007 at 6:32pm
Thats the way it always happen you get an off track answer that leads you to the correct one.  That is the value of forums such as this one. Its a place to share thoughts that lead to solutions. Thanks again to Brian for hosting it.
 
Looks like you have what you need to go on to finishing the project and that is all that matters.
 
Regards,
 
John W.
 
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.