I have a report which uses 2 levels of grouping, it looks like this:

          Question Group Title

Question
  Answer option
  Answer Option
  Answer option

the groups are by Question Group Title (so that each group has the question group title shown 1x only at the start of the new group) and Question (which then lists the possible answer options).

Currently the page breaks where ever it likes. I would like to be able to force it to break BEFORE the question text of a question, rather than in the middle of the answer options.

Anyone have any idea how to do this?



Sandy Murdock MCP

__________________
Sandy Murdock MCP

I would use 2 reports:
1) Main report which we can call "QuestionList"that consists of a LIST object, with one item in the list: a SUBREPORT object
2) A subreport, which we can call "SingleQuestion" which consists of a TEXTBOX for the actual question, and either a LIST/TABLE whatever for the answers.

reporting services keeps subreports together on one page...

-Bret