Hello,

Using the VFP 6 report writer, does anyone know how to programmatically add or remove grouping levels? The REPORT FORM command has a SUMMARY clause, which causes it to suppress the detail band, but I can’t see anything to suppress certain grouping levels, or add them on the fly.

For example, you have a report that lists cars, and it groups by manufacturer (Ford, Toyota, etc.), then for each manufacturer, groups by model (Mustang, Taurus, etc.) The detail band of the report lists information for a specific car. Based on the user, you want to suppress or include the model group level.

For example, here’s the report with both detail levels:

FORD
MUSTANG
RED 1232HJ2H26262, MUSTANG
TAURUS
WHITE ASDF8ASDFJAD, TAURUS
BLUE 234923MJ23833, TAURUS
TOYOTA
TERCEL
RED 123483J3J, TERCEL
BLUE 2389HDHD, TERCEL
AVALON
WHITE 3933J3YU73U3, AVALON


Here’s the same report with the model level suppressed:

FORD
RED 1232HJ2H26262, MUSTANG
WHITE ASDF8ASDFJAD, TAURUS
BLUE 234923MJ23833, TAURUS
TOYOTA
RED 123483J3J, TERCEL
BLUE 2389HDHD, TERCEL
WHITE 3933J3YU73U3, AVALON


I’d like to use one report layout (FRX/FRT file) and change it on-the-fly. This can be accomplished with two different layouts, but that’s a kludge, at best. Hand-coding the report or using a royalty 3rd party tool like Foxfire is not an option.

Any ideas?