cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
youlearn
Nintex Newbie

SQL Query in the Form

I have an SQl query on a form to display total from a table using a procedure.  Iam using Label as Display Format. I am able to display correct number when there is data but when there is no data in the SQL table it displays nothing on the form. 

I want it to show 0. When I test the query using Run Now in the designer it does show 0 ,, I am not sure why it cannot display the same 0 on the form. 

In the pic you can see "Year 1 count" is a column in my list 

"Total_Count" is the output column in the database. I am not sure if I selected all this right

Any ideas please. 

Capture1.PNG

Labels: (1)
0 Kudos
Reply