In today's demanding environment, you need powerful tools to fix your reporting system fast. ou don't have time to guess what the anomalies are, or where a "lost" data item actually is. You need to know what, where, and why. And you need to know yesterday. These data analysis tools are your key to knowing what's going on with any data source (not just Crystal Reports).
You can use Report Analyzer Version 5 on almost any data source. Yet it carries on with the mission of its predecessor versions, giving you extreme troubleshooting abilities for your Crystal Reports system. It can automatically detect potential performance issues in your design settings. Even if they are database options, grouping options, or record selection formulas.

The few minutes you invest to learn about Report Analyzer here could make a huge difference in the value of your company's reporting system

  • Simplify and optimize. With Report Analyzer's complexity matrix, you can remove unnecessary complexity. As complexity goes up, system reliability and performance typically suffer and sometimes plummet below acceptable limits. Report Analyzer empowers you to head off a complexity-caused disaster. That way, you don't have to explain to your boss (or the interviewer during your job search) why it happened.
  • Identify, analyze, and document the attributes of design objects. Report Analyzer can handle over 700 kinds of design objects. It provides you with detailed information, so you know what you're working with and can make the needed changes. No more operating in the dark. Let RA tell you what you need to know what you need to know about your SQL codes, report databases, fields, formulas, and design elements. Get it done right and done fast. Use Report Analyzer.
  • Effortlessly Generate System Documentation. When creating professional system documentation for your report projects, Report Analyzer does most of the work for you.
  • Perform cross-referencing of Fields, Formulas, and Objects. Report Analyzer's comprehensive cross-referencing will show you where and how all fields, objects, tables, parameters, and formulas are used. Anywhere and everywhere in your entire report. You can examine these items with the XRef feature or any of the cross-reference reports.
  • Perform detailed formula analysis. Wouldn't it be great if you had formula flow diagrams showing how your formulas call each other? Or reference each other? Report Analyzer provides that functionality! Report Analyzer's comprehensive formula analysis documents functions, formula code, functions, referenced fields, referenced parameters, and section formulas. Formula flow diagrams show you which formulas call (or reference) each other and exactly how they do so.
  • Generate error analysis that's actually useful and user-friendly. Report Analyzer examines your report code and reveals any errors contained therein. Well, that's useful isn't it? Sure. And Report Analzyer takest that one step further by making sure you can easily see these errors. They're highlighted in red in the Formula window. But, gee, how do you fix them? Report Analyzer helps with that, also. It makes design suggestions.
  • Detect, then correct. Report Analyzer detects potential design errors and common report setting mistakes. Imagine being able to find and remove nvalid database server settings, invalid printing settings, and unused objects. With Report Analyzer, you can stop imagining and make it a reality. Report Analyzer also will identify the use of heavy-weight objects such as OLE objects. It will even find subreports that are using special fields such as TotalPageCount and thus requiring extra processing passes. And it will find many other glitches and gotchas that can really drag down your reporting system.
  • Clean it up. Set Report Analyzer to the task of identifing unused formulas, and get rid of them. Or have it show you where formulas for grouping , sorting, and record selection are used inappropriately. It'll sniff out data type conversions in record selection, too. You'll get complete function cross referencing and call tree diagrams. Plus, Report Analyzer lets you produce professionally-formatted printouts of all code.
  • Find "hidden" things. You can search any report object or settings across all reports. Report Analyzer can examine the formulas, fields, text, tables, fields, and running totals. And, yes, it'll even do this with subreports.
  • Export. So you get the report layouts and spefications, using Report Analyzer. But what if you need them in some other format? Report Analyzer can export this information in many formats. These include HTML, XML, PDF, Excel, Word, Excel, and even ASCII. Not only that, you can export drawing files as bmp files or jpg files. You can export entire Workbenches or folders as HTML documents, then post them online.
Report Analyzer Screenshot 1

Click to enlarge

Report Analyzer Screenshot 2

Click to enlarge

Report Analyzer also provides you with:
  • Suggestions on how to improve performance.
  • Powerful features for viewing and reporting documentation.
  • A library of standard documentation reports. These are, of course, in Crystal Report format
  • Documentation Explorer. This is similar to Windows Explorer, so no learning curve. It includes property information, just as Windows Explorer does. But a richer set of such information. It also provides report layout diagrams, formula code, suggestions, and cross referencing for the design object that you're looking at in the explorer. And, as a bonus, it even provides the complexity information.
Use Report Analyzer for development and maintenance.

Large report projects have many design elements, as you may be painfully aware. They also have complex relationships between data and code. Report Analyzer's consistent, automated documentation and analysis reduces development time, downtime, upgrade costs, and maintenance costs.


  • Create a repository of valuable information by cataloging design elements into the Report Analyzer database.
  • Quickly see how to re-use formulas, determine database layouts/structures, and maintain consistency throughout your reporting system.
  • Measure how complex a report is, and adjust as needed.
Automatically detect:
  • Potential performance issues in your design settings.
  • Reports that slow the system down by not using server side database processing.
  • Record selection formulas that slow the system down by using data type conversion functions.
  • Group fields that use formulas rather than SQL Expression fields.
  • Various types of fields that cause an additional pass over the data source.
  • Reduce learning curves with the report blue prints, formula diagrams, and specification reports.
  • Perform instant impact assessment for formula changes and database changes across all reports.
  • Apply complexity metrics. These assist with test case planning and maintenance estimates. Reports with many formulas that have many dependencies and conditions are typically more costly to maintain than simpler reports.
  • Discover fields, formulas, and variables that aren't being used; remove them to optimize your system.
  • Find the group settings that cause blank pages or blank footers.
  • Locate which reports use specific design settings, functions, or parameters.
  • View dependencies between report objects. These include database fields, formulas, and parameters. And even SQL expression fields!
  • Select design objects, formula code, dependencies with other design objects, and call stacks. Applies to view/print settings, too.
  • Use interactive diagrams (trees) of formula hierarchies, object dependencies and report design elements.
Right mouse click to download: