Hello!
im building a normal report but it references data from more than one table. so i used a view with 2 tables and the SQL on the view is

 FROM ;
     mainbase!recoveries ;
    INNER JOIN mainbase!cactions ;
   ON  Recoveries.recovercode = Cactions.code;
 WHERE  Recoveries.recovercode = ( 1 )

now this works very fine...i get my records.
so i have this Query

SELECT *;
 FROM ;
     v_recoveries V_recoveries;
 WHERE  V_recoveries.recovercode = ( 1 );
 INTO TABLE r  

now in my Report i had the code (on initialize)

DO qry_recoveries.qpr
SELECT R

Now when i do that the first peron gets repeated Three times. :(
but when i use the Native table...with no views..in the DE of the Report it works fine :(
any reason why i cant use my view?