Using select expert after formulas are calculated

[mbutch]

I'm using SCR 8 and I just want to see the products where the Low Level number is greater than the Units In Stock number. The problem is that the low level is based on other formulas and the select expert tells me 'This formula can't be used because it must be evaluated later'. Is there a way to tell SCR to perform the selection after the formulas are calculated. I tried putting the WhilePrintingRecords function in the select experts edit formula area, but it does not work. Any ideas?

 

[emcevoy]

hello

What you can try is the EvaluateAfter() function, where you place the formula you want evaluated first in the brackets.

let me know if this helps. E. McEvoy
Crystal Reports Consultant

http://www.pacificridgesolutions.com

 

[kenhamady]

Try the Group Selection formula. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[mbutch]

I'm still getting the same error.

 

[kenhamady]

You can't use "WhilePrintingRecords" for selection. You can usually use a formula based on a subtotal in the group selection formula (which is what I think you are trying to do.). To know for sure, show us the selection formula, and the code of any formula fields involved. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)