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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

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

Thread ID:





124322 May 31,2016 07:29 PM UTC Jun 27,2016 06:33 AM UTC Dashboard Platform 3
Tags: Dashboard Designer
Muhammad Tassadaque Zia
Asked On May 31, 2016 07:29 PM UTC

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 

Paul Raj Kumar J [Syncfusion]
Replied On 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.       

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

is the said update released ?

Paul Raj Kumar J [Syncfusion]
Replied On 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.   


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon