1 Reply Latest reply: Nov 21, 2012 7:24 AM by BIPuser RSS

    Grouping

    Imtiaz
      Hi Everyone,

      I have a small doubt. Currently my report is in the following format.

      Name........ID............SubID..........SubName................SubAddress..................Date...................ST No..............Tax.........................Total

      001..........001..........111003........Ravi.......................JAIGIRHAT ROAD...........1/1/1970............1.2603..............124.68...................766.05

      001..........001..........111003........Ravi.......................JAIGIRHAT ROAD...........10/10/1980.........2.7603..............184.68..................813.05

      001..........001..........111002........Saurav...................SREEGURU COLONY.........1/1/1970............1.2603..............124.68..................766.05




      Is there any possibility that we can have the first three or four columns grouped. Below is the new required format.

      Name........ID............SubID..........SubName................SubAddress..................Date...................ST No..............Tax.........................Total

      .............................................................................JAIGIRHAT ROAD...........1/1/1970............1.2603..............124.68...................766.05

      001..........001..........111003........Ravi.................................................................................................................................................

      .............................................................................JAIGIRHAT ROAD...........10/10/1980.........2.7603..............184.68..................813.05


      001..........001..........111002........Saurav...................SREEGURU COLONY.........1/1/1970............1.2603..............124.68..................766.05



      I have two for each loops in the template and I tried with grouping in the following way.

      The outer loop has:

      <?for-each-group:ROW;NAME,ID,SUB_ID,SUB_NAME?>

      The inner loop in the table has:

      <?for-each:current-group()?>

      I hope you understand the requirement. Can you plz help me out with this. ( Sorry for the format I have presented here as am not able to paste a table :) )

      Thanks in advance,
      Imtiaz.

      Edited by: Imtiaz on Nov 20, 2012 10:01 PM

      Edited by: Imtiaz on Nov 20, 2012 10:12 PM