Group Title

[Polly66]

Hello all,

I have this report (VFP9) that prints details of three fields in three columns across a page. I can group the report details etc, and everything else seems ok. But how do I create a customised header and footer for my groups. For instance, I have these three fields associated with a group called "Polly". I want to be able to have the header for the group called "Start Polly", and the end of the group detailed by "End Polly".

Thanks if anyone can help.

Bill

 

[JRB-Bldr]

From what you say, can I assume that your table is roughly like the following?

GroupName Field1 Field2 Field3
Polly ABC DEF XYZ
Polly ABD DEX WXY
Fred 4DF 6FG B8R
Fred E9T C1L XX9

If so then in your Report Form you need to create a Group whose Expression is GroupName

Within the upper Group band (the header) you put the GroupName field's Text Box and make the expression whatever you like such as "Start " + ALLTRIM(GroupName)

Within the lower Group Band (the footer) you put the GroupName field's Text Box and make the expression whatever you like such as "End " + ALLTRIM(GroupName), or you could put other text, totals, etc.

Within the Detail Band (working for All Groups) you put the Fieldn Text Boxes.

Good Luck,
JRB-Bldr

 

[Polly66]

Hi JRB-Bldr,

Thanks for the assistance. It is appreciated.

Bill