[Previous][Main][Next]
ReportsReport Editor are generated by use of the report editor.
Report editor showing a form print.
GENERAL REPORT INSTRUCTIONS
To make reports you type into the editor the details of the report. Enter the titles, subtitles, and text as needed. Format the titles and text by using color and changing fonts, font styles. Use built in commands for dates (=[date], =[time] or =[datetime]) and then enter placeholders for data (=[1]. =[2], =[3]). Set your tabs for each row in the report. Tabs will help to line up rows of data at the same point in the report.
You can mix and match text with data placeholders. This way you can identify the data with the text.
Set tabs by clicking in the ruler area. Remove tabs by selecting the tab and dragging off the ruler. Move the tabs by selecting the tab and drag.
After you have entered some placeholders for data, select the add sensors button on the right and select the sensors you want to use for the data. After you have made your sensor selection, press the run report button and the report will be produced.
You can not edit the finished report directly. You need to go back to the editor and edit it, and then run your report again. To go back to the editor, click the run button again.
Be sure to save the report with an *.rtf extension. When data has been entered into the sensor list a second file is saved with the sensor information, margins, headers and form size. When the scheduler prints the report, this information is required to make the report look right.
You can print and preview both the setup report and the report itself. Just click on the print or preview buttons. You can also save the data report separately if you need to keep a copy of it. You can always regenerate the report as long as the data is in the database. Real time data will change if you are pulling the current data from the grids.
File Menu: Open and save files, preview, print or print report if sensors are assigned
These are standard word processing commands. Use the print report command if you have data placeholders and have selected sensors for your data. You may want to run the report first to see what it looks like. Press the run report button on the right of the editor to run the report.
Press the Page Setup menu item to set the page formatting options.
Page Setup allow you to set margins, headers, footers and positions. These settings are saved with the report.
Edit Menu: Standard editing function plus run editor.
The edit menu allows you to cut, copy, paste, select all and change font. You must select some text first before you can use these commands. The Run Editor command executes the report by getting the data and showing the finished report. Go back the editor by clicking the same option again.
Report Toolbar and ruler. The two buttons on the right allow you to select sensors for your report and to run the report.
You can view what each button does by placing the cursor over the button. A hint will be shown with the action of the button. The toolbar buttons and windows are as follows:
New file, open file, save file, print file, preview file, cut, copy, paste, undo,
select fonts, font colors, font size,
font styles [bold, italicize, underline], align left, align center, align right, add bullets,
add sensors, run report.
ADDING DATA PLACEHOLDERS
Enter =[1] is the first sensor in the report. Sensors are defined
from any of the defined sensors in the setup grids and file girds.
REPORT FUNCTIONS ENTERED DIRECTLY
Report functions
=[date] =[time] =[datetime] =[day]
=[week] =[month] =[year]
Selecting sensors from the source list. The distination list is used for the report.
Add and remove sensors or SQL statements from the source list. The destination list becomes your report list. You can move sensors up and down in the list once it is entered into the destination list. The number of the destination list relates directly to data placeholder number in the report.
EXAMPLE OF A DAILY REPORT FORMAT
Set your report with the look you want by using standard editing commands. Assign a sensor to each of the =[number], and the values will be inserted into the report when it is run.
Report options: Set page margins, headers, footer,
select sensors.
Each report saves the sensor names, margins, header, and footer information. You can change this information by selecting these options.
You can also run the SQL Editor to enter a new statement for your report. Once you have added the SQL statement to the SQL combo box, it will become available for your report in the data source list.
PRINT PREVIEW
Report preview: Select preview to see how your report will look printed.
Print the report from here by selecting the print button. You can print all pages or select the pages you want from the print dialog that pops up.
Goto Editing Forms
Goto Setup