when querying my database, my report will only show the inventory between a time frame sold. How can i get crystal reports to show me the entire category with the amount sold in a time frame? Not just what was sold in that time frame.