I have one grouping and the lines are in the group footer. I am displaying both the number of lines and the length of the resulting string
[REPLICATE(CHR(13),27-nlines)] and both are correct (i.e. 1,26 - 3,24, etc).
Strangely enough while this does not work in the group footer it works perfectly in the detail lines (heaps of white space)
Regards
Geoff Scott
>Where did you put this extra field? Maybe nLines has incorrect value?
>
>>It wasn't but ticking it didn't provide any better result
>>
>>Ho Hum!!!
>>
>>Regards
>>Geoff Scott
>>
>>>Did you check Stretch with overflow for that field?
>>>
>>>>Ok, so I figured out how to count the lines and can even print them but my
>>>>
>>>>
REPLICATE(CHR(13), 27 - nlines)
>>>>
>>>>does not do anything. Neither does a field with just CHR(13) in it.
>>>>
>>>>What is the basic mistake I'm making now???
>>>>
>>>>Regards
>>>>Geoff Scott
>>>>
>>>>>>Hi
>>>>>>
>>>>>>Is there any way of flushing a group footer in a report so that it prints at the bottom of the page???
>>>>>>
>>>>>>Regards
>>>>>>Geoff Scott
>>>>>
>>>>>Check Thread #
598553.
May all your weeds be wildflowers