1. Home
  2. Forum
  3. Dashboard Platform
  4. NULL Value in parameter of type int

NULL Value in parameter of type int

Hello everyone,,
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
DG Dhivyabharathi Govindaraj Syncfusion Team February 24, 2020 11:53 AM UTC

Hi Humanjo, 
 
Instead of providing Null or null text in the Parameter window, please select Null option from the combo box for Null values like as below. 
 
 
 
 
We have four type of parameter support for Stored Procedure so please use this type effectively based on your case. 
  1. Default- Default option will enable only if your SP parameter has default values in it.
  2. Custom- Custom parameter is used to manually enter your parameter values for SP.
  3. Null- Null parameter is used for null values alone.
  4. Parameter - It is used for Dashboard parameter support.
 
Please find the below help documentation for more details, 
 
Note: 
Null, Default parameters support are available from our 3.2 version release so we recommend you to use our latest version to overcome your issue. 
 
Kindly get back to us if you need any further assistance from us. 
 
Regards, 
Dhivya 
 
 


HD Humanjo Daro February 27, 2020 05:34 AM UTC

Hello everyone,,
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.https://snaptube.cam/ https://syncnet.onl/telegram-web/ 9apps

Thank you my issue has been solved,...

DG Dhivyabharathi Govindaraj Syncfusion Team February 27, 2020 05:39 AM UTC

Hi Humanjo, 
 
We are glad to hear that your issue has been solved.  
 
Kindly get back to us if you need any further assistance from us. 
 
Thanks, 
Dhivya 


Loader.
Up arrow icon