Can not group rows correctly[Answered] RSS

• • Reply
  someguyonaco...

  Member

  47 Points

  81 Posts

  Can not group rows correctly

  Oct 09, 2013 03:56 AM|someguyonacomputer|LINK

  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. 

• • Reply
  yousufctec

  Member

  40 Points

  31 Posts

  Re: Can not group rows correctly

  Oct 09, 2013 04:59 AM|yousufctec|LINK

  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