Basic Report Help!

[sch9009]

So putting together a report that shows how often items are ordered in a stock room at a hospital.

Thing is though, if the item hasn't been ordered, crystal doesn't display the item.

I have a table that contains all the information for the stock room (table.itemloc), and then I have a table that contains all ordering info (table.reqline).

When I bring over the reqline fields (i.e. creation date, quantity, etc) it only displays the fields that have matching criteria.

I simnply want to make a report that says "this is a fast moving item" (which I can already show), and "this item hasn't been ordered at all.."

Thanks

[jade1977]

Did you try changing the table join from an Inner Join to either a Left Outter or Right Outter Join?