locked
Can not group rows correctly RRS feed

  • Question

  • User-321544978 posted

    I am using Visual Studio 2010 to design a report. I am having trouble displaying the data

    I have a dataset of Assessment, Question, Answer, NumberOfResponses.

    Eg.

    • Ass1,q1,a1,3
    • Ass1,q1,a2,8
    • Ass1,q1,a3,5
    • Ass1,q2,a1,6
    • Ass1,q2,a2,7

    I want this displayed in a visual studio report as 

    Assessment

     

     

     

     

    Question

     

     

     

     

    Answer

    NumberOfResponses

     

     

    Answer

    NumberOfResponses

     

     

    Answer

    NumberOfResponses

     

     

    Answer

    NumberOfResponses

    The rendered report (based on the example dataset above) should like this.

    ASSESSMENT

    QUESTION

    ANSWER

    Number of responses

    Ass1

     

     

     

     

    Q1

     

     

     

     

    A1

    3

     

     

    A2

    8

     

     

    A3

    5

     

    Q2

     

     

     

     

    A1

    6

     

     

    A2

    7

    I have tried a number of grouping combinations to achive this but I can not get it to work. 

    At the moment I get Assessment and Question values repeated on every line.

    Can anyone suggest a way to achive the above desired report. 

    Wednesday, October 9, 2013 3:56 AM

Answers

  • User-849598927 posted

    I think you're failed to create groups..

    Create two groups,

    First group for assessment and second group for question..

    the second group must be a child group for first group

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, October 9, 2013 4:59 AM