How to display information with no data attached

[Kryste]

I am trying to set up a sales report, we have many classes that our products fall into. I want to show all the classes in my report whether or not the customer ordered anything from that class of product. How do I do this?

 

[Roadkill150]

You would need some record that would relate to all class types for the information to display. It doesn't necessarily have to be customer related.. If you have the class and customer in different tables, an outer join should also work in getting the classes to display.
-Bruce Seagate Certified RCAD Specialist.
-Bruce Thuel-Chassaigne
roadkill150@hotmail.com

 

[Ngolem]

you could make the report display in the footer rather than in the detail section...set all class value variables to zero in an initialization formula...in the detail section update the individula class values...then display them in the footer for the customer....suppressing all other sections

hope this helps
Jim

JimBroadbent@Hotmail.com