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…”.
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.
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.
The i-net Clear Reports installer recognizes headless computers and starts a text-based installation for installing the report server on headless systems.
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.
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.
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.
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 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 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.
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!
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.
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
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.
“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.
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 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.
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-Home: Go to page 1
Ctrl-End: Go to last page
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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 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.
You can remove a database table connection in the visual linking manager by highlighting the link with the mouse and pressing
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.
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.