How pass one parameter value with multiple value to the other parameter in SAP Crystal report

[former_member718258]

Hello,

this is my parameters:

1. Kibuz@SELECT distinct BPLName FROM OBPL

2.Projct@SELECT distinct U_Z_code,U_Z_name FROM OBPL T0 INNER JOIN [dbo].[@A1GEN_PROJ_SITE] T1 ON T0.BPLId=T1.U_Z_BusinessPlace WHERE (T0. BPLName = '@Kibuz')

This is working if i choose in the first parameter one value, but if i choose "Allow multiple value" the second parameter is not display data.

Any idea?

[DellSC]

Try changing your Where clause to this:

WHERE (T0. BPLName in '@Kibuz')

-Dell