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?