Crystal Reports Tools: Improve Performance While Saving Time and Money
  Resources  
Best sellers:
● cView
● Report Analyzer
● cViewSERVER
● ReCrystallize

Crystal Reports: Free trial
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

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.

Report Analyzer

You can more effectively analyze your Crystal Reports by using Report Analyzer:
http://www.mindconnection.com/Merchant2/merchant.mvc?
Screen=CTGY&Category_Code=CR-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.

These keywords may have brought you here: analyzing crystal reports, analyze with select into, crystal reports tutorials, crystal reports articles, crystal reports information, crystal reports software, crystal reports training, crystal reports downloads, crystal software, crystal downloads