@JTRTech I remember a long time ago you made a Detailed Item Sales report.
I recently took that report and started playing with Pivot Tables. I think it’s coming out quite nice and it generates much faster because with Pivot you do not need to use parameters. I used Custom Product tags to define a ReportingGroup and SubReportingGroup for every product.
[#Ürünler:4,5, 2, 2:0]
>Kategori|Ürün|[N]Adet|[C]Tutar
@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True):{0}:,}
@{REPORT ORDER DETAILS:M.GroupCode,O.ExactTotal.Sum.desc:(ODI=True):{0}:,}
>{REPORT ORDER DETAILS:M.GroupCode,O.MenuItemName,O.Quantity.Sum.desc;#,O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName="$1":{0}|{1}|{2}|{3}}
{REPORT ORDER DETAILS:M.GroupCode,' '+[O.PortionName],O.Quantity.Sum.desc;#,O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName="$1":2}