Reread after a record select

[lizzieb]

I have a report with a select criteria on one field but I need to go back and reread the value in that field. This is probably easier to show than explain...

My select is:
{@ActCode1stChar} = "R"

where {@ActCode1stChar} is Left({CVCIVA.CC_ACTIVITY},1)

The activity field code table is set up so that all final actions begin with the letter R. So, on the monthly summary, I only want to pull records with a final action.

The problem is that I also need to provide a count of another activity code and if I have only selected those with an "R" code, the report doesn't read the other values in that field. I thought that EvaluateAfter would do the trick but just returns zero.

I am running 8.5. Any thoughts would be greatly appreciated!

Thanks, Liz

 

[kenhamady]

It sounds like you don't want to select just RECORDS that have an R, but you really want all records in GROUPS that have at least one R.

That is different. One way is to create a formula like:

Ir {field} startswith "R"
then 1
else 0

Now do a subtotal for the group of this formula, and in Group selection put in the rule that is

Sum ( {formula} , {Group} ) > 0

This will only show groups with an R.

Now put your date range in Record selection, and any other rules that eliminate unwanted records. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[lizzieb]

Ken,

Thanks for your help. I think I am on the right track now!

Liz