Reports with Watermark

With the section property “Underlay Following Section” you can create watermarks. A watermark can include images, text and any reporting component. To ease the creation of watermarks, since version 9.1, you can use the menu item “Insert | Water Mark…”.

Dynamic Image from Database

You can easily add images saved in the database to your report. They are usually represented as binary columns in the database. Drag and drop the field into the report and you have a dynamic image.

Dynamic Image from URL or file

If you want a dynamic image from a URL/file, add a static default image first. In the picture properties, set the “Dynamic Image Location”. This can be an absolute URL or one relative to the report file.

Setup on Systems without display

The i-net Clear Reports installer recognizes headless computers and starts a text-based installation for installing the report server on headless systems.

Restrict client access to the Remote Interface

The IP filter setting in the configuration manager is a simple and effective way to restrict the access of client PCs (IPs and ranges) to the web-based Remote Interface.

Editing reports stored on the server

You can open reports from a repository from within the designer. When you run this report, it will be rendered on the server rather than on your local machine. This helps you to ensure that the report is designed and tested with the server's settings, fonts and data sources.

Central management of reports

In order to manage reports at a central location, create a repository and set the user rights. With only a few settings, the co-workers from each department can manage, edit and access their reports from everywhere.

Connecting Windows to the repository via WebDAV

Managing your reports in the repository with your Windows Explorer is easy. Go to the network environment and select “Add a Network Location” from the context menu. Follow the steps of the wizard and enter your repository location as url, e.g. http://localhost/crystalclear/repository/. After finishing the wizard, you can create, copy, move and delete the reports from your Windows Explorer.

Ad hoc - saving reports

Ad hoc reports can be saved at any time - even if they are not finished yet. So if you find you often use the same layout with the same data source and tables, just save the report at this point to create similar reports even faster.

Ad hoc - switching layouts

Ad hoc tries to preserve the settings of your report whenever possible. So you are free to change the layout of your report at any time. You may even want start setting up your report with a complex layout and wait until later to check which layout fits your needs best.

Formula - auto completion

The formula editor features an auto completion popup (since Version 10). Press Ctrl+Space at any point in your formula to see how the current expression can be completed. This feature even completes fields or syntax structures and shows the required parameters for functions!

Embedding an HTML page

There is a simple way to embed an HTML page into your report. Create a formula field with content “TextFromFile(<anyURL>)”, drag this field into your report and set its text interpretation property to “HTML (advanced)” as well as its base URL to the referred page. This will embed the HTML page using i-net Clear Reports's own HTML renderer.

Chart Colors

Every chart can have its own color palette. The colors can be set in the tab “Color” of the Chart property dialog - either by color chooser or formula. To re-order colors, simply drag and drop them in place. Note: You should create a new palette by “Copy” first.

Combined Charts

Different charts can be combined into one - either as an overlay or side-by-side. This can be done by creating new charts from the “Combined” tab of the chart property dialog. The following chart types can be combined: Bar, Line, Area.

Securing the Server

The tab “Performance” in the Configuration Manager offers several options to secure a server against several problems: long running reports, reading too many datasets from a database or OutOfMemory problems.

Custom Designer and Ad hoc templates

You can easily create new and modify the templates used for the Designer Report Wizard and the ad hoc reporting module to meet your corporate design. The default templates are stored inside your “<installation>/templates” directory and can be edited like any other report template.

Ad hoc date and time groups

Ad hoc reporting offers several options to group time-based data e.g. by day, month or year. In addition you can set the result to be linear or grouped periodically. This is useful for charts with recurring or straight time intervals.

Viewer Keyboard Shortcuts

The Java report viewer offers various keyboard shortcuts that speed up its usage.

  • Ctrl-Plus/Minus: zoom in and out
  • Ctrl-F: Search Text
  • Ctrl-S: Save/export report
  • Ctrl-P: Print
  • Ctrl-Home: Go to page 1
  • Ctrl-End: Go to last page
  • F5: Refresh

Viewer Continuous View

You can set the Java report viewer to display the report in a single-page or double-page continuous view, which will automatically fetch the pages below and above your current spot on-the-fly, making it unnecessary to flip through pages.

Java Report Archive Format

You can save your finished report in the JRA format which will enable you to open it at any time from any Java report viewer. Note you can alternatively bundle the report with a viewer and save it as a JAR file which opens up a viewer with the report when it is executed.

Cascading Parameters

It is possible to set parameters for a report whose default values are fetched dynamically from the database when the report is executed. These parameters can be cascading, e.g. you could have one parameter “Country” which shows all countries in your database and another one “City” which would then only display the cities in the country chosen for the first parameter.

Viewer Copy and Paste

In the Java Report Viewer, you can select any text in your report with the text selection tool and copy it. It will be copied to the clipboard as plain text. The viewer also includes a simple snapshot tool for copying parts of your report as images to the clipboard.

Drag & Drop of files in Designer

In the designer you can drag & drop files from a file browser or other applications directly into the report. You can drag images, RPT files as sub reports, HTML files, RTF files and plain text files.

Open contextual Help in Designer

In the designer you can use the F1 key to open the contextual help. For example, in the formula editor you can select a function name and then press F1 to get the help for this function.

Written Guides

If you need more information about the i-net Designer, the basic concepts of i-net Clear Reports, security features etc., read our written guides. You can find them in the installation directory (if installed) or on the i-net Clear Reports website.

Reports for multiple languages

i-net Clear Reports offers a simple way to create localized reports. Using the translator in the i-net Designer menu “report | translations” or via the API it is possible to localize individual reports. But you can provide a global set of translations as well. These will be applied to all reports provided by the server. Learn more from the internationalization guide.

Suppress or Display report elements or sections dynamically

Using parameter field values or other (database) field values you can suppress/display fields or parts of the report dynamically using the suppress property formula of each element.

Scheduling Reports

With the scheduler of i-net Clear Reports Plus, it is possible to schedule report executions. For example, you can execute a report in a specific interval or at a specific time and send it as a PDF file to a specific email address.

Start or end value of a Range

Using range prompts instead of 2 prompt fields is more convenient for the person running the report. If you want to access the start or end value of a range in the report, use the formula functions minimum(x) or maximum(x).

Form Print

Form printing can be complicated due to scaling issues of the non-printable margins. To prevent the report from being scaled at all, you can choose the “form print” option in the page settings of the designer. Any content in the non-printable margins will then be truncated.

Visual Linking

You can remove a database table connection in the visual linking manager by highlighting the link with the mouse and pressing “Delete”.

AdHoc: column order

To specify the order of columns added to your report using the report wizard (or the ad hoc GUI), drag and drop the rows in the dialog accordingly.

Report as a folder

Instead of saving reports as zipped Open-Document-like files you can save them as a Folder as well (e.g. for proper version control). To enable this feature, check “Save/load report as folder” in the Designer configuration.


© Copyright 1996 - 2021, i-net software; All Rights Reserved.