SQL Code - C:\Users\ken\Documents\Test Cases\en\Samples

Main Body

SELECT
        Customer.[Customer ID]
        ,Customer.[Customer Name]
        ,Orders.[Order ID]
        ,Orders.[Order Amount]
        ,Orders.[Customer ID]
        ,Orders.[Order Date]
        ,Orders.[Required Date]
        ,Orders.[Ship Date]
        ,Orders.[Order ID]
FROM
        Customer
                INNER JOIN Orders ON Customer.[Customer ID] = Orders.[Customer ID]

WHERE
        Customer.[Customer Name] in {?Customers} and Orders.[Order Date]>= date(2004,01,01) and Orders.[Order Date]<= date(2004,12,31)
ORDER BY
        [@Group 1] ASC -- Group #1
        ,Customer.[Customer Name] ASC -- Group #2
        ,Orders.[Order ID] ASC

Late Orders by Product Type.rpt

SELECT
        Customer.[Customer ID]
        ,Orders.[Order ID]
        ,Orders.[Customer ID]
        ,Orders_Detail.[Order ID]
        ,Product.[Product ID]
        ,Product.[Product Type ID]
        ,Product.[Product Class]
        ,Product.[Supplier ID]
        ,Product_Type.[Product Type Name]
        ,Supplier.[Supplier ID]
FROM
        Customer
                INNER JOIN Orders ON Customer.[Customer ID] = Orders.[Customer ID]
                INNER JOIN [Orders Detail] Orders_Detail ON Orders.[Order ID] = Orders_Detail.[Order ID]
                INNER JOIN Product ON Orders_Detail.[Product ID] = Product.[Product ID]
                INNER JOIN [Product Type] Product_Type ON Product.[Product Type ID] = Product_Type.[Product Type ID]
                INNER JOIN Supplier ON Product.[Supplier ID] = Supplier.[Supplier ID]

WHERE
        instr({?Pm-@Late Orders Running Total}, "^" + totext(Orders_Detail.[Order ID],0,"") + "^") > 0
ORDER BY
        Count(Orders_Detail.[Order ID],[@Group 1]) DESC
        ,Orders_Detail.[Order ID] ASC

Late Orders by Shipper.rpt

SELECT
        Customer.[Customer ID]
        ,Orders.[Order ID]
        ,Orders.[Customer ID]
        ,Orders.[Ship Via]
        ,Orders_Detail.[Order ID]
        ,Product.[Product ID]
        ,Product.[Product Type ID]
        ,Product.[Supplier ID]
        ,Supplier.[Supplier ID]
FROM
        Customer
                INNER JOIN Orders ON Customer.[Customer ID] = Orders.[Customer ID]
                INNER JOIN [Orders Detail] Orders_Detail ON Orders.[Order ID] = Orders_Detail.[Order ID]
                INNER JOIN Product ON Orders_Detail.[Product ID] = Product.[Product ID]
                INNER JOIN [Product Type] Product_Type ON Product.[Product Type ID] = Product_Type.[Product Type ID]
                INNER JOIN Supplier ON Product.[Supplier ID] = Supplier.[Supplier ID]

Late Orders by Supplier.rpt

SELECT
        Customer.[Customer ID]
        ,Orders.[Order ID]
        ,Orders.[Customer ID]
        ,Orders_Detail.[Order ID]
        ,Product.[Product ID]
        ,Product.[Product Type ID]
        ,Product.[Supplier ID]
        ,Supplier.[Supplier ID]
        ,Supplier.[Supplier Name]
FROM
        Customer
                INNER JOIN Orders ON Customer.[Customer ID] = Orders.[Customer ID]
                INNER JOIN [Orders Detail] Orders_Detail ON Orders.[Order ID] = Orders_Detail.[Order ID]
                INNER JOIN Product ON Orders_Detail.[Product ID] = Product.[Product ID]
                INNER JOIN [Product Type] Product_Type ON Product.[Product Type ID] = Product_Type.[Product Type ID]
                INNER JOIN Supplier ON Product.[Supplier ID] = Supplier.[Supplier ID]