Show only certain categories in grouped view

[Bucklebery]

Is it possible to show only selected categories in a grouped view? The
application is a custom view that shows:

Small Group Leader Name 1
Person A - Selected by Cat
Person B -
Person C
Small Group Leader Name 2
Person A (Is actualaly in 2 groups)
Person D
Etc

Or am I going beyond the bounds of outlook 2003?
THanks

 

[Sue Mosher [MVP-Outlook]]

Can you say something about how categories fit into this picture? I can't
see it.

 

[Bucklebery]

I was going to use categories to tag whose home group they belonged to (using
the leaders name as a tag) The hopefully group the people by only the Small
group Categories (say 15 of them).

I tried using just a "Department field" to designate a the leader and
members of the small gorup and gouped by depatrment. That worked fine but I
have some folks who are in 2 small groups.

Thanks

 

[Sue Mosher [MVP-Outlook]]

YOu can always filter a view on one or more categories.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Bucklebery]

Yes the filter by the requested categories works Sue but when I group by
Category to show visually who is in the groups I get all the other 58
categories as well - when I really only want the small group categories I
have selected to show in teh grouped view. Can this be done?

 

[Sue Mosher [MVP-Outlook]]

No. If a person appears in more than one category Outlook won't suppress
that information.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Bucklebery]

Thanks Sue - Any other way to achieve a similar effect?

 

[Sue Mosher [MVP-Outlook]]

Maybe you should be using a different field for the group identities. You
could use a custom keywords field.
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Bucklebery]

True I have tried that but I couldn't get the table report to look like the
example I gave layout at the begining off the post ie:

Small Group Leader Name 1
Person A
Person B
Person C
Small Group Leader Name 2
Person A (Is actualaly in 2 groups)
Person D
Etc

Can this be done? Or something close.

CHeers

 

[Sue Mosher [MVP-Outlook]]

If you group by your keywords field, I don't see why it couldn't be done.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Bucklebery]

Thansk Sue - I have a temp solution that will surfice. Can we use SQL or some
other datatbase to run queries on the outlook database ?

 

[Sue Mosher [MVP-Outlook]]

I'm not sure what you have in mind. Although Outlook does support ADO in a
limited way, it really is very limited and doesn't even cover all the
reasonably interesting fields.