>>>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
Then setup an array and call a udf() at where sales codes are printed :
Field expression : myudf(salescode)+salescode
ie: myudf would return "" for char.
It would scan its correspoinding salescode in array and add to it as appropriate.
Or even you could put that udf() in print when" and return .t.
Cetin