[AccessD] Curious behavior with Hide Duplicates and groups

Charlotte Foust charlotte.foust at gmail.com
Mon Sep 13 16:46:24 CDT 2010


It's a matter of scope, Susan.  Hide Duplicates in a header applies
only to that level, if the level is the entire report, that's the
scope too.

Charlotte Foust

On Mon, Sep 13, 2010 at 1:39 PM, Susan Harkins <ssharkins at gmail.com> wrote:
> Using the Hide Duplicates property with the one value is Okay -- if you use it with a many value, you're liable to hide a duplicate value when you don't want to. For instance, in the case of items in an order. You can easily hide the duplicate order id values without worry. If you hide product names for the items in each order, you can run into trouble if the first item in a new order is the same as the last order in the preceding order. The Hide Duplicates property doesn't respect grouping.
>
> What I saw today is that it does -- if you force it.
>
> Adding a group isn't enough -- if you group on the order id, the Hide Duplicates property still evaluates the entire report as one group. If you display a group header, bingo... Hide Duplicates respects the groups.
>
> Okay, so this is cool, but why do you have to display a group header to get it?
>
> Susan H.
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>




More information about the AccessD mailing list