Skip to Content
author's profile photo Former Member
Former Member

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 06:39 PM

    Post Author: hd1

    CA Forum: Crystal Reports

    So far this seems to give me some results.

    IF {?Summary} = "<none>" THEN TRUE ELSE ({?Summary}) IN LowerCase ({LOEB_Docs.Summary})

    I don't know though, If someone has a more reliable and better one could you let me know? I did have to add some words in my parameter, by the looks of it, I will have to do that from now on. So if someone has something better to where I do not have to enter keywords for them, I would appreciate it. This database is going to continue to grow, it's a reference for them so the keywords could be endless.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.