Click Drag and Drill
Click, Drag, and Drill (CDD) is a Windows-based report writer where you can select report elements and design reports using click and drag definitions. CDD allows you to drill down to linked reports, with optional pop-up selection criteria prompts that appear prior to these drill downs. CDD may be used with any ODBC-supported, relational database.
Report ID and Report Name do not support special characters or blanks. Report issues will result if these are used.
Features
User-defined AKA (Also Known As) feature allows you to apply aliases to data elements so that the names are meaningful.
Report output can be displayed in graphic format including pie charts and three-dimensional bar graphs. You can produce high quality, professional reports.
Double-click on a retrieved data element to drill down to detail levels. Pop-up prompts may be designated to occur prior to the drill down. For example, if you drill down to transaction level details from the master level report entries, the report can be set up so that you are prompted for a date range.
An unlimited number of sort levels can be defined to accommodate complex sorts.
Printers can be selected to accommodate a variety of outputs.
Multiple fonts, pitches, and colors are supported on a single report so that visual impact may be designed into the final product.
Comprehensive totaling and subtotaling logic allows for total lines in a variety of regions on the report. For instance, subtotals may be inserted at every sort break.
Derived values may be defined based on rows, columns, rates, and constants so that values other than those stored in the database can be reported.
The report creation process is visual; while selecting data elements, a sample report is displayed. What-You-See-Is-What-You-Get (WYSIWYG) format gives you instant feedback about how the report will look. This speeds creating reports.
Linkages between tables (joins) are easily created and identified.
Report output may be routed to the screen, a printer, a file, or exported to popular spreadsheet software.
Special hidden row and column elements allow the user to perform calculations at the detail level and display the results at the total level.
Complex selection criteria is supported so that the report contains only the information desired.
Comprehensive security may be set. For example, a user might be restricted to see only the records belonging to a specific department.
Sub-report feature allows users to nest reports within reports for greater power and flexibility.
Reports can be grouped in hierarchical folders for easy management.
Catalog View Manager allows user to create views in their Informix database without using dbaccess or esql-c. CDD enforces all applicable security on these user-created views.
Reports can be converted to Hypertext Markup Language (HTML) to display using your favorite web browser.
PDF Export only allows Letter size (8.5 x 11) and can be formatted as portrait or landscape.