Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SAP BW BEx Query based Crystal Reports Prompt doesn't allow copy and paste multiple values in Selection screen

Hi Gurus,

Database Connection: SAP BW BEx query.

Crystal Reports 2013

I have created a Parameter field with multiple values on Customer Number from BEx query in Crystal Reports 2013, which should allow multiple single values like 1111, 1112, 1113..

We have customers more than 1000000 (10 Lakhs) which is not possible to show for selection.

@Abhilash Kumar

So, Users want to copy random Customer Numbers/values from Excel or Text file paste into Customer Parameter selection.

For that i have done Selection Formula Record like this {ZFC_M01_QR_ZFC_M01_007.[0BPARTNER]-[20BPARTNER]} in {?Business Partner}

which is working by enter Customer numbers in prompt one by one and not work with copy and paste bunch of customer numbers with delimiter from excel or text file. Any Solution or Work Around?

Your inputs are highly appreciated.

Thank you,

Warm Regards,

Subani Shaik

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question