i'm trying to get the results for a logical grouping of recs to list across the page instead of the ususal down.
please see attachment1. for each customer there could be up to 12 categories of sales, what i'm trying so far unsuccessfully is to get the categories to list horizontally across the page. if there are no sales for any given cat, then it would just be zero. and then get a customer grand total in the far right column. the most promising thing i tried was the iif, example, =IIf([Item Class Code]="glov",[SumOfExtended Price],"0"), in the second attachment you can see how i started to create a box for each category, but the results still render each category going down the page, see 3rd attachment for the results and where i drew how i want format report.
there is one rec for each category total, ie salesid, custid, catid, $total, so there is no need to total a bunch of recs to get the category totals
i've tried to do similar horizontal listings with other reports but never any luck
please see attachment1. for each customer there could be up to 12 categories of sales, what i'm trying so far unsuccessfully is to get the categories to list horizontally across the page. if there are no sales for any given cat, then it would just be zero. and then get a customer grand total in the far right column. the most promising thing i tried was the iif, example, =IIf([Item Class Code]="glov",[SumOfExtended Price],"0"), in the second attachment you can see how i started to create a box for each category, but the results still render each category going down the page, see 3rd attachment for the results and where i drew how i want format report.
there is one rec for each category total, ie salesid, custid, catid, $total, so there is no need to total a bunch of recs to get the category totals
i've tried to do similar horizontal listings with other reports but never any luck
