Deleting Unused Fields from a Report

johncnpr

Is there a utility available that can delete unused fields from the underlying query if they are not specifically referenced in the report?

I'm running into a situation where it appears I'm up against a limit to the number of fields I can add. So, I want to locate and delete unused fields in order to make room for new fields.

Thanks,

John

nicocizik

Hi John,

Unfortunately we do not know of any utilities that perform this task. One option would be to save your report to a template file as ASCII text, then perform a search on that file for the field names in your DB table. The field names that are not found could then be removed from your query.

The task above could be made simpler by creating a small Delphi app that perhaps loads the template file into a StringList and searches for each field name automatically compiling a list of unused names.

johncnpr

Nico,

Thanks for the hints. I will give that a try.

John