Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Error while running a report

(0) ShareShare
ReportReport
Posted on by

Dear Experts,

While running a report getting an error. Please advise

errorreport.png

error-code.png

Thanks

With Regards

Mandeep Kaur

*This post is locked for comments

  • Suggested answer
    Nareshwar Raju Vaneshwar Profile Picture
    5,596 on at
    RE: Error while running a report

    Hi,

    This happens because the user has created a new field using TableRelation = <Related_Table> but the data type is not match with primary key of related table.

                          E.g. Customer | Integer | TableRelation=Customer

    Solution :

    • Get all text object backup from related environment.

    • Open it from text editor application.

    • Find the following string.

                <DataType>       ;TableRelation=<TableName>

                E.g.: Boolean       ;TableRelation=Customer

    Then make the appropriate relation.

    Hope it helps

  • Suggested answer
    Mohana Yadav Profile Picture
    60,228 Super User 2025 Season 1 on at
    RE: Error while running a report

    and I hope field Report ID is of datatype Integer and User ID is either text or Code.

    may be different: why are you not assigning report id parameter value to field report id after get statement in first screenshot?

  • Community Member Profile Picture
    on at
    RE: Error while running a report

    Please find below screenshot

    keys.png

  • Suggested answer
    Mohana Yadav Profile Picture
    60,228 Super User 2025 Season 1 on at
    RE: Error while running a report

    can you show the screenshot of keys of the table?

  • Community Member Profile Picture
    on at
    RE: Error while running a report

    Hi,

    ReportID,USERID are the primary keys

  • Suggested answer
    Mohana Yadav Profile Picture
    60,228 Super User 2025 Season 1 on at
    RE: Error while running a report

    you get this error when you use wrong parameters in GET.

    what is the primary key of table repusagetemp?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans