Parameter to search within a field

Post Author: hd1

CA Forum: Crystal Reports

Hello,

I have a report that is connected to SQL database. I was wondering if there was a way to create a parameter to search within a specific field in my database table. The scenario is we have Paralegals and Attorneys who have created a huge Word document that has a table in it. They have 8 fields in this table and one field in particular is their summary field. This field can go up to over 1000 characters. So, we decided to create a SQL database and have them import their data from a Data Access Page using Microsoft Access, then we run a Crystal Report for them. So far it looks good and it's working great. We can import there current data without any problems. The problem that I have run into is the way they search for specific entries. I was wondering if I could create a parameter in the report to search within the summary field. Again these summary fields can be from one sentance to multiple paragraphs. I would like to be able to get this going for them, it will make things a lot easier on them. An example would be. We have multiple entries in this field.

This is a test entry done 11/27/07

This is a test entry done 12/3/07

This is a test import using DTS done 12/3/07.

Now it would be nice if the users could put in the word 'DTS' in the parameter and it would only show entries containing DTS. Do you think this is possible.

I ran accross a posting by Skodidine and his was something like this.

{table.field} LIKE & "*" But that was relating to a wild card search. I tried just using {table.field} LIKE but I didn't get any results. This does sound possible though.