drop down parameter in query with multiple selection

[#1]

Dear All,

I need in query to get item group name and warehouse name with multiple selection in both drop down list.

is it possible to get this. here below is my query

SELECT T0.[ItemCode], T0.[ItemName], T2.[ItmsGrpNam], T1.[WhsCode], T1.[OnHand], Avg(T0.[LastPurPrc] ) as "Avg Price", T1.[OnHand]* Avg(T0.[LastPurPrc] ) as "Total Value", T0.[SuppCatNum] as "Internal No." FROM OITM T0 INNER JOIN OITW T1 ON T0.[ItemCode] = T1.[ItemCode] INNER JOIN OITB T2 ON T0.[ItmsGrpCod] = T2.[ItmsGrpCod] where T2.[ItmsGrpNam]=N'[%0]' and T1.[WhsCode]=N'[%1]' group by T0.[ItemCode], T0.[ItemName], T2.[ItmsGrpNam], T1.[WhsCode], T1.[OnHand], T0.[SuppCatNum]

Thanks

Brij

[Former Member]

Hi Brij Pratap,

For Multiple values Selection, use Crystal reports instead of Query Generator.

There is option of selecting Multiple values.

Regards,

Chella