Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Microsoft: FoxPro FAQ


When printing a multi-column report that has a "Group BY" and prints horizontally, how do I get the detail to print in the first cell? by BPeisch
Posted: 2 Jan 04 (Edited 7 Apr 04)

VFP has a very annoying "feature" where multi-column reports and labels that print columns horizontally and have a Group By expression will not print the first detail record in row 1, column 1.  The problem is that VFP wants to print the group header in that first cell instead of the first record's detail. This is not a problem in VFP 9.  If you need to do it in an older version, here's a workaround:

1. Copy all the objects to be printed in the detail band and paste them into the group header.  (Yes, you want them in both places!)

2. In the OnExit function of the group header band, put a UDF that skips a single record.  (You have to put a function call in the OnEntry or OnExit command, otherwise, you could just put the Skip right there.) This will prevent the first record from printing in both the first and second columns.

One disadvantage of this technique is that you cannot print a real group header because there's no place for it to print!

Back to Microsoft: FoxPro FAQ Index
Back to Microsoft: FoxPro Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close