how to find out where DB fields are being used in CR

[c8ltgkue]

Using CR XI
Hi All

We had changes made in the database so we have some old tables which are replaced with new tables. My task is to amend the report which use the old table with the new table and make sure the functionality of those reports don’t change.

To do this, I add the new tables, and replace all reference to the fields in the old tables to the fields in the new table.

My problem is, the fields in the old tables are still being used in the report somewhere because they have a little green tick in front of them in the field explorer. I have checked everywhere, i.e. changed all the formulas, record selection, group selection, record sorting, any sub reports, section expert etc. I can’t find any place where those fields from old tables are being used. Is there a quicker way to do this?

Thanks for your help.

C8

 

[lbass]

You could try exporting to Report Definition and then doing a "find". Also check conditional field formatting formula areas and running totals.

-LB

 

[c8ltgkue]

Thanks for your help but I can't seem to able to export report definition..!