Crystal Reports: Analyze Crystal Reports with SELECT INTO

	Resources
	Best sellers: cView Report Analyzer cViewSERVER ReCrystallize
	Buy Crystal Reports
	Articles: Administration Advanced Basic Crystal eNL Database Financial Problems Solved Books: CR Books Database Books Developer Books
	Tools: All CR Tools CR Analyzers CR Bestsellers DataBase Tools CR Graphics International CR Mail UFLs ReCrystallizePro CR Schedulers CR UFLs CR Viewers
	Add'l: About us Contact Us cViewSUITE Ppt Support CR trial
	Crystal Reports on Steroids

Crystal Reports: Analyze with SELECT INTO

Use SELECT INTO to help analyze your data.

In another article, we showed how to speed up your Crystal Report processing using SELECT INTO.

Paul Briggs of South Auckland Health tells us of another use of this SQL function.

Paul uses a SELECT INTO to create a temporary summary table of all the patients who had a certain procedure, and then joins this table to find all the other medical procedures the patients incurred.

You can more effectively analyze your Crystal Reports by using Report Analyzer:

http://www.crystalkeen.com/crystalreporttools/analyze/

With this powerful tool, you can:

Discover unused Formulas, Fields and Variables.
Identify group settings which cause blank pages and footers.

Identify missing standard Crystal documentation best practices (Report Title, Author, Description special fields).
Locate reports which may use the "Convert null field to default" setting inconsistently.
Keep versions of your documented reports for historical comparison.

Automatically detect reports that do not take advantage of server side database processing.

Detect record selection formulas which use data type conversion functions.

Detect group fields which use formulas instead of SQL Expression fields.

Find report tables which use less than an optimal number of fields.

Discover special fields which cause an additional pass over the report data source.

And so much more! Click here to see what you're missing by not having Report Analyzer.

This article is copyrighted by Crystalkeen, Mindconnection, and Chelsea Technologies Ltd. It may be freely copied and distributed as long as the original copyright is displayed and no modifications are made to this material. Extracts are permitted. The names Crystal Reports and Seagate Info are trademarks owned by Business Objects.


	Questions? Please write to mark @ crystalkeen.com. We do want your business. Crystalkeen is a subsidiary of Mindconnection LLC. Crystal Reports is a subsidiary of Business Objects, which is owned by SAP. See the latest solutions from Crystal Reports. Use Business Objects products to turn reports into true business intelligence tools.