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'