Skip to Content
0
Former Member
Apr 21, 2010 at 10:05 PM

Drill Down Arrow

26 Views

I've got a query written that works just fine but the drill down arrows aren't appearing next to the document number. I'm trying to figure out why they aren't and if it is possible to make them appear.

SELECT
 T0.DocNum AS 'Invoice Num',
 T1.SlpName AS 'Sales Employee',
 T0.CANCELED AS 'Cancelled',
 T0.DocStatus AS 'Status',
 T0.DocDate AS 'Posting Date',
 T0.DocDueDate AS 'Due Date',
 T0.CardCode AS 'Customer Num',
 T0.CardName AS 'Customer Name',
 T0.DocTotal AS 'Document Total',
 T0.U_SES_CommPaidYet AS 'Commission Paid',
 T0.U_SES_InvoicePaidOn AS 'Invoice Paid On'

FROM OINV T0

INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode

WHERE T1.SlpName = [%0] AND T0.U_SES_CommPaidYet = 'N' AND T0.CANCELED = 'N'