Hi all!
I want to create a Matrix report from the following datamodel
1. Customers table
2.Products table
3. Customers2Products
In matrix Cells I want to display "YES" if the customer has bought a product and "NO" otherwise.
It works perfectly for YES case but for No case it doesn't appear anything because obviously it doesnt find rows in customer2products table ...
How can I avoid it?
function CF_YESFormula return Char is
begin
if PRODUCT_QUANTITY > 0) then
return('YES');
else
return('NO');
end if;
exception
when others then
return('NO');
end;
Thanks a lot!
F.
I want to create a Matrix report from the following datamodel
1. Customers table
2.Products table
3. Customers2Products
In matrix Cells I want to display "YES" if the customer has bought a product and "NO" otherwise.
It works perfectly for YES case but for No case it doesn't appear anything because obviously it doesnt find rows in customer2products table ...
How can I avoid it?
function CF_YESFormula return Char is
begin
if PRODUCT_QUANTITY > 0) then
return('YES');
else
return('NO');
end if;
exception
when others then
return('NO');
end;
Thanks a lot!
F.