Dyanmic Stretching within the Detail Band

rbuser

I want to produce a soil boring log from a database of depths and
descriptions (e.g., 0-2 meters Sand and Gravel; 2-10 meters Clay, etc.)
uing Report Builder. The goal is to have an area that stretches
vertically to match a given scale (let's say 25 meters per page), with
the 0-2 meter section containing the description (Sand and Gravel), and
the 2-10 meter section containing its decription. It would also be nice
to include a visual identifier such as a fill or pattern in a column.

Is there an example something like this included with ReportBuilder?

Thanks



--- posted by geoForum on http://delphi.newswhat.com

nardmoseley

Please modify your newgroup settings to post using your real name. That is a
requirement of these newsgroups. Thanks in advance.

I can think of a few ways to approach this.

1. Use the DetailBand.BeforePrint event to calculate the number of meters
the record represents. Then set the DetailBand.Height to represent that
scale.

Or

2. Use the DetailBand.BeforePrint event to calculate the number of meters
the record represents. Then set the DetailBand.BandsPerRecord property to
that value.

Or

3. Write some code to pre-process the data, and create a temp table or in
memory dataset that contains one record for each meter.

For numbers 2 and 3 above, for the report layout, set the height of the
detailband such that 25 bands will fit on the page. And set the detailband
PrintCount to 25.

Use SuppressRepeatedValues property to limit the description to only
printing when it changes.

For the visual description use a Shape object and use the Shape.Brush.Style
and Shape.Brush.Color to change the fill pattern based on the description.
Or use an Image and create a bitmap to represent each description.

Use the DetailBand.BeforePrint event to map the description to the visual
representation.


--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com