Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Querying Text field In SQL Database Post Reply Post New Topic
Author Message
shifty
Newbie
Newbie
Avatar

Joined: 12 Jul 2007
Location: United Kingdom
Online Status: Offline
Posts: 17
Quote shifty Replybullet Topic: Querying Text field In SQL Database
    Posted: 29 Nov 2007 at 7:29am
Hi
 
I have an application that is recording information and inserting in to the sql database as a note.  Inside the note I have
 
1)Duration
2)Number that was called.
3)Time call was made
4) To who the call was made
5)The result of the call.
 
all notes are formatted the same, see below.
 
Phone Call: Pilwal, Shivun
Number Called: Incoming Call
Subject: Credit Control
Result: Call back
Duration: 00:00:05
 
So I need to pull this data out and insert this in to a report, I am sure I read somewhere that crystall can do this.  I am running version 11.
 
Any help would be most appreciated.
 
shivun
 
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 29 Nov 2007 at 12:18pm
You are going to need to use a variety of formulas to pull out each data field. Use the InStr() function to find out where each field name starts and then add the appropriate number of characters to it to find where the data starts. Use the Mid() function to extract the actual data from the string. You'll have to play with the formulas to get them to return the exact start and end points of each data field.
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
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.015 seconds.