Report Criteria

[brishanny]

I use CR 9.0 and SQL server 2000 for my reporting process.

I usually write views in SQL 2000 for my data source (which I am in the process of switching them over to SP's) and am curious exactly how the data is pulled.

I currently write my selection criteria in my sql views to narrow the records returned.

My question: If I write my selection criteria in CR does CR pull all records from the data source and then query out the unwanted records based on the selection criteria or does CR go to the datasource query out the unwanted reocrds and then return the record set?

Thanks to any insight anyone has on this subject?

 

[dgillz]

That depends on how you write the report, but generally, basing the report on a view is much more efficient than letting crystal do the work.

I hope this answers your question.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[synapsevampire]

What you're really speaking of is filtering data, here's a whitepaper on this (written for CR 8.5, but still applicable):

faq767-3825

To summarize, you can check what is being passed to the database by using Database->Show SQL Query, it will show you what is being passed to the database as a result of your record selection formula, and what is not.

-k