Skip to Content
Former Member
Apr 26, 2015 at 10:06 AM

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