on 09-08-2016 1:39 PM
Pessoal bom dia.
Montei uma consulta formatada porem queria deixar como a opção de que: se o usuario selecionar o conteudo do filtro ele execute e tambem se ele não selecionar o conteudo do filtro ela traga geral.
Existe essa possibilidade no gerador de consultas, segue a consulta:
SELECT T0.[DocNum],
T0.[CardName],
T0.[DocDate],
T0.[DocDueDate],
T1.[ItemCode],
T1.[Dscription],
T1.[Quantity],
T1.[Price],
T0.[DocTotal],
T2.[CityS],
T3.[SlpName]
FROM ORDR T0 INNER JOIN RDR1 T1 ON T0.[DocEntry] = T1.[DocEntry] INNER JOIN RDR12 T2 ON T0.[DocEntry] = T2.[DocEntry] INNER JOIN OSLP T3 ON T0.[SlpCode] = T3.[SlpCode]
WHERE T0.[DocDate] >= [%2] AND T0.[Docdate] <= [%3] AND T3.[SlpName] = [%0]
Att.
Bom dia,
pode usar esse where, pelo menos deixe a data pra não forçar o bd.
WHERE T0.[DocDate] BETWEEN [%2] AND [%3] AND (T3.[SlpName] = [%0] or '[%0]' = '')
Abraço,
Fabio
SAP 9.1 PL11
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
104 | |
12 | |
11 | |
6 | |
6 | |
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.