It doesn't sound to me like the RECID = GNRECID is the problem. When I've seen it, the msg is because I have tried to set a relation from one table into another when I already have the reverse relation set. And it could be that the relations are a generation or more removed.

When you preview the report from the report designer..you don't have a problem? Does the report use the default data session? Perhaps it should use a private datasession?

>I have a form that the user can press a button to generate a printed output for the current record. I store the current record value and pass it to the report(GNRECID=table1.recid). When trying to run this report from the APP, I get "Cyclic relationship", however when running it from the command window it works fine. My command look like this: Report form reportx to print for RECID=GNRECID (button click). I do use the same Database for both.
>
>I am, planning to move to pviews as soon as I can get things running. For the time being, but I really need this report that has multiple(10) relations to work.