Hi Peter,
It looks like data in runtime is sorted by Month and Year instead of Year and Month. Does it have anything to do with SET DATE?
>Setup: VFP Remote views Workshops & Turnover, data are ok.
>
>In the report, data are grouped by InvoiceYear.
>
>If I open the views and run the report from VFP everything works ok,
>
>Year Month
>2003,1
>2003,2
>...
>2003,12
>--Pagebreak
>2004,1
>a.s.o
>
>but in the app I only get 1 record per month like this:
>
>Year Month
>2003,1
>--Pagebreak
>2004,1
>...
>--Pagebreak
>2003,2
>--Pagebreak
>2004,2
>--Pagebreak
>...
>
>I do have similar reports that all behave as expected so I'm at a total loss here and would appreciate any help.
>
>TIA & BR
--sb--