Hi Cathy,

Thanks, I got it to work!

>>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.)
>
>
>Jim,
>
>Here's my suggestion ... Build a cursor that has the description, twn, range, and section fields set as memo fields and only use one record per Road Number. As you scroll through the twn/range/section records to build the cursor, check to see if this road# already exists in the cursor. If it doesn't add it. If it does, add the values to the existing fields instead of adding a new record.
>
>

>REPLACE twn WITH mycursor.twn + CHR(13) + thistwn, ;
>   range WITH mycursor.range + CHR(13) + thisrange, ;
>   section WITH mycursor.section + CHR(13) + thissection ;
>   IN mycursor
>

>
>Now in your report definition, you can set the description, twn, range and section fields to stretch and they will stretch for the number of rows you have.
>
>The only problem you would have with this solution is the possibility of page breaking in the middle. If you can figure out a safe maximum number of lines, you could use grouping to make a safe break. Create a group on RECNO(). In this group, set the "Start Group on new page when less than ???" value to something that matches your safe maximum. This will prevent a detail band from showing up at the bottom of the page and then rolling to the next page.
>
>Cathy