Symptoms

Reports Controls not working
 

Diagnoses

I have created the k2 smartforms report with various controls however at runtime no date is returned.

I have full permissions on the server and full permission on the process. Also, when similar filter is applied to 'Process Overview' on workspace data is returned but custom report returns nothing.

Please find the k2 package and the permission screen shot attached. Please let us know what configuration are we missing causing this behavior.
 

Resolution

The issue is occuring due to the Regional settings of the K2 and SQL Server . For some bizarre reason a DateTime format casting error during the execution of the report is resulting in the Non-Native Execution error we are seeing .

This bug was fixed in 4.6.10 . Unfortunately no cold-fix was created for this . Other than upgrading , the alternative would be to change the regional setting of your K2 server and SQL to US