Multiple value selection - SAP Crystal Report

[raghavendra_hullur]

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

[raghavendra_hullur]

Hi,

Is it that you are trying to create a parameter which can accept multiple values to filter the report data?

From what you mentioned, it seems like you are using a command code to get the values for parameter.

To allow the multiple values to be selected for filtering data, you need to set the option to "true" for "Allow Multiple Values" option under "value Options" section when you create/edit parameter.

Once you are done with this, you can include report level logic to handle the filtering the data under "Report ->> Selection Formulas".

Hope that helps.

Thanks,

Raghavendra

[former_member351438]

Hello Raghavendra Hullur.

Multiple values are selected. Still the value i was able to see is very few.

[DellSC]

Are you getting the parameter values from a command, getting the data for your report using a command, or both?

Is the problem that you don't see all possible values for the parameter or that the report is not filtering correctly using a multi-select parameter?

-Dell

[former_member351438]

I try both but the Document numbers are not there.

Thianks

[former_member351438]

Hell Guys,

Just an update. I check the Multiple selection. parameter work in Crystal report by typing the number. But in SAP data's are not there.

Im not pro in cyrstal report but had done this in may previous employer.

What i want to do is to print multiple inventory transfer request in one sheet of paper.

Thanks

[raghavendra_hullur]

Hi,

From the screenshot you shared, it seems like you are not using an additional command to pull the data for using it for filtering purpose.

If you want to use multiple values to filter the report data, First you need to include all those possible values under the highlighted part as shown in yellow below.

Once you have those values, you can modify your command object to include the logic for filtering for the selected values or you can use those values at report level under record selection if you are not using the command object.

Thanks,

Raghavendra

[former_member351438]

Hello Raghavendra

Actually when I select append all the database value, it only shows few and not all.

[raghavendra_hullur]

Hi,

Can you provide more info on where you are trying to append the parameter values?

If you want to display the parameter values you have selected in report as part of selection criteria values, you need to create a formula mentioned as in below steps.

1. Create a formula (say myFormula)

2. Assuming Param as your multi value parameter, you can use below line in formula to join all those selected parameter values and display at report level.

3. join(<Param field in your report>, ", ")

4. Drag and drop the newly created formula to wherever you want to display the selected multiple values of the parameter to be displayed.

Hope that is what you are looking for!!

Thanks,

Raghavendra

[former_member351438]

Hello raghavendra.hullur,

I have attached here the screenshot of the crystal report settings and what it is look liked in SAP.

on the crystal report the Values I want to see are available but in SAP those values are not available.

Thanks

[raghavendra_hullur]

Hi,

Not sure about displaying the selected values in HANA as I haven't worked much on SAP HANA.

May be Dell or someone with exposure to SAP HANA can confirm on that.

You can try the steps mentioned in my post above to ensure you are getting all the values atleast getting displayed in Crystal reports itself by crating an additional formula and displaying the values at Crystal Report itself.

Thanks,

Raghavendra

[DonWilliams]

Change your parameter to Allow Multiple Values.