1

Topic: Report wizard error - truncated field

Hi

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?

Thanks

Gordon Barker
National Trust

Gordon Barker
Biological Survey Data Manager
National Trust

2

Re: Report wizard error - truncated field

Hi

Change the length in the Report_Field table . This has no adverse effects elsewhere.

Mike Weideli

3

Re: Report wizard error - truncated field

Thanks Mike

that seems to have worked.

Gordon Barker
Biological Survey Data Manager
National Trust