Difference between CR functions and SQL 1

[techvs]

I'm using Crystal Reports 7.0. I am trying to speed up several of our reports. Noticed on the help pages that if I reference any CR functions then the query cannot be converted to SQL and that CR will read all records, etc. I need for the query to be passed to the database so that the database can do all the work. How can I tell the difference between CR functions and SQL? How will I know if it can or cannot be converted?

Any suggestions would be greatly appreciated.

 

[synapsevampire]

You can't use SQL in the record selection anyway, so there's no need to worry over that.

Try reading my FAQ:

faq767-3825

TO determine what is being passed, compare what's in your record selection formula with what's in the Database->Show SQL Query

-k