Empty report form

[Clifford Lane]

I have a report that based on a very complex dataset.  If I run the select statement in the SQL manager on the hosting site I get the details needed to fill the report (which is working on my development machine also).

The report name is TSFinalPrint.vb and the vb code looks like this:

 

Try

 

 

Me.TSfinalprintDataSetTableAdapter1.Fill(Me.TSfinalprintDataSet.TSfinalprintDataSetTable)

 

 

Catch ex As System.Exception

 

 

'An error has occurred while filling the data set. Please check the exception for more information.

 

System.Diagnostics.Debug.WriteLine(ex.Message)

 

End Try

The TSfinalprintDataSet.xsd
shows the connection as TSfinalconnection(Mysettings) with the correct values (other features are using the same connection string and are working),  It shows the adapter as TSfinalprintDataSetTableAdapter and the dataset table as TSFinalprintDataSetTable.  Note that in the TSFinalPrint.vb InitializeComponent section it lists TSfinalprintDataSetTableAdapter1.  Is this correct?

The Web application runs fine and displays the report in the viewer but the form is empty.

I have gone over many of the videos and documentation and am not able to resolve this problem. 

If anyone can offer some assistance I would be thankful.

Cliff

 

[Svetoslav]

Hi Clifford Lane,

The given code snippet looks correct (actually this is the automatically generated code that the report designer produces when a typed data set is attached to a report). The TSfinalprintDataSetTableAdapter1 is correct as well - this is the name of the field of type TSfinalprintDataSetTableAdapter that is part of your typed data set.

If I understood correctly your question, you have problems deploying your reports on the production server while these reports work correctly on you development machine. If this is the case I would suggest checking all differences between the two environments and especially the connections strings in the web.config.

For additional information on how to use connection strings from a config file please see this KB article.

 
Regards,
Svetoslav
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Clifford Lane]

Thanks.  That solved the problem!!