Skip to Content

Field name unknown

Hello

I have to update a report because of changes in the database. I have verified the Database in the Report and all sub-reports. The old fields are gone, the new ones are there. But still I can't run the report. Error: Field name unknown


How can I figure this out?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Oct 07, 2018 at 05:03 AM

    I've figured it out.... The Field was used in a sub report for grouping and in the link definition. After reconfiguration it worked again. Was a quite a pain to figure this out though...

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 04, 2018 at 11:15 AM

    When you verified report did you Map all Old fields to the new fields.

    Try verifying again

    Or

    find a copy of ole report and reverify that again making sure all fields are mapped to new fields

    Ian

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 07, 2018 at 05:02 AM

    I've tried it again with a restored file. But I can't map anything. The relation between 2 tables changed from one-to-many to many-to-many. So there is a foreign key field that disappeard, and a new connection table which I've added to the report. I can't map that FK field to anything....?

    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.