Hi Listers ~ management has asked me to provide a report listing all products / versions that have not been referenced in Incidents within a specified date range. I've tried creating several outer-joins as follows:
Product and Model/Version outer join (FRB:ProductVersionLookup): Primary - PCT:Product Catalog Secondary - PCT:Product Model/Version Criteria - $Product ID$ = 'Product ID' * Not all products have corresponding version data Product, Model/Version and Incident outer join: Primary - FRB:ProductVersionLookup (1st join) Secondary - HPD:Help Desk Criteria - $Product Name$ = 'Product Name' One of the problems I'm running into is that for many Incidents, the Version information is not provided but since my first join form joins based on product ID, there is no entry for NULL versions so these obviously would not be output in the Crystal Report. Aside from requiring version information, I'm assuming I have to bypass the version information in the report? I've also thought that maybe a Crystal Report on the PCT:Product Catalog form with a sub-report of the Incidents (suppressing those with a count >= 1) would work but I wanted to see if I could squeeze the version information in there as well... Any ideas? Thank you in advance. Windows Server 2003 SQL Server 2005 7.1.00 Patch 002 AR Server, MT, Admin, Client 7.0.03 Patch 006 Service Desk Asset Management Laurie Muhlethaler First Republic Bank Remedy Developer / Administrator 415.364.4436 -------------------------------------------------------------------------- The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. This message cannot be guaranteed to be secure or error-free. First Republic Bank and its related entities do not take responsibility for, or accept time-sensitive instructions sent by email including orders, funds transfer instructions or stop payments on checks. All instructions of this nature must be handled by direct communication, not email. We reserve the right to monitor and review the content of all email communications sent or received. Emails sent to or from this address may be stored in accordance with regulatory requirements. First Republic Bank is a Division of Merrill Lynch Bank & Trust Co., FSB _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
