Issue Regarding Selection Criteria For Query in SAP B1

[Former Member]

Dear  Friends,

We use below query for customer wise sale details

Select T0.DocNum,T0.DocDate ,T0.CardCode,T0.CardName,T0.U_GIL_Buyer,T0.U_GIL_BuyerName,T0.DocTotal  

From OINV T0

Where T0.DocDate>=[%0] And T0.DocDate<=[%1] AND T0.CardName=[%2]

But when we trying to select CardName in that selection system will shows only list of CardNames.

is it possible to show the CardCode along with CardName in another column when we are going to select CardName?

[former_member205766 · Accepted solution]

Hi

This is possible in Crystal reports with Parameters selection.

Regards

Balaji Sampath

[kothandaraman_nagarajan]

Hi,

Please check reply time to assign marks. Further, you have asked whether is it possible or not in query.

Thanks & Regards,

Nagarajan

[kothandaraman_nagarajan]

Hi,

It is not possible show card code and name as per above attachment.

You have to select as separate variable.

Thanks & Regards,

Nagarajan