Skip to Content
Mar 15, 2014 at 11:09 AM

Multi Value Parameter in SP error in Crystal Report SAP B1 ?


Hi Experts ,

i am Getting an error in Crystal Report

"Failed to retrieve data from the database. Details: 42000:[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '('. [Database vendor code: 120]"

I an executing the SP In Command , I want to pass multi value parameter in SP

When Pressing ok

than On Ok Button Error come

So I have Some Question

1> Why All parameter in Commend Are Automatic getting Compulsory and How to Avoid It?

2> How to Solve this error ? this error is only coming with multivalued parameter ?

i have many report in which i have to send the multi value parameter into query it self so , Plz Help Me

I am New to Crystal Report so it will be Kind Of you if explain with example .

Thankks in Advance !!!


Mayank Shah

Attachments (977 B)
pastedImage_1.png (55.1 kB)
pastedImage_2.png (38.3 kB)
pastedImage_3.png (23.4 kB)