Hide Duplicates - and border

If a person selects the "hide duplicates" option in a Table/Group, how would
one also hide the "border"?
I've tried using expressions to set the borderstyle to None, and this works,
but I can't figure out how to evaluate if a table cell (value) is "hidden".
Below is what I'm trying to do, hide the border, if the (duplicating) value
is hidden.
Division Product 1999 2000 2001 2002
North Wiget 100 200 100 300
Racket 100 200 100 300
Doget 100 200 100 300
South Wiget 100 200 100 300
Racket 100 200 100 300
Doget 100 200 100 300
East Wiget 100 200 100 300
Racket 100 200 100 300
Doget 100 200 100 300
West Wiget 100 200 100 300
Racket 100 200 100 300
Doget 100 200 100 300
Thx,
RussellHaven't tried it but you should be able to use a conditional border based on
the Previous() aggregate.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Russell Hardie" <russell_hardie@.cranevalve.com> wrote in message
news:uN%23WlOexEHA.2036@.TK2MSFTNGP12.phx.gbl...
> Sorry, but my example did not come across as I sent it.
> I've attached a jpg as an example...
> Thx,
> Russell
>
> "Russell Hardie" <russell_hardie@.cranevalve.com> wrote in message
> news:eWFwWGexEHA.2036@.TK2MSFTNGP12.phx.gbl...
>> If a person selects the "hide duplicates" option in a Table/Group, how
>> would
>> one also hide the "border"?
>> I've tried using expressions to set the borderstyle to None, and this
>> works,
>> but I can't figure out how to evaluate if a table cell (value) is
>> "hidden".
>> Below is what I'm trying to do, hide the border, if the (duplicating)
>> value
>> is hidden.
>> Division Product 1999 2000 2001 2002
>> North Wiget 100 200 100 300
>> Racket 100 200 100 300
>> Doget 100 200 100 300
>> South Wiget 100 200 100 300
>> Racket 100 200 100 300
>> Doget 100 200 100 300
>> East Wiget 100 200 100 300
>> Racket 100 200 100 300
>> Doget 100 200 100 300
>> West Wiget 100 200 100 300
>> Racket 100 200 100 300
>> Doget 100 200 100 300
>>
>> Thx,
>> Russell
>>
>|||Thanks Brian,
That is my issue. I have been trying to do a conditional border, but I can't
figure out what the "expression" is that I need to use to evaluate to True.
If I test the textbox (in the table) for Value="" it returns a False. I
assume that the textbox still has a value, it's Visibility is just hidden.
So what I can't figure out is the expression to use to test a textbox's
"Visibility" (if this is the correct approach).
Thanks,
Russell
"Brian Welcker [MS]" <bwelcker@.online.microsoft.com> wrote in message
news:%23Hz3i$ixEHA.1260@.TK2MSFTNGP12.phx.gbl...
> Haven't tried it but you should be able to use a conditional border based
> on the Previous() aggregate.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Russell Hardie" <russell_hardie@.cranevalve.com> wrote in message
> news:uN%23WlOexEHA.2036@.TK2MSFTNGP12.phx.gbl...
>> Sorry, but my example did not come across as I sent it.
>> I've attached a jpg as an example...
>> Thx,
>> Russell
>>
>> "Russell Hardie" <russell_hardie@.cranevalve.com> wrote in message
>> news:eWFwWGexEHA.2036@.TK2MSFTNGP12.phx.gbl...
>> If a person selects the "hide duplicates" option in a Table/Group, how
>> would
>> one also hide the "border"?
>> I've tried using expressions to set the borderstyle to None, and this
>> works,
>> but I can't figure out how to evaluate if a table cell (value) is
>> "hidden".
>> Below is what I'm trying to do, hide the border, if the (duplicating)
>> value
>> is hidden.
>> Division Product 1999 2000 2001 2002
>> North Wiget 100 200 100 300
>> Racket 100 200 100 300
>> Doget 100 200 100 300
>> South Wiget 100 200 100 300
>> Racket 100 200 100 300
>> Doget 100 200 100 300
>> East Wiget 100 200 100 300
>> Racket 100 200 100 300
>> Doget 100 200 100 300
>> West Wiget 100 200 100 300
>> Racket 100 200 100 300
>> Doget 100 200 100 300
>>
>> Thx,
>> Russell
>>
>>
>