>Hi
>
>Input
>-----
>myur1 = '2012'
>myur2 = '2013'
>
>dt1 = {01/01/&myur1}
>dt2 = {31/12/&myur2}
>mGrp = "CARREFOUR"
>
>OutPut
>------
>Month-wise breakup comparison as follows:
>
>Month---2013---2012--- Change---%age
>------------------------------------------------------
>Jan
>Feb
>Mar
>..
>..
>Dec
>
>Now I have four tables as follows:
>
>1. Group
>2. Simain
>3. Sisub
>4. Pcode
>
>1. ( Group File contain multiple party code relating to the same group )
>pcode c(10)
>cGroup c(52)
>
>2. ( Sales Invoice Master File contains date in which I want to filter records )
>sino c(8)
>pcode c(10)
>invdate d && Filter = From Jan 1, 2012 to Dec 31, 2013
>location c(52)
>
>3. ( Sales Invoice Transaction File contain Quantity and Rate )
>sino c(8)
>icode c(10)
>QntyMaj n(10,3)
>QntyMin n(10,3)
>RateMaj n(10,3)
>Ratemin n(10,3)
>
>4. Customer Master File contains all party information
>pcode c(10)
>full_name c(52)
>
>I am using the following at the moment to get the result
>
>

>Select talias1.sino, talias1.invdate, talias1.pcode, talias1.location ,talias1.zone, talias1.salesman, talias1.merchand, ;
>   talias2.icode, talias2.qntymaj, talias2.qntymin, talias2.ratemaj, talias2.ratemin ;
>   from simain talias1, sisub talias2 ;
>   where talias1.sino = talias2.sino And Between(invdate,dt1,dt2) AND pcode # 'CP011' ;
>   into Cursor sijunk Readwrite 
>

>
>and then
>
>

>Sele Year(invdate) As theyear, ;
>   MONTH(invdate) as themonth,;
>   pcode As pcode, ;
>   sum(qntymaj) As cartons, ;
>   sum(qntymin) As units, ;
>   sum(Iif(ratemin#0,qntymin*ratemin,qntymaj*ratemaj)) As mamount, ;
>   CAST('' As c(52)) As cGroup ;
>   from sijunk ;
>   group By theyear, themonth, pcode ;
>   into Curs tempsi 
>

>
>Then I run do whil ... enddo to get the group name with Group.dbf which is a time consuming job and I want to only CARREFOUR Group Data.
>
>Can I combine all to get the result in one syntax?
>
>Thanks
>
>Saif

You can use case based cross tab pivot. This article is for SQL Server, but it is easy to apply the same idea in VFP as well:
http://social.technet.microsoft.com/wiki/contents/articles/22502.t-sql-how-to-put-grouped-results-on-the-same-line.aspx