Roy,

Please review message #1257587 and this thread.

>Hi
>
>the following table:
>
>

>
>Salesperson   Store       City         Amt1        Amt2        Amt3 
>---------------------------------------------------------------------------------------
>Mark             AAAA     Miami           50          120           10
>Mark             AABB     Orlando         70           60           80
>Sally            BBBB     Tampa          110           30           50
>Sally            CCCC     Toledo          40           25           10
>Sally            DDDD     Chicago         15           35           55
>
>

>
>I need to create a report ordered by salesperson and should Display like this on report:
>
>

>--------
>Mark
>--------
>Column1  Column2  Column3 .... Column10
>-------------------------------------------------------------------------------
>AAAA     AABB     
>Miami     Orlando     
>50           70         
>120          60          
>10           80          
>
>
>--------
>Sally
>--------
>Column1  Column2  Column3 .... Column10
>-------------------------------------------------------------------------------
>BBBB     CCCC      DDDD
>Tampa    Toledo    Chicago
>110        40         15
>30         25         35
>50         10         55
>
>

>Could be up to 10 columns at most. I remember I did this a while back, but I can't find the code and want to know the best way to accomplish this.
>
>Thanks for the help!.