.rpt Inspector Professional Suite :: Features

Crystal Report 16 tools in the most powerful suite for Crystal Reports. Data source / Database migration and conversion, analyze, documentation, text, objects, formulas, parameters, search & replace, export to Excel and a lot more with .rpt Inspector!

Mass Edit!
Edit, Analyze, Document, and Change:
text, formulas, parameters, data sources and databases (set location, convert driver, verify database), fonts, colors, printers, etc.

and more -- on multiple Crystal Reports at the same time in minutes vs. hours or days

Overview Features Specifications Brochure Pricing Download
    Comparisons Testimonials ROI Buy
16 powerful tools in the most...
    powerful, integrated, & easiest to use Suite!
Now you can Mass Edit your Crystal Reports (one or many at the same time) with these editor, analysis, and documentation tools (click on tool below for details & screen shots):

Data Source / Database Migration and Conversion details Crystal Report 16 tools in the most powerful suite for Crystal Reports. Data source / Database migration and conversion, analyze, documentation, text, objects, formulas, parameters, search & replace, export to Excel and a lot more with .rpt Inspector!

Available in 5 editions, .rpt Inspector 3 Professional Suite was designed to make every Crystal Reports user's, developer's, and administrator's experience easier:
(see Specifications page for requirements and supported file format(s) for each edition)

  • .rpt Inspector 3 Professional Suite (for CR 8.5)
  • .rpt Inspector 3 Professional Suite (for CR 9)
  • .rpt Inspector 3 Professional Suite (for CR 10)
  • .rpt Inspector 3 Professional Suite (for CR XI)
  • .rpt Inspector 3 Professional Suite (for CR XIr2)

Unlike Crystal Reports, with .rpt Inspector you can open one, two, a hundred, or several hundred Crystal Reports all at the same time1. Which means you can use the tools in .rpt Inspector to find and filter in common objects and properties (formulas, parameters, parameter default values, text, headers, footers, size, driver, database, printer, schedules, instances, database logons, formats, destinations, etc.) across the selected Crystal Reports and modify them all at the same time -- all with visual feedback.

Read further for details and screen shots of each of the 16 tools part of this powerful suite.


click to enlargeImproved in v3 - Data source / Database Migration and Conversion
  • Mass ... Change Data Source, Set Location, Convert Driver, Verify Database

Need to ...

  • click to enlargechange your Crystal Reports data source?
  • move your Crystal Reports to a different database with the same tables & fields?
    (i.e. from a development database -- to a staging / QA database -- to a production database)
  • migrate your reports to a different database and/or different driver?
    (i.e. from Oracle 9i to SQL Server 2000)
  • rename or remove fields and update the mappings in your reports to reflect the changes?
    (i.e. changed field Employee_Number to EmployeeNo)

The Data source / Database Migration and Conversion wizard makes this process quick and easy.

Specify your ...

  • Crystal Reports to work with
  • source(s) (each Crystal Report's table / view / stored procedure -- is a source)
  • destination database
  • action(s) to perform for each of the selected source(s) or use the wizard's suggestions
    (for each source in the report, you can specify a different action -- Change Data Source, Set Location, Convert Driver, Verify Database)
  • destination table / view / stored procedure (the wizard will make a suggestion if it can)

You can literally make changes to hundreds of Crystal Report's data sources and/or databases, update field mappings, and more in minutes.

Database Connection Method

Supported Databases
Access Excel

DB2

Informix Oracle

SQL
Server

Sybase Other
ODBC Yes - However Not Tested In Our Labs
New as of 3.02 - DAO            
OLE DB Yes - However Not Tested In Our Labs
Native Driver      

Note that there is currently limited support for stored procedures (currently only stored procedures without parameters are supported as we do not prompt for those parameters -- this is expected in a future version).

 


Database Analyzer
  • Find, Analyze, and Group By Data Source / Database, Drivers, Connect Strings, Tables, Fields (including quickly those in use and not in use), and more ...

Need to find and analyze ...

  • which fields are in use or not in use?
  • what field types (string, numeric, etc.) are used for your fields?
  • what database, driver, etc. is used in your reports to do an impact analysis?

Our Database Analyzer tool makes it quick and easy.

Such as ...

  • DatabaseFieldName
  • Defintion Name
  • TableAliasName
  • ValueType
  • NumberOfBytes
  • ConnectBufferString
  • DatabaseType
  • DescriptiveName
  • DllName
  • Location
  • LogOnDatabaseName
  • LogOnServerName
  • LogOnUserID
  • SessionUserID
  • SubLocation

When your Crystal Reports are open, we retrieve all data source and database related properties and expose them to you in a property list for you to make your analysis.

To further ease your efforts, you can group by any of these properties to quickly and easily get to the information your looking for.

 


Improved in v3 - Search and Replace
  • Search and Replace Text in all Objects
  • Supports Pattern Matching (Regular Expressions) in Search and/or Replace*
  • Saves matches on Finds and/or Replaces in History (exportable to Clipboard, CSV, or XML)*

Not sure ...

  • which report has a formula definition that contains "*.20"
  • which text objects contain "Acme Corp."

Use our powerful search and replace engine. You can search for specific text even if you're not sure of all the placesclick to enlarge it resides (text objects, parameter objects, formula objects, etc.). It's easier than ever to find what you're looking for and/or replace it with something else. You can even fine tune your search by specifying which specific types of objects to search.

And if you want to get even fancier, you can take advantage of our pattern matching search and/or replace* which uses regular expressions.

* Denotes a new feature


Text Editor
  • Find, Analyze, Group By, and Modify
  • Text
  • Font properties (Font / Font Size / Font Style)
  • Color properties (Text Color, Back Color, Border Color)
  • Line properties
  • Paragraph properties
  • Size properties
  • Position properties
  • and more ...
  • Standardize Text (edit, copy, paste text -- across multiple text objects across multiple reports)
  • Fonts
  • Colors
  • Lines
  • Paragraphs
  • Sizes
  • Positions
  • and more ...

Now you can modify the various properties of your text objects with ease. And it's integrated with our Spell Checker tool.


Formula Editor
  • Find, Analyze, Group By, and Modify Definition Text (with Crystal and VB Syntax highlighter and Validation)
  • Standardize Formulas (edit, copy, paste definition text across multiple formulas across multiple Crystal Reports)

Do you have formulas that are ...

  • variations on previous formulas
  • almost the same and you want to standardize them
  • in need of updates or changes

Our Formula Editor allows you to quickly and easily find in common formulas, apply changes to one or multiple formulas at the same time, and copy and paste formula definitions -- across one or many formulas -- across multiple Crystal Reports.

All in a powerful easy to use Formula Editor that supports formula validation checking and keyword syntax highlighting in your choice of Crystal or VB formula syntax. And it's integrated with our Spell Checker tool.


Parameter Editor
  • click to enlargeFind, Analyze, Group By, and Modify Prompt, Default Values, and more ...
  • Standardize Parameters (edit, copy from source and paste to multiple destinations across multiple Crystal Reports, add new values, change order, etc.)

It's now easier than ever to standardize and update your parameter's default values.click to enlarge With our Parameter Editor (default values editor) you can select multiple parameters across one or many Crystal Reports and you can append or overwrite default values with ease.

Another way to work with parameter default values is our one-to-many copy relationship. This allows you to select your source, copy its values, and paste them to as many destinations as necessary.

And it's integrated with our Spell Checker tool.


Improved in v3 - SQL Expressions Editor
  • Find, Analyze, Group By, and Modify
  • Name
  • Formula Name
  • Value Type
  • Definition Text
  • NumberOfBytes

It's now easier than ever to standardize and update your SQL Expressions. Our SQL Expressions Editor lets you work with the various properties that make up SQL Expressions.

The DefinitionText property is powered by the same powerful Formula Editor that supports formula validation checking and keyword syntax highlighting in your choice of Crystal or VB formula syntax. And it's integrated with our Spell Checker tool.


Objects Editor
  • Find, Analyze, Group By, and Modify objects that appear and are used on the Crystal Report's design
  • Blob Field
  • Box
  • CrossTab
  • Database Field
  • Formula Field
  • Graph
  • Group Name
  • Line
  • Map
  • Olap Grid
  • Ole
  • Parameter Fields
  • Running Total
  • SQL Expression
  • Summary
  • Special
  • Text
  • and more ...
  • Standardize object properties (across multiple text objects across multiple Crystal Reports)
  • Borders
  • Colors
  • Currency Formatting
  • Date Formatting
  • Fonts
  • Lines
  • Number Formatting
  • Paragraph Formatting
  • Positions
  • Sizes
  • Conditional Formulas
  • and more ...

When you design a report, in addition to the database fields you can put on the design, can also create various objects (Box, Text, Formula, Parameter, SQL Expression, etc.) and put some or all of them on the design of the report.

The Objects Editor is designed to work with only those objects that appear on the design (the objects that are in use) of the report. Those objects that do not appear on the design (those that were created but are not being used) can still be accessed and worked with their respective editors (Formula, SQL Expression, Parameter, Running Total, Alert, etc.) on the respective Tab of the Objects Grid.

Now you can see and modify the various properties of your objects with ease.

All conditional formulas are powered by the same powerful Formula Editor that supports formula validation checking and keyword syntax highlighting in your choice of Crystal or VB formula syntax. And it's integrated with our Spell Checker tool.


Improved in v3 - Running Totals Editor
  • Find, Analyze, Group By, and Modify
  • Name
  • RunningTotalFieldName
  • Value Type
  • HierarchicalSummaryType
  • NumberOfBytes

It's now easier than ever to analyze your Running Totals.


Section Editor
  • Find, Analyze, Group By, and Modify Sections
  • Name
  • AreaName
  • Number
  • Number Of Objects
  • Color and Size (Back Color, Conditional Formula, Width, Height, MinimumHeight)
  • CssClass
  • HideForDrillDown
  • Suppress (and Conditional Formula)
  • SuppressIfBlank (and Conditional Formula)
  • PrintAtBottomOfPage (and Conditional Formula)
  • NewPageAfter (and Conditional Formula)
  • NewPageBefore (and Conditional Formula)
  • ResetPageNumberAfter (and Conditional Formula)
  • KeepTogether (and Conditional Formula)
  • UnderlaySection
  • and more ...

It's now easier than ever to work with sections using our Section Editor which allows you to modify the various properties of your sections with ease.


Set Default Printer
  • Change the default printer on your Crystal Reports

The default printer that is set in your reports can impact the final look and feel of your Crystal Report -- both in the viewer as well as when exported.

Use our Printer Change Wizard to quickly and easily change the default printer and its properties across multiple Crystal Reports at the same time.


Alerts Editor
  • Find, Analyze, Group By, and Modify SQL Expressions
  • Definition Name
  • ConditionFormula
  • DefaultMessage
  • MessageFormula

It's now easier than ever to standardize and update your Alerts. With our Alerts Editor you can work with various properties.

The formula modifications are powered by the same powerful Formula Editor that supports formula validation checking and keyword syntax highlighting in your choice of Crystal or VB formula syntax. And it's integrated with our Spell Checker tool.


Spell Checker
Now you can spell check your text and even add custom words to the dictionary. No more embarrassing typos.

The spell checker is available in our Text, Formula, and Parameter editors.click to enlargeclick to enlargeclick to enlarge

 

 


Report Playlists

  • Similar in concept to MP3 Playlists
  • Create an virtually unlimited number of Report Lists
  • Each report list can have a virtually unlimited number of Crystal Reports (sorted in your preferred order) from various directories on the file system
  • Opening a Report List automatically opens all associated Crystal Reports

click to enlargeDo you work with the same sets of reports? You no longer need to open them one at a time (even if you select multiple Crystal Reports in the open dialog you'll love this feature).

Just like an MP3 playlist, you can create a virtually unlimited number of Report Lists. Add to each report list any number of Crystal Reports you'd like, from any directory on yourclick to enlarge system or mapped drive.

Then click on a report list and it will automatically open all reports in the list.

 


Multiple Report Viewers / Preview Windows

  • See multiple reports in their own preview window
  • Visually compare reports

click to enlargeIn addition to showing you open sub-reports as a separate tab (configurable in TOOLS | OPTIONS), we have now given you the ability to open a virtually unlimited amount of preview windows. Simply right click on one of the report tabs in the preview viewer pane and select Open In A New Window open.

click to enlargeBut we didn't stop there. You can drag and drop the report tabs between all open preview windows. And if you want your sub-reports to automatically follow, turn it on in TOOLS | OPTIONS.

This powerful feature allows you to quickly and easily see your changes come to live to multiple previews at the same time.


Open Multiple Reports or Entire Folders (and sub-folders)
  • File | Open dialog supports selection using CTRL + CLICK as well as SHIFT + CLICK
  • File | Open | Folders dialogs supports selecting an ENTIRE folder -- with even its sub-folders


ODBC / OLE DB / Native DB2 / Native Informix / Native Oracle / Native SQL Server / Native Sybase - product wide support

In version 1 we supported ODBC for the preview viewer and the data source wizard.click to enlarge

As of version 2, we've greatly expanded our connectivity support.

Now when enabling the preview viewer and making a connection to a database, you'll be prompted to enter a user id and password if necessary on all supported connectivity methods. For connectivity methods that require specifying more information then just a user id and password (OLE DB and Native drivers) we completely support this too.


Drag and Group

Originally introduced in version 1, our patent pending technology allows you to quickly and easily analyzeclick to enlarge properties across objects and reports.

Drag and Group is the concept of selecting item(s) in the Objects pane, and dragging one or more properties from the Property pane down to the Objects pane (to any grid on any tab) to create a new column. Then right clicking on the column header and selectingclick to enlarge group by object name (where the object name is the name of the column; i.e. font; font color, formula, etc.). The result is a pivot view.

And as of version 2, we've further optimized performance on grouping and moving items within the groupings (top / bottom / up one / down one). Plus we've exposed theclick to enlarge grouping level color configuration and added support for auto-refresh of groupings.
 

 


Dockable and Floatable window panes and menus

All windowclick to enlarge panes and menus dockable and floatable. This gives you ultimate control of the user interface to customize as you see fit.

Many editors (text, formulas, parameters, etc.) have also support docking.
 


Customizable layouts

With our dockable and floatable window panes and menus, you'll want to customize the layout that suits you best. So we've given you the ability to save a virtually unlimited number of customizable layouts that you can quickly and easily switch to on the fly.

But don't worry. It's easy to return back to the default layout at anytime.click to enlargeclick to enlargeclick to enlarge


   
Crystal Report 16 tools in the most powerful suite for Crystal Reports. Data source / Database migration and conversion, analyze, documentation, text, objects, formulas, parameters, search & replace, export to Excel and a lot more with .rpt Inspector!

Crystal Report 16 tools in the most powerful suite for Crystal Reports. Data source / Database migration and conversion, analyze, documentation, text, objects, formulas, parameters, search & replace, export to Excel and a lot more with .rpt Inspector!