Hi Sherry,

I have never been a fan of the SET SKIP TO command. To produce your report try:

select clients
set order to client_id && I assume this is the key field in CLIENTS
select transactions
set order to client_id
set relation to client_id into clients

Run your report with TRANSACTIONS as the current alias.

You may also want to look into using a SQL select statement.

SELECT cl.*, tr.* ;
from clients cl ;
inner join transactions tr on tr.client_id = cl.client_id ;
into cursor curReport

Run your report with cuReport as you current alias.

Both methods should get the report done. If your need to specify the order based on the clnet table(like client name) then use the SQL select statment and incorporate the ORDER BY clause.


>Hello All:
> Could someone tell me what am I doing wrong: I am trying to produce a report with two tables -- clients and transactions. The relation is right I browse it but the report is not right. The report prints out each transation on each seperated page. I put all the client info. on the page header area and all the transactions on the detail area. I also created a data grouping on client_id. These are my codes:
> select transactions
> set order to client_id
> select clients
> set relation to client_id into transactions
> SET SKIP TO transactions