Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 250
  • Last Modified:

Filter Results Question

Hello,
      I have a crystal report I wrote to show me all open work orders in our database. I have it grouped by work order id, then work order release id and then part number id. In the details of the report I have several items. One of them is the operations, (sequences), of the work order. These are the steps that make up the work order. The report runs fine and the data is accurate. I would like to filter this report to only show me the open work orders that have an operation that starts with a specified text. I can use select expert to just show me the operations that start with the specified text but I want to see the other operations for that work order that don’t start with the specified text. Any help would be appreciated.

Thank you
0
daskas27
Asked:
daskas27
  • 5
  • 5
1 Solution
 
mlmccCommented:
If you can do it, build a stored procedure in the database.

You could also build a command to return the items you want.

You can do it in the report through the group select expert.  This is really just a suppression of the groups that don't meet the criteria so if you have summaries they will reflect the suppressed records.

Create a formula

If InStr({YourField},"YourText") > 0 then
    1
Else
    0

Click REPORT --> SELECTION FORMULAS --> GROUP EXPERT
Sum({YourFormula},{OperationsField}) > 0

mlmcc
0
 
daskas27Author Commented:
No workie.
0
 
mlmccCommented:
How doesn't it work?

mlmcc
0
[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

 
daskas27Author Commented:
Please see the attached file.
0
 
mlmccCommented:
You forgot to attach the file

There is a comment field you have to put something into or else the attachment won't be added.

mlmcc
0
 
daskas27Author Commented:
Please see attached, again.
Formula.pdf
0
 
mlmccCommented:
Why do you believe it isn't working?

The string comparison is generally case-sensitive.

mlmcc
0
 
daskas27Author Commented:
Please see the last page of the screen prints. That is as far as I get.
0
 
mlmccCommented:
Sorry.  I didn't [age through it far enough.

WHen you use formulas like

Sum({Field1},{Field2})

Field2 must be one of the groups in the report.  You have 3 groups so those are the only fields you can use.  If you need to use another field for the sum to group on, you need to add it as a group

mlmcc
0
 
daskas27Author Commented:
Bingo! It works just as I wanted.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now