Dear Experts,
While running a report getting an error. Please advise
Thanks
With Regards
Mandeep Kaur
*This post is locked for comments
Dear Experts,
While running a report getting an error. Please advise
Thanks
With Regards
Mandeep Kaur
*This post is locked for comments
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
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?
Please find below screenshot
can you show the screenshot of keys of the table?
Hi,
ReportID,USERID are the primary keys
you get this error when you use wrong parameters in GET.
what is the primary key of table repusagetemp?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,269 Super User 2024 Season 2
Martin Dráb 230,198 Most Valuable Professional
nmaenpaa 101,156