I am trying to build a report with grouping and I am not having success.

I use a stored procedure to return these fields:

PromptBnkMID (UniqueID of a group of questions)
PromptBankTitle (Title of a group of questions)
PromptID (UniqueID of a question or prompt)
PromptText (The question)
AnswerOptionText (The possible Answers)

I am trying to build a report to show the Prompt Bank (question group), the questions in the group, the possible answers.

It should look something like this:

            Prompt Bank Text
Question 1 Text
    Answer Option 1
    Answer Option 2
    Answer Option 3

Question 2 Text
    Answer Option 1
    Answer Option 2
    Answer Option 3

            Prompt Bank Text (next bank)
Question 3 Text...

I have been able to get the report to group by the Prompt Bank (Question group) and put the new Prompt Bank Text at the start of each new group.

It then shows each question either like this:

Question 1 Text

Question 2 Text

Question 3 Text

etc. etc. If I don't add the field for the answer options I can get each question 1 x.

OR

Question 1 Text
   Answer Option 1
Question 1 Text
   Answer Option 2
Question 1 Text
   Answer Option 3

etc.

This second is still properly grouped by Prompt Bank.

I cannot figure out how to show the Question Text once, then one new row for each answer option. There aren't very many settings in the Group screen but I cannot figure this out.



Sandy Murdock MCP

__________________
Sandy Murdock MCP