Topic: Report wizard error - truncated field
I have a report in the wizard that fails for one subset of the database with an error that indicates that that data will be truncated. As far as I can tell thi happens when the FIELD_SIZE attribute in the REPORT_FIELD is shorter than the length of the data held elsewhere. A process of elimination points to the Consolidated Recorders field which has a length of 100 (compared to 8000 for Sample_Recorders). Does it sound like this is the problem and if so would it be safe to change the attribute value in management studio? If not, any suggestions?
Biological Survey Data Manager