TABLE FILE DATA_TABLE
PRINT
      CUSTOMER_NAME
      CLIENT_ID
      CLIENT_NAME
WHERE ( '&CUST_ID' EQ CUSTOMER_ID ) AND (CLIENT_ID IN (&CLNT_ID))

WHERE (CUSTOMER_ID, CLIENT_ID) IN ((1, 1), (1, 2), (2, 3))

quote:

Originally posted by Dan Satchell:
If &CUST_ID contains 5 values and &CLNT_ID contains 8 values, how will you know which client IDs go with which customer IDs?

quote:

Originally posted by Ruchika Gusain:
Hi SG,

To support multiple Customer/Clients in the report use 'IN' operator:

WHERE CUSTOMER_ID IN (&CUST_ID) AND CLIENT_ID IN (&CLNT_ID) ;

'AND' operator will display ONLY those rows for which both the Customer ID and Client ID match.


Thanks
WebFOCUS
8.1.04

quote:

Originally posted by Dave:
You could make a new field that combines CUSTOMER_ID and CLIENT_ID and use that.

...but
How will the user enter those ID's anyway?

quote:

Originally posted by S.G:
Hi Dan,

Actually there is a web application page which shows customers list and the clients will be dynamically loading in this page based on the customers selected.

For example: if end users picked customer_1 and customer_2, then client 1 and 2 for customer_1 and client 3 for customer_2 will be shown for selection.

All the selected parameters (customer/client id pair) will be passed when submitting the page to backend and then WebFOCUS report will be triggerred.

quote:

make a new field that combines CUSTOMER_ID and CLIENT_ID and use that

DEFINE FILE CAR
-*	FIRST CHARACTER OF CARNAME + NUMBER OF SEATS
	FAKE_ID/A2 = EDIT(CAR,'9') | EDIT(SEATS,'$$9');
END

TABLE FILE CAR
	SUM SALES
	BY	FAKE_ID
	BY	CAR
	BY	SEATS
WHERE FAKE_ID EQ 'B4' OR 'J5' OR 'A2'
END