We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

NULL Value in parameter of type int (Stored Procedure as Data source)

I was experimenting with dashboard designer with sql server 2012 and stored procedure as a datasource. My Stored procedure has some int parameter that accept null values. when I try to send NULL or null in parameter it gave me error "Error converting data type nvarchar to int" if left parameter blank it doesn't gave me any result. but stored procedure gave result when i run it separately 

3 Replies

PR Paul Raj Kumar J Syncfusion Team June 1, 2016 10:54 AM UTC

Hi Muhammad,  
Thank you for using Syncfusion products.    
We have confirmed that the issue “Passing NULL or null in parameter with the stored procedure with the parameter which supports null throws an exception as Error converting data type nvarchar to int" is a defect. The fix for this issue will be available in the upcoming release which is planned by mid of June, 2016.       

MT Muhammad Tassadaque Zia June 26, 2016 10:20 AM UTC

is the said update released ?

PR Paul Raj Kumar J Syncfusion Team June 27, 2016 06:33 AM UTC

Hi Muhammad,       
We would like to inform you that we have a plan to rollout the dashboard platform by this week.   

Live Chat Icon For mobile
Up arrow icon