Telerik report data displays properly in Visual Studio 2015 design mode until I add a parameter and filter. The preview tab now shows the report labels but no data. I've followed the steps outlined here.
1) I added this where clause to the sqlDataSource SelectCommand:
WHERE (TSOPId = @TSOPId)
2) I added a sqlDataSource parameter to match the where clause:
DbType: Int32, Name: @TSOPId, Value: =Fields.TSOPId
3) The report points to the correct sqlDataSource and the ReportParameter is:
Name: TSOPId, Text: TSOP ID, Type: Integer, Value: 67, Visible: True
4) The report filter is
Expression: = Fields.TSOPId, Operator: =, Value: = Parameters.TSOPId.Value
What could be causing the report to be blank (empty)? How can I troubleshoot this problem?
Edit: My report now shows data so the problem is solved. I fixed it (I believe) by adding to step 3)
ProviderName: System.Data.SqlClient It's odd that now when I remove that entry and leave ProviderName blank it still works. Also odd is the fact that ProviderName cannot be filled in using the Configure SQL Data Source Wizard.
Note: I recently upgraded my Telerik controls (and this new version may have a bug). I'm using version R2 2016 SP1 (10.1.16.615)