If I understand correctly, you would need two nested groups:
1. Group by PrompBnkMID
2. Group by PromptID
The details would show the answer options.
Fang Wang (MSFT)
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
[quoted text, click to view] "Roger Twomey" <rogerdev@vnet.on.ca> wrote in message
news:%23KsmcRuXEHA.3716@TK2MSFTNGP10.phx.gbl...
> 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)
>
> PromptBnkMID, PromptBankTitle, PromptID, PromptText, AnswerOptionText
>
> 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.
>
>
>
>
>
