Hi all,
I am having a problem when I feed my Report Viewer using a DataSet
.
I have a DataTable
that is filling in some text boxes in my Microsoft Report Viewer.
Some fields are null.
When I execute the program, most of the fields are filled but some doesn't appear.
When I check the Output this what I get:
Warning: The data set ‘DataSet2_DataTable1’ contains a definition for the Field ‘invoice_date’. This field is missing from the returned result set from the data source. (rsMissingFieldInDataSet)
Warning: The data set ‘DataSet2_DataTable1’ contains a definition for the Field ‘invoice_date’. The data extension returned an error during reading the field. There is no data for the field at position 9. (rsErrorReadingDataSetField)
Warning: The data set ‘DataSet2_DataTable1’ contains a definition for the Field ‘payment_location_detail’. This field is missing from the returned result set from the data source. (rsMissingFieldInDataSet)
Warning: The data set ‘DataSet2_DataTable1’ contains a definition for the Field ‘payment_location_detail’. The data extension returned an error during reading the field. There is no data for the field at position 13. (rsErrorReadingDataSetField)
Warning: The data set ‘DataSet2_DataTable1’ contains a definition for the Field ‘comp_address’. This field is missing from the returned result set from the data source. (rsMissingFieldInDataSet)
Warning: The data set ‘DataSet2_DataTable1’ contains a definition for the Field ‘comp_address’. The data extension returned an error during reading the field. There is no data for the field at position 14. (rsErrorReadingDataSetField)
Warning: The data set ‘DataSet2_DataTable1’ contains a definition for the Field ‘company_name_generator’. This field is missing from the returned result set from the data source. (rsMissingFieldInDataSet)
Warning: The data set ‘DataSet2_DataTable1’ contains a definition for the Field ‘company_name_generator’. The data extension returned an error during reading the field. There is no data for the field at position 15. (rsErrorReadingDataSetField)
Warning: The data set ‘DataSet2_DataTable1’ contains a definition for the Field ‘company_address_generator’. This field is missing from the returned result set from the data source. (rsMissingFieldInDataSet)
Warning: The data set ‘DataSet2_DataTable1’ contains a definition for the Field ‘company_address_generator’. The data extension returned an error during reading the field. There is no data for the field at position 16. (rsErrorReadingDataSetField)
Warning: The Value expression for the textbox ‘company_name_generator’ contains an error: Object reference not set to an instance of an object. (rsRuntimeErrorInExpression)
The thread 0x176c has exited with code 0 (0x0).
The thread 0x44c has exited with code 0 (0x0).
The thread 0x1408 has exited with code 0 (0x0).
The thread 0x450 has exited with code 0 (0x0).
I checked my code and it is returning those fields. Only 2 columns of this 1 row are null - (but they are null because they are supposed to be null, not because they are not being retrieved).
In resume, all the fields are being retrieved but not all are being displayed in my Report.
Maybe I have to update the dataset, some refresh, I don't know... if yes, how can I do it? Is there any button to do it?
Can you help me to solve it?
Thanks in advance!