当前位置: 动力学知识库 > 问答 > 编程问答 >

c# - The Telerik reporting preview tab displays no data with a valid query - why?

问题描述:

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)

分享给朋友:
您可能感兴趣的文章:
随机阅读: