Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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?

Reports

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    (Edited  )
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!
Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top