Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Matrix Report Problem

Status
Not open for further replies.

fragolita

Programmer
Aug 22, 2006
11
IT
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top