Skip to Content
0
Jan 20, 2023 at 07:22 AM

Multiple value selection - SAP Crystal Report

157 Views Last edit Jan 27, 2023 at 05:27 PM 2 rev

Hello Guys,

I was trying to make a report in crystal report that a user can select multiple value. The parameter to where im getting the data is from Inventory Transfer DocNum. In database field when I right click the DocNum and click Browse Data its shows all the data entered in Inventory Transfer. Now when I make parameter and Append all database values its shows only few data.

Im selecting the tables by Command Code... please find it below.

SELECT T0."DocNum", T1."Dscription" FROM "TESTSERVER2"."OWTQ" T0 INNER JOIN "TESTSERVER2"."WTQ1" T1 ON T0."DocEntry" = T1."DocEntry"

Question 2: Is there away that i can do Multiple selection from Command Code?

Thanks