cancel
Showing results for 
Search instead for 
Did you mean: 

Issue Regarding Selection Criteria For Query in SAP B1

Former Member
0 Kudos

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?

View Entire Topic
former_member205766
Active Contributor
0 Kudos

Hi

This is possible in Crystal reports with Parameters selection.

Regards

Balaji Sampath