I have been working on creating a very simple report. Based on a single view which has 1000 row.
To Start I tried adding adding a single column.
But only 10 rows are getting printed with the same data
I am attaching the images for the reference
Answer
Report Design :- Repeated record in Acumatica
Best answer by lauraj46
Hi
If your view is a custom DAC, make sure that key fields are marked with IsKey=True on the DAC class definition in the customization project. Acumatica relies on this to optimize data retrieval and if the key is wrong or not specified I have seen wrong results in GIs and reports.
Hope this helps!
Laura
+13Hi
Have you checked the database to see if this specific table contains duplicate records?
Also, have you tried navigating to the next page in the report to see if additional records are being displayed?(see below image)
Dipak Nilkanth || MVP @2025 || https://www.linkedin.com/in/dipak-nilkanth-293591102 || Acumatica Developer
Hi
Table does not have duplicate values and No pagination are available in the report
+8Hi
If your view is a custom DAC, make sure that key fields are marked with IsKey=True on the DAC class definition in the customization project. Acumatica relies on this to optimize data retrieval and if the key is wrong or not specified I have seen wrong results in GIs and reports.
Hope this helps!
Laura
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.