>>>I can't figure out how to do this in report designer, or even if it's possible.
>>>
>>>Each of the line items in an invoice has a sales code attached to it. I need to take the first 5 sales codes and print them at the bottom along with the sum of the cost of the items with that sales code.
>>>
>>>Because of the screwy way SBT does reports, I need to do this in the report designer itself, rather than just doing a select into an array in the calling program like I had planned.
>>>
>>>I figured I'd have to use report variables somehow, but I don't know how. I won't know which codes will be summed, or their sums ahead of time. The records aren't and can't be grouped by sales code, so there may be an item of one sc, then one of another, then another of the first sc. I need to somehow pick out the first 5 sc's used, and add up the values, then print them at the bottom.
>>>
>>>Any ideas?
>>>
>>>Thanks,
>>>
>>>Michelle
>>Michelle,
>>As a quick idea, could you run an SQL for sums with top 5 into another cursor and use that in report too.
>>Cetin
>
>No, because the SQL would run on the whole table, and I need it only on certain records.
>
>I got a step closer. It looks like I can group by sales code after all. So I can probably get the totals. Not sure how to get the codes, though.
>
>Thanks,
>
>Michelle

Michelle, I use UDFs in my reports similar to this.
* report is running and gets to the field
items_sum_for_salescode(itemcode) && this is the report field expression

FUNCTION items_sum_for_salescode
LPARAMETER lcSalesCode

LOCAL laSum[1]
store 0 to laSum[1]
SELECT SUM(itemcost) FROM INVOICE ;
WHERE invoice.salescode = lcSalesCode ;
INTO array laSum

RETURN laSum[1]
ENDFUNC

Here you need only to figure out how to run this only for 5 of your sales codes.

HTH,
Nick