I am working on a project for the newspaper I work for. We have 2 systems, one for ordering ads and one for what makes the paper and how it's laid out (production system). We have moved production system data into the ordering system in custom tables. So I have tables with our order data and tables with our production data. Great!
Now how do I do an unmatched query where either dates don't match (ie... something was ordered but didn't make the production system) or publications don't match, or ad size doesn't match, or color does not match? Can this be done in Crystal Reports?