NULL Value in parameter of type int

[Humanjo Daro]

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.

[Dhivyabharathi Govindaraj]

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, 

https://help.syncfusion.com/dashboard-platform/dashboard-designer/connecting-to-data/connecting-to-stored-procedures 

 

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 

 

 

[Humanjo Daro]

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,...

[Dhivyabharathi Govindaraj]

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