Hello.

At one time I remember there being a SET command that would show all data from a BY statement. Normally, when you do a BY, it will show:

2000 red
blue
2001 red
blue

With the SET command, which was helpful in Excel, it would show:

2000 red
2000 blue
2001 red
2001 red

I've done some searching on the forums, and I am not having much luck in locating it.

Thanks,
Mark

Version: WebFocus 7.1.3, Windows

SET BYDISPLAY=ON

Thanks - exactly what I was looking for!

Mark

Version: WebFocus 7.1.3, Windows