Hi guys,

I'm a newbie to crystal reports and would appreciate your help to solve my problem.

I'm using a crystal reports cross tab to access a peachtree database file to generate a weekly sales report following this format for a specified date period jan 1, to jan 7.

customer / item a / item b / item c
cust A   / qty    / qty    / qty
cust b   / qty    / qty    / qty
cust c   / qty    / qty    / qty


I used a cross tab to create the report, added a select expert criteria for the date range to filter the date.

the database is several tables linked as follows:
JrnlRows -> customers (right outer join)
JrnlRows -> LineItem (inner join)
JrnlRows -> JrnlHdr (inner join)

Additional info on the tables are as follows:
JrnlRows -- contains the qty sold
JrnlHdr -- contain the Transaction Date filter

I have also used the following settings:
- report options -> convert null to default
- select expert date range formula -> display null as default

My objective:   I want the report to display all customers regardless if they had + sales during the specified date range or "0" sale -- so our sales team can clearly see which products each customer did not order for that week.

I've tried the following but to no avail:
1) different "from" "to" linking
2) different join combination on the JrnlRow - Customer, and JrnlHdr - JrnlRow
3) formula:   isnull(jrnlHdr.transactionDate) or jrnlHdr.transactionDate > date (2012,01,15)

It seems that the values are not null -- but simply filtered out because of my date range filter.

Would appreciate ideas on how to work around this and solve this problem.

thanks for the quick reply kostya.   

This option is feasible but would end up showing two sales values instead of zeroes.

1) those "in range" - i would see sales values greater than zero
2) those "out of range" - i would still see values greater than zero instead of zeros.

Am still open to ideas.

Finally got it to work.   Thanks for the advice Kostya. Appreciate the help!