The Width property specifies the maximum number of characters that the values of the column can occupy. This Width refers to the width that Reports Builder uses internally for the column. It affects such things as the calculation of summaries and formulas. The size used to display the column's data, however, is determined by the size of the associated field in the Paper Layout view and its Vertical Elasticity and Horizontal Elasticity properties.
Applies to |
Columns |
Values |
For database columns, read-only. For other column types, any number from 1 through 64K. You can enter two numbers in the form a,b where a indicates the number of digits to the left of the decimal point and b indicates the number of digits to the right of the decimal point (this form can only be used for defining the width of numbers.) |
Default |
For database columns, the default Width is derived from the database. For sort columns, the default Width is 38. For summary and formula columns, the default for Width is 10,0. If a column has a Column Type of Summary, Reports Builder updates the Width based on what you enter as the column's Source and Function. |
Required/Optional |
Required |
Caution: If the value of a column of type Database and Datatype Long or Long Raw exceeds the Width of the column, the value is truncated.
If the value of a column of type Placeholder or Formula exceeds the Width of the column, an exception is raised.
If a column has an alias and you change your query, causing the width of the column to change, the change in width will be automatically reflected in Width when you accept the query.
If the Column Type is Database Scalar and the Datatype is Character, Date, Number, or Raw, Width is uneditable. However, this does not mean you cannot control the width of the column's values in the report output. You can change the width of the values in the output by modifying the field's width in the Paper Layout or the Field properties.
If the Column Type is Database Scalar or Placeholder and the Datatype is Long or Long Raw, you can enter a value in Width. Note that if you do not specify a width for a Long or Long Raw column, Reports Builder allocates the maximum width for the column.
Copyright © 1984, 2005, Oracle. All rights reserved.