Contents 

AdeptSQL Diff Reference
AdeptSQl Diff versions, history and milestones
Supported versions of MS SQL Server
Getting started
Connecting to databases
Scanning available servers
Saving and opening comparisons
Running from command line
Diff in portable mode
Working with the schema
Viewing schema differences
Ignored Differences
Comparing objects side-by-side
Dragging and dropping schema items
Using schema filters
Generating comparison reports
Customizing the reports
Executing the SQL
SQL errors and warnings
Transaction support
Keyboard shortcuts
Editing commands and keyboard shortcuts
Using keyboard templates
Choosing debugger's key mapping
Comparing table data
DataDiff overview
DataDiff configuration dialog - table-level
DataDiff configuration dialog - columns
Special situations comparing data
Exporting data to Excel
DataDiff Reports
Column configuration file
Configuring AdeptSQL Diff
Options dialog
Schema Scan
Selective Loading
Comparison
Name Comparison
Code Comparison
User-defined types
Indexes and Statistics
Permissions and XProps
Synonyms
Other details to ignore
Scripting
General logic
Side-by-side scripting
Formatting
Identifiers
Schema Level
Tables
Constraints
Default Values
Procedures, Views, etc
Visuals
Text Fonts
Schema Tree
Summary collections
Side-by-Side View
Suppressed dialogs
Data comparison options
General
Scripting
Column Config File
Using COM Automation interface
Automating schema comparison
Automating data comparison
Licensing and contact info
Registration of AdeptSQL Diff
License conditions
Contact information

AdeptSQL Diff Online Help

Prev Page Next Page

Customizing the reports.

Top  Previous  Next

The Diff can use for reporting either internal (built into the executable) or optional external (loaded from files in Reports/ subdirectory) report templates. Both schema- and data- report templates are tightly integrated with the hardcoded part of template generation. This means that the current architecture only allows to make small changes in the report styles, like customizing cell sizes, colors, borders or fonts.

Each of the two (schema- and data-) pre-report dialogs has a template selection combobox, which always contains a "(built-in report)" choice and is additionally filled with suitable filenames from the Reports/ subdirectory. The schema reports dialog only scans report template files ending in ".sch.fr3", whereas the DataDiff report dialog uses templates ending in ".dd.fr3". Since template files for schema- and data- reports have different structures, this naming convention helps to avoid confusion.

On each pre-report dialog, there is an [Edit] button to the right of the template selection combobox. The button invokes FastReport's designer with the currently selected report template. When you edit the template, you must not delete nor rename controls nor move them from the band where they are defined. Sizes, colors, fonts, relative positions or visibility of report components can all be changed, carefully.

The reports don't use the color settings for various matched/mismatched elements as defined in the Schema Options dialog. Instead, each report template contains a number of invisible (at runtime, but visible in the designer) controls whose font and color attributes will be used in various situations. All these configurable controls are clearly explained right in the template, so your changes to the templates should be mostly to those controls.

Once you are done modifying the report template, save it to a file with a proper extension, as described above: ".sch.fr3 for schema reports or .dd.fr3 for DataDiff ones. This version of Diff doesn't verify that you use the correct extensions, so you have to be careful. If you have named the new report correctly, it will then appear in the report selection combobox.

   
Converted from CHM to HTML with chm2web Standard 2.85 (unicode)