Hi;
I have a report using crosstab and it works perfectly.
However, I want now to have it display a list of records where total is zero (just like what a left join in SQL do when it displays zero sales for one sales person for a specific product! like in http://www.w3schools.com/sql/sql_join_left.asp)
Is they anyway to do so.
Thanks
I have a report using crosstab and it works perfectly.
However, I want now to have it display a list of records where total is zero (just like what a left join in SQL do when it displays zero sales for one sales person for a specific product! like in http://www.w3schools.com/sql/sql_join_left.asp)
Is they anyway to do so.
Thanks