Hi I want the excise report group by Excise Product Posting Group. I used Sales Invoice Line Table. For that i make all settings in reports: Data Item Table View: SORTING(Excise Prod. Posting Group) WHERE(Excise Amount=FILTER(>0)) I make a key in Excise Prod. Posting Group in appropriate table. Group Total Fields: Excise Prod. Posting Group But the problem is: It doesn’t group by Excise Product Posting Group at all instead it gave a single entry in infinite loop… If i remove SORTING(Excise Prod. Posting Group) portion from the appropriate property then it will give me the result but don’t group by Excise Prod. Posting Group… Pls give me the guidance for that… Thanx… Tejas Nagar
HI Please look into your GrouFooter section whether your Print for the totals caused by the Exceise posting Group/not. Also Check…for … Curreport.CreateTotals(“Excise Posting Group”); on the prereport Trigger of the report.