Crystal Reports Tools  > Data Source Analyzers

• Find old code that's now causing problems.
• Locate outdated information so it can be updated.
• Identify improper table joins, incorrect table constraints, or anything else that causes your relational database to serve up incomplete or incorrect responses.
• Locate variances so you can standardize coding, expression, functions, and statements.
• Find and change all instances of an item. Not every system has a global search and replace function, and many that do aren't able to work with all text strings (e.g., won't search for anything past a delimiter or URL parameter).
• Locate all photos that meet your speficic criteria.
• Find all instances of a change that resulted in performance problems, and repair them globally.

...because you can use this tool to:

• Connect directly to, and search, relational databases, SQL code, data, or schema. And you can do that in any database including SQL Server, Oracle, DB2, MySQL, and MS-Access.
• Find information in a database in the cloud; not just what's on your local server.
• Search program code and configuration files.
• Search application logs.
• Extract code from any binary files, not just Crystal Reports rpt files.

With Find it EZ, you can easily find pretty much anything that matters. For example, you can search:

• Source code. Even of programming languages.
• Relational databases. You can find such things as SQL code, schema definitions, stored procedures, table data, and triggers.
• Reports (e.g., Crystal Reports, SSRS).
• Binary code stored within a database.
• Documentation, even if it's in the form of verbose application logs or configuration files.

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.

Report Analyzer empowers you to:

• 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.

• 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.

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.

• Find it EZ trial version(18MB)
• Report Analyzer Free Trial.
• Report Analyzer Installation Guide.
• Business Objects runtime files (recommended for RA users of BO XI and later).