Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Programmatically control grouping levels?
Message
From
16/04/2001 14:52:31
Jorge Haro
Independent Consultant
Juarez, Mexico
 
 
To
16/04/2001 14:34:02
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00495885
Message ID:
00495898
Views:
13
Have you tried using the Print When option, in combination with a set of variables and "remove line if blank" you should be able to exclude as much of the report as you like, It's usually a pain though, specially because of all the screens you have to go through for each control.

>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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform