RPG embedded SQL GROUP BY with cursor

My intention is to list transaction rows in order by item and then by date, totaled by day. I would like to use a cursor. Every variation I can think of fails. Here is where I am at:

exec sql declare C1 cursor for // for Days
select *
from FILEA
where ITEM = :wsqlITEM
group by ITEM, DATE
order by ITEM, DATE;

Without the "group by" it works. The result is a tad too many pages, but it works.