I noticed in the reporting tool of Dev Studio that when I select a BY field, the prefix drop down box has the options "BY" and "ALL". The "ALL" option produces the following code: BY ALL.[field name]. I can't tell a difference in the output. Does anyone know what this prefix does?

Thanks,
Josh

This message has been edited. Last edited by: Kerry,

It has an effect similar to SET ALL=ON: In a parent-child (one-to-many) relationship, Print Child_data BY PARENT would normally omit any Parent that has no child-segment instances; using BY ALL.PARENT would cause the parent value to be included in the output (with Missing as the child segment's field values).

Interesting....

The Atlanta office hadn't heard of it and says that it must be a new feature. Any idea when it was put in? I wonder why they put this in if they already had SET ALL = ON?

-Josh