This discussion is archived
1 Reply Latest reply: Nov 21, 2012 5:24 AM by BIPuser RSS

Grouping

730727 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points