Re: SQL questions

From report builder help

Description The Vertical Elasticity property is how the vertical size of the object may change at runtime to accommodate the objects or data within it:

For frames and repeating frames, elasticity defines whether the size of the frame or repeating frame should vary with the objects inside of it.

 For objects containing text, elasticity defines whether the field or boilerplate should vary with the size of the text. Fixed size text will wrap within the defined size of the object and may be truncated if there is not enough room. Number or date data will appear as asterisks if the data cannot fit within the defined size.

 For images, drawings, and chart objects, Report Builder uses proportional scaling. The elasticity options for images, drawings, and chart objects determine the scaling factor.

 Click here.
Values

Contract Means the vertical size of the object decreases, if the formatted objects or data within it are short enough, but it cannot increase to a height greater than that shown in the Report Editor. Truncation of data may occur; look at the examples. (You can think of this option as meaning "only contract, do not expand.")
Expand Means the vertical size of the object increases, if the formatted objects or data within it are tall enough, but it cannot decrease to a height less than that shown in the Report Editor. (You can think of this option as meaning "only expand, do not contract.")

Fixed Means the height of the object is the same on each logical page, regardless of the size of the objects or data within it. Truncation of data may occur; look at the examples. The height of the object is defined to be its height in the .
Variable Means the object may expand or contract vertically to accommodate the objects or data within it (with no extra space), which means the height shown in the Report Editor has no effect on the object's height at runtime. Applies to layout objects
Required/Optional required
Default varies according to the object
Usage Notes

 If you create a chart object in your report with a Vertical and Horizontal Elasticity of Fixed, Report Builder scales the Graphics Builder display to fit within the dimensions you defined for the object.

"Sarah" <s_at_nospam.com> wrote in message news:3K%Q9.55986$Jb.55196_at_nwrddc02.gnilink.net...
> Is this a good newsgroup to ask questions on SQL reports or is there
another
> good one that I should know of?
>
> My question is where can I find out more about "vertical expansion" and
how
> to use it. Someone suggested to me that it would help in a report I am
> writing but I am having trouble finding any documentation on it.
>
>
Received on Thu Jan 02 2003 - 21:55:06 CET