Too many fields on report?

[jjwild]

We had a report with about 195 fields passed to it in the recordset. We needed to add some fields and did so. We can design the report, but when the report is run, many of these new fields do not show up. The running report looks as if the field was never added to it.

We can add fields to the report that are based on the fields that were already in the recordset. So we are not running into a problem with a maximum number of fields in the report sections. And we have verified the database (multiple times).

The problem just seems to be the amount of data or size of the data in the recordset.

Any ideas?

 

[jjwild]

We found the problem. The values were Null in the database. This caused the field for the value to not display at all on the report.