CRTableSearcher

Crystal Reports Table Search tool

This is a Swing UI tool for searching table names in selected list of Crystal Reports. This tool uses Crystal Reports Java Reporting Component JRC for parsing the reports.

How to use

• Install Java 1.7+

• Navigate to dist folder

• java -jar CRTableSearcher.jar will launch the UI

• Select the folder where the reports are. This will search for all folders recursively.

• Select the table pattern

• Multiple table names are separated by ,

    Wildcard * is used for character globbign in table name
    A sample pattern PAT*, HSP*  will search for all table name that start with PAT or HSP
    If report finds any of the table in the pattern the search stops and continue for the next report.
  

• Run the Search

• It will display the matched reports

Cool Stuff

• This tool uses JavaFX WebView to display log messages.
• Implemented a JDK Log Handler to display messages into the WebView
• Created a Log.html which includes Twitter Bootstrap & JQuery
• The Log.js has some public JavaScript functions which will be invoked by JavaCode when ever there is a log message
• Parallel search of reprots using ExecutorService.