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!
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.
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.
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.
Glad you got it working! :)
MF.