problem on crystal reports parameter selection

[Former Member]

Dear All

i'm facing a problem regarding parameters selection while running my report

when i select more than one value and moved them to the selected values i got only the data of the first parameter

i don't know what happens

anyone help ??

[Former Member]

Hi Ayman,

In Parameter field select allow mutiple value ture.

Thanks & Regards

Darshita

[Former Member]

it's already selected

[Former Member]

Hi Ayman,

If you build that report based SAP ECC then it is known issues. An ADAP is also created for this problem.

you can try the below work around...

The following workaround only works in some situation.

1)Check the Technical Description of the Field in the InfoSet and enter the parameter values in that format.

For example if the Technical Description of the Field in the InfoSet is: Type: C Output length: 018 Then the expected format will be 000000000000000023 rather than 23 for the parameter So instead of entering 23, 43, 59 enter: 000000000000000023 000000000000000043 000000000000000059

2) To check the Technical Description of the Field in the InfoSet: Start Transaction SQ02 to Manage InfoSets Select the InfoSet and click on the button “Display” In the Field Group/data fields pane double-click the Field in question to select it Click the Additional field information button 

(Highlighted in below) Note: Ensure that after applying the product update, that you load on the SAP System, the SAP Integration Kit Transports found in the product update. This is very important, as the code correction is in the functions loaded by the SAP Integration Kit Transports to the SAP System.

Thanks & regards,

Naga.

[abhilash_kumar]

Hi Ayman,

Do you mean the report only brings back data for the 1st selected value?

Try changing the record selection formula to:

{database_field} IN {?parameter_name}

OR, do you mean to say that the parameter field that you've dragged onto one of the Report sections only shows the 1st selected value? If that's the situation, then create this formula and drop it on a section:

Join({?Parameter_Name}, ", ")

Hope this helps.

-Abhilash

[Former Member]

Dear Abhilash

please note that the report is build on sap query and the parameter is the sap query parameter

yes i mean the report only brings back data for the 1st selected value , i tried your solution

and nothing changes

Regards

[abhilash_kumar]

Did you try the same query in the BEx Analyzer?

Also, what version of CR are you using? Have you uploaded the right Transports to the SAP system?

P.S: Since this is a BEx variable, you don't need the Record Selection formula. the should receive filtered results from SAP.

-Abhilash

[Former Member]

i use CR 2011 , it's not abex query it's an infoset query

[Former Member]

Hi Ayman,

Yes, the issue will occur with infoset query in crystal parameters. There is a KBA based on this issue....

The below is the KBA Article for that issue and the work around is i specified in my previous post...

1597350 - Crystal Report from an ECC Infoset does not return all values

The following workaround only works in some situation.

1)Check the Technical Description of the Field in the InfoSet and enter the parameter values in that format.

For example if the Technical Description of the Field in the InfoSet is: Type: C Output length: 018 Then the expected format will be 000000000000000023 rather than 23 for the parameter So instead of entering 23, 43, 59 enter: 000000000000000023 000000000000000043 000000000000000059

2) To check the Technical Description of the Field in the InfoSet: Start Transaction SQ02 to Manage InfoSets Select the InfoSet and click on the button “Display” In the Field Group/data fields pane double-click the Field in question to select it Click the Additional field information button 

(Highlighted in below) Note: Ensure that after applying the product update, that you load on the SAP System, the SAP Integration Kit Transports found in the product update. This is very important, as the code correction is in the functions loaded by the SAP Integration Kit Transports to the SAP System.

Thanks & regards,

Naga.