Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Alternate row colors
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 7
Miscellaneous
Thread ID:
01128698
Message ID:
01128733
Views:
24
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform