Skip to Content
author's profile photo Former Member
Former Member

How to find fields in a report

Hi,

A client has customized reports that they need to manually update as there were changes to the database tables. A field that was under table A is now under table B.

When using the Verify Database function, the new table (B) that has been added to the report doesn't appear so you can't map to the new location of the field.

We tried doing a search in the Report Definition document but the results of this export is not 100%; either you don't find the field or not all the locations of it.

Is there a way to find out all the places a field is used or a(nother) field mapping feature that would include the new tables?

Thank you,

Heather

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 29, 2008 at 08:31 PM

    You don't mention the version of Crystal Reports XI-R2 or CR2008 (R3) simply open the Field Explorer, find the field with a checkmark to its left (meaning it's used) and right-click on it.

    Choose Find in Formulas

    If you can't find it in the report definition you should be able to find it this way....

    You also may have to do it more than once if it's utilized in more than one formula.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.