In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions Custom DAC table, Generic Inquiry, Report Designer Issue
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: