Grouping
in [Reports]
|
From: srctr on 27 Jan 2010 08:56 I am trying to use the grouping feature. My problem is the header for the two groups shows as a box in both areas, words are only showing in the correct area. How do I get the one group header to show only for that group? Looks like this: blank box Board of Directors BDName1 BDName2 BDetc Participant's Council blank box PCName1 PCName2 PCetc. I am sorting and grouping on Particpant's Council field - Ascending, Group Header = Yes, Group Footer = No, Group on = Each Value, Group Interval = 1, Keep Together = No Board of Directors Field - Ascending, Group Header = Yes, Group Footer = No, Group on = Each Value, Group Interval = 1, Keep Together = No Last Name field - Ascending, Group Header = No, Group Footer = No, Group on = Each Value, Group Interval = 1, Keep Together = No First Name field - Ascending, Group Header = No, Group Footer = No, Group on = Each Value, Group Interval = 1, Keep Together = No I have tried everything, changes settings for everything. I can not figure out why the group header shows in both areas and not just it's own area. Thanks
From: Duane Hookom on 27 Jan 2010 09:38 I expect [Participant Council] and [Board of Directors] are yes/no fields. I don't care much for this structure but you could try an expression in a text box like: =IIf([Participant Council],"Participant's Council",IIf([Board of Directors],"Board of Directors","Just an Ordinary Member")) -- Duane Hookom Microsoft Access MVP "srctr" wrote: > I am trying to use the grouping feature. My problem is the header for the > two groups shows as a box in both areas, words are only showing in the > correct area. How do I get the one group header to show only for that group? > Looks like this: > > blank box > Board of Directors > > BDName1 > BDName2 > BDetc > > Participant's Council > blank box > PCName1 > PCName2 > PCetc. > > I am sorting and grouping on > Particpant's Council field - Ascending, Group Header = Yes, Group Footer = > No, Group on = Each Value, Group Interval = 1, Keep Together = No > Board of Directors Field - Ascending, Group Header = Yes, Group Footer = No, > Group on = Each Value, Group Interval = 1, Keep Together = No > Last Name field - Ascending, Group Header = No, Group Footer = No, Group on > = Each Value, Group Interval = 1, Keep Together = No > First Name field - Ascending, Group Header = No, Group Footer = No, Group on > = Each Value, Group Interval = 1, Keep Together = No > > I have tried everything, changes settings for everything. I can not figure > out why the group header shows in both areas and not just it's own area. > > Thanks >
|
Pages: 1 Prev: How hide value on report if certain criteria exists Next: Report sorting |