Hi Sergey,
I don't think so - the year and month in the RV are actually integers and the report is grouped by Turnoverbyworkshop.InvoiceYear.
The data environment is empty and the RV's are opened before the report is called.
As I wrote, it all works fine when run from a prg but something goes wrong when it's run from a form - I just can't figure out what it is.
>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
Peter Pirker
Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?
(Woody Allen)