web
You’re offline. This is a read only version of the page.
close
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

I have the same question (0)
  • Suggested answer
    Mohana Yadav Profile Picture
    60,993 Super User 2025 Season 2 on at

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

    what is the primary key of table repusagetemp?

  • Community Member Profile Picture
    on at

    Hi,

    ReportID,USERID are the primary keys

  • Suggested answer
    Mohana Yadav Profile Picture
    60,993 Super User 2025 Season 2 on at

    can you show the screenshot of keys of the table?

  • Community Member Profile Picture
    on at

    Please find below screenshot

    keys.png

  • Suggested answer
    Mohana Yadav Profile Picture
    60,993 Super User 2025 Season 2 on at

    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?

  • Suggested answer
    Nareshwar Raju Vaneshwar Profile Picture
    5,596 on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans