Hi All, I have encountering an unexpected problem from report desginer. The report is made by the exported G.I., and the G.I. actuallly have no problem at all.
However, when I do the same setting in the report designer, finally there are 2-3 items cannot be grouped. I have really no idea about it. The grouping data is normally including Inventory CD, LotSeriesNbr, Site ID, and Location ID. I have checked many times the data is not problem, referring to the screenshot I highlighted it in yellow, the data is matched and same, but it comes up not grouping.
Is there anything I missed out or something I need to setup in the report designer (which is different with G.I.)? I surely the original G.I. is working like a charm, but just report result is not the same.
Appreicate if someone can help or advise to fix this problem. Many thanks.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/695ede6a-39c2-4b27-b2c3-b88e910dff28.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/880a2fb2-9e6d-477a-bf54-92c9903c5b60.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/85ff2921-39c2-4ca6-a35e-fe7839c623bf.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/365e480c-87e0-4df1-960b-033bab07d67e.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/0eadf1a7-ea1e-4faa-a43e-ee6b1916f50c.png)
Best answer by martinma
View original