Specifications

Modifying general report properties
228 InfoMaker
In the Preview view, the band resizes based on the contents of the columns you
defined as having their height sized automatically.
Using the RowHeight
function with Autosize
Height
When a detail band has Autosize Height set to “true”, you should avoid using
the
RowHeight InfoMaker expression function to set the height of any element
in the row. Doing so can result in a logical inconsistency between the height of
the row and the height of the element. If you need to use
RowHeight, you must
set the Y coordinate of the element to 0 on the Position page in the Properties
view, otherwise the bottom of the element might be clipped. You must do this
for every element that uses such an expression. If you move any elements in
the band, make sure that their Y coordinates are still set to 0.
You should not use an expression whose runtime value is greater than the value
returned by
RowHeight. For example, you should not set the height of a column
to
rowheight() + 30. Such an expression produces unpredictable results at
runtime.
Clipping columns
You can have Autosize Height columns without an Autosize Height detail
band. If such a column expands beyond the size of the detail band in the
Preview view, it is clipped.
Modifying the data source of a report
When modifying a report, you might realize that you have not included all the
columns you need, or you might need to define retrieval arguments. You can
modify the data source from the Report painter. How you do it depends on the
data source.
Modifying SQL SELECT statements
If the data source is SQL (such as Quick Select, SQL Select, or Query), you can
graphically modify the SQL
SELECT statement.
❖ To modify a SQL data source:
1 Select Design>Data Source from the menu bar.
InfoMaker returns you to the SQL Select painter. (If you used Quick
Select to define the data source, this might be the first time you have seen
the SQL Select painter.)