I am getting weird printed results and I am not sure if my database is corrupt or if I just am using formulas in the wrong place.

I assume the formula created in Select Expert filters data WhileReadingRecords.

But what if your report also has formula fields in the detail section? Do those formulas get processed before or after the formula in Select Expert?

Thanks for any info.

I thought that there were only 3 passes...but it's been a long time...

I know that there are directives like while reading records and while printing.

It would make sense that the record selection formulas would be while reading as they are a boolean that basically says include this record or exclude it from the reporting results.

I would think that just about everything else is post reading...since you can do dynamic grouping that would be in an earlier pass than a dynamic suppression or a dynamic display.

If you are confused about the data being returned, I would take the SQL that CR generates and run it in SQL Server or whatever your datasource is and then you can compare if the results match the report and if the results are what you expect.

HTH