Issues with Column group by

• John Paul-702936

  SSCrazy

  Points: 2182

  More actions

  November 5, 2014 at 12:42 pm

  #397611

  Hello Guys ,

  Please help me or tell me can we implement or no t.

  here is the Data Set for reference .

  INSERT INTO [temp] Values ('name1','1','2','type1')

  INSERT INTO [temp] Values ('name1','2','2','type1')

  INSERT INTO [temp] Values ('name2','1','2','type1')

  INSERT INTO [temp] Values ('name3','1','2','type2')

  INSERT INTO [temp] Values ('name3','2','2','type2')

  INSERT INTO [temp] Values ('name4','1','2','type2')

  INSERT INTO [temp] Values ('name5','1','2','type3')

  INSERT INTO [temp] Values ('name5','2','2','type3')

  So I used tale and group by Type and name - details Sum of Val1 & val2

  my report looks like something like this :

  Report :

  TYPE Name Val1 Val2

  Type1 Name1 3 4

  Name2 1 2

  Type2 name3 3 4

  name4 1 2

  Type3 name5 3 4

  But we have requirement that Report Should be Displayed like :

  Type1

  Name1 3 4

  Name2 1 2

  Type2

  name3 3 4

  name4 1 2

  Type3

  name5 3 4

  basically , group by Type and Group by name

  Suma of Val2 & val2

  The Sum of Val1 & val2 should br group by if they belong to same name - named that belongs to same type need to be displayed together

  Please help me I was trying to this from last 2 days - with iout any success

  any ideas will be rally appreciated

• pietlinden

  SSC Guru

  Points: 63506

  More actions

  November 5, 2014 at 3:29 pm

  #1756832

  Did you add a parent row group on Itemname?