Print Page | Close Window

Querying Text field In SQL Database

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=1791
Printed Date: 03 May 2024 at 12:31am


Topic: Querying Text field In SQL Database
Posted By: shifty
Subject: Querying Text field In SQL Database
Date 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
 


Replies:
Posted By: BrianBischof
Date 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>


Print Page | Close Window