Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Alternate row colors
Message
 
To
13/06/2006 11:17:50
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 7
Miscellaneous
Thread ID:
01128698
Message ID:
01128740
Views:
22
>Hi David
>
>>...I am setting up a report which uses a single table containing header and detail records (invoice with charges).
>
>I'm having trouble picturing this - do you actually have header rows and detail rows? If I were doing a report like this I'd have a denormalized cursor with both the header and detail information in one row.

It is as you suggest.

>
>> ...The report likewise has a header band (Invoice) and detail band (charge). What I want to do is alternate the colors for each invoice, ...
>
>Do you mean the first invoice is entirely white and the second invoice is entirely shaded? What I'd do here is add a column to the report cursor that numbers the groups of rows for each invoice and then use that for the Print When expression in both the header and detail. To number the invoices you could Select Distinct a header field such as InvoiceNumber, set a relation from that into the report cursor and replace the report cursor's identifying field with RecNo("InvoiceNumbers").

Right - that is what I would normally do as well.. My problem is that I am trying to enhance some reports for an application developed by another party - so I don't have much control over the data created. I guess I was thinking there might be a way - within the report designer - to specify to alternate for each header (as opposed to record #, etc.).

Thanks Cindy.
Previous
Reply
Map
View

Click here to load this message in the networking platform