Select Expert and Formula

[bhansen]

I have created a formula that returns me a true or false based on values placed in my group footer. I insert the field into the footer and in preview all calculation are correct.

I would like to filter out the false records, but using select expert does not list my formula field from the group footer.

Select expert already has values in it for picking data that I am basing my calculations on.

Thanks in Advance

 

[Roadkill150]

your formula will not be listed in the select expert due to evaluation time. You can however suppress the sections based on your formula so that only the areas marked as "true" show on the report. Seagate Certified RCAD Specialist.
-Bruce Thuel-Chassaigne
roadkill150@hotmail.com

 

[glauco]

Hi, This is something I've tested:

You can hide data by formatting a section and in the "Supress Formula" you put the formula wich returns false or true, depending on what you want to do.

Remember your formula gets is value in the footer so take care if you want to suppress a section comming before the footer and that when your formula returns true that section will disappear, if you want the opposite effect then try: Not {formulainfooter}. You understand, right?

You can still you use your formula in the Group selection Expert with the formula Editor, now you know two options.

 

[Ngolem]

the Select expert is used to filter data records that will be processed by the Crystal Report. Once the report is running it is not used anymore.

If it is only hte Group footer you want suppressed then put something like this in the "SECTION EXPERT" for the Grup footer conditional suppress

WhilePrintingRecords;

not {@TrueFalseFormula}

where {@TrueFalseFormula} is the formula that you mentioned.

Hope this helps
Jim