Jim,

Looks like you need to build a cursor with one record per section. Each record will repeat the "long description" text as well as the paved, curb, and guardrail.

In the report use stretch for the "long description", use "don't repeat values" for everything but Twn, Range, and Section. Use "remove line if blank."

Other ways to do it is to have a header and then just "long description" (don't repeat values), Twn, Range, and Section in the detail. Use "remove line if blank."


>Here’s my problem. I have data in 4 tables. One has the road name and number, another has the locations of the road in township, range and section. I also have information in the other tables that is needed in the report (miles of asphalt, guardrails, curb length etc., and the road’s description.) I would like to combine data from the 4 tables and have the report look something like this:

>Rd#    Name        Paved Miles   Curb Miles   Guardrail   Twn  Range Section
>         Description:
>
>X1111  Jim’s Road    1.0             0.5          0.0      13    19    01
>         A road going south then north,                    13    19    02
>         then going east and west                          13    19    03
>                                                           13    19    04

>Is there a way that I can stack the Twn/Rng/Sec data at the side of the report and also have the description in the area beneath the road name and beside the Twn/Rng/Sec? (Grouping seems to only layer that information which takes up too much report space.)