![]() ![]() ![]() This will maximize the work performed by the database server and minimize the amount of data and amount of processing left for Crystal Reports to deal with once data is returned from the server. ![]() In particular, you want to ensure that as much as possible, if not all, of the report s record selection is translated into a WHERE clause in the SQL query. Although you may not consider yourself a database expert and might not make a habit of writing huge SQL statements off the top of your head, there is one advantage to being able to see the SQL query that Crystal Reports is sending to the server: this is useful if you are experiencing performance problems or other peculiarities when running the report. ![]()
0 Comments
Leave a Reply. |