on 05-17-2013 8:49 PM
Hola expertos!
Tengo el siguiente query y quiero que tenga los totales en el campo "COMISION" en el pie de la pagina pero no logre que no me de error.
SELECT T1.[DocDate], T1.[DocNum], T1.[CardName], T0.[ItemCode],
T0.[Quantity],T0.[LineTotal], ((T4.[U_Comision]/100)* T0.[LineTotal]) as '% Por Pago', T0.[Commission] ,
(case when ((T4.[U_Comision]/100)* T0.[LineTotal]) is null then ((T0.[Commission]/100)* T0.[LineTotal]) else (((T0.[Commission]/100)*T0.[LineTotal])-((T4.[U_Comision]/100)* T0.[LineTotal])) end) as 'Comision'
FROM INV1 T0 INNER JOIN OINV T1 ON T0.DocEntry = T1.DocEntry
FULL OUTER JOIN ORCT T2 ON T1.ReceiptNum = T2.DocEntry
FULL OUTER JOIN RCT3 T3 ON T2.DocEntry = T3.DocNum
FULL OUTER JOIN [@DMT_COMISIONES_TD] T4 ON T3.[CreditCard] = T4.[Code]
Where T1.[DocDate] >= [%0] AND T1.[DocDate] <= [%1] AND T0.[slpcode] = [%2]
David:
No entiendo cuando dices que no lograste que no te de error.
Si no te da error asumo que es correcto.
Por otro lado cuando haces una query en el query manager, la única manera que te de el total es posicionándote en el campo y control+clic en la cabecera del campo.
Si tu deseas es que te aparezca otra línea la manera es con Crystal report
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hola Fernando!
No conocía esta función del SB1, Gracias seguro que resuelve mi problema.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.