David,

What? Only the work of 4 people?

Since reports are so difficult to visualize, why don't you send me the report and some data.

cindy.winegarden@duke.edu


>Cindy,
>
>Thanks for your help (prompt, aren't I?).
>
>I am a developer working on a four-person project. Unfortunately, the client has not seen fit to hire more than lil ol' me. So, when I get into a jam, I send out a cry for help, then I get cracking with other things. As you can see, it can take me weeks to get back to a particular problem. I guess I am apologizing for taking so long to get back to you with my results.
>
>So, I defined bil_group as a Report Variable, Value to Store: ord_no+osh_no, Initial Value: "", Release after Report, reset at: ord_no+osh_no. I even placed a text box of bil_group in the report's detail band. And lastly I have a whole bunch of fields in the page footer with Print Whens of: bil_group # ord_no+osh_no. And nothing prints in the page footer, ever. A puzzle.
>
>Your idea seems so obvious and clear, what did I do wrong?
>
>David
>
>
>
>
>>David,
>>
>>If you put the group footer items in the page footer, you can use "Print when" to determine when they print.
>>
>>What you *can't* do is let the space allocated for the page footer be freed up when there are no items to print, the way a "Remove line if blank" works.
>>
>>I also don't think you can force group footer items to be at the bottom of a page if they are located in a group footer band.
>>
>>Maybe Crystal Reports can do some of this. I haven't used it.
>>
>>Good luck, this is a common problem.
>>
>>
>>>Maybe I should never post on the weekend. [Sigh]
>>>
>>>How do I print what is (logically) a group footer at the bottom of a page (as though it were a page footer), not immediately after its details run out? There may be multiple pages of details for a group, and I do not want the footer to print every page of a multi-page group.