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 · Accepted solution]

Hi Brij,

Change the Parameter Name in crystal report as

<Parameter name>@SELECT ITMSGRPNAM FROM OITB

For details, go through the following pdf, Page 21-23. You can create multiple values selection.

https://cdn2.hubspot.net/hubfs/38093/ARedesign%202018/PDFs/how-to-work-with-crystal-reports-88.pdf

Regards,

Chella

[Former Member]

hi chellapan.ct

Can you please tell me process to achieve that in crystal repor?

Regards,

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