Dave Stone
asked on
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
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
ASKER
No workie.
How doesn't it work?
mlmcc
mlmcc
ASKER
Please see the attached file.
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
There is a comment field you have to put something into or else the attachment won't be added.
mlmcc
ASKER
Please see attached, again.
Formula.pdf
Formula.pdf
Why do you believe it isn't working?
The string comparison is generally case-sensitive.
mlmcc
The string comparison is generally case-sensitive.
mlmcc
ASKER
Please see the last page of the screen prints. That is as far as I get.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Bingo! It works just as I wanted.
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},"YourTex
1
Else
0
Click REPORT --> SELECTION FORMULAS --> GROUP EXPERT
Sum({YourFormula},{Operati
mlmcc