Render a separate cross tab for each member of a group?

[Phoebe]

I have a cross tab report that I'd like to be able to run for each  member of a department.  Department is selected with a prompt, and of course departments can have different numbers of members.

I'm thinking some sort of grouping would give me the solution, but I can't figure out what to group on.  Maybe something using for or at grouping in an expression-version of the [member] variable?

Thoughts appreciated!

[Phoebe]

I'm getting close by using Page Break/Section By Master Detail, but I'd like them to remain on the same page when the report is run...no "page down" clicking.

[MFGF]

Hi,

Sounds like you need to create a section heading for each group member? Drag the departmemt member item into your crosstab, select it, then press the "Section / Unsection" button on the toolbar (two to the right of the Group button).

Cheers!

MF.

[Phoebe]

You're right.  I tried that earlier and it didn't work...that was because I had some page grouping leftover from when I tried master/detail page breaks.

Thanks for the nudge back in the right direction.

[MFGF]

Glad you got it working! :)

MF.