David
Oh I see. Well, off the top of my head:
I assume youi've used some SQL or whatever to get your parent-child records into the report flat file.
How about when creating the flat file you include a dummy empty field, say, ".F. as Greyed"
Just before reporting, have a quick wizz through the file, alternating the dummy field, T/F, when the inv # changes
Then use the dummy field in your "print when" to determine the colour.
HTH
Terry
>Sorry if I wasn't clear Terry. Let me try again:
>
>I am creating an invoice report. The report derives it's information from a single table, containing two types of records. The header record contains basic invoice information (invoice number, invoice date, customer, etc.). The detail records contain informatin on the specific charges (, invoice number, charge description, amount, etc.).
>
>On the report I want to alternate the background color for each invoice. For instance the first invoice should not show a background color at all. The next invoice should show a background color, ie:
>
>Header Invoice A (no background)
> Detail A (no background)
> Detail A (no background)
> Detail A (no background)
>Header Invoice B (grey background)
> Detail B (grey background)
> Detail B (grey background)
>Header Invoice C (no background)
>.
>.
>.
>
>The header lines are showing on a group header band, with the detail lines in the detail band on the report.
>
>What I am asking is what logic should be in the Print When option of A) the header band, and B) the detail band.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.