By using this website, you agree to our Terms of Use (click here)
I am building a report comprised of 4 sub reports.
For the data within one sub report we are calling a GI that uses a custom DAC table.
When the data is pulled into the report, the data being called is duplicated. This is not the case in the GI.
Has anyone had issues with custom DAC tables in ARD before?
My first instinct would be to check joins (particularly around CompanyID/SiteID/etc if it's a custom table) or if the subreport is being passed the correct parameters.
I've experienced this before when you don't mark the Primary Key fields with IsKey. For some reason Report Designer gets confused. Search for "IsKey" in this post for some sample code:
https://www.augforums.com/importing-historical-data-acumatica-cool-twist