>For group lcl_doc_nm , if you check Start new group on a new page , and Reset page no to 1 for each group should do what you want to do. If not you have something else going on.
>
Elmer:
The Reset page is check, but when this is checked, the Start new group on new page is disabled. If I deselect Reset, then the Start new group is enabled.
Heres the code that gets the data:
select hlth_card,pat_name,;
diag_code,date_serv,premium,;
bill_date,lcl_doc_nm,lcl_docnam, Invoice_no ;
from Services;
into cursor unpaids nofilter ;
where services.paid <> "YES" .AND. ;
services.CloseClaim <> "YES";
order by lcl_doc_nm,claim_no, Invoice_no
- Ravi
True greatness consists in being great in little things.
- Charles Simmons