Michelle,

If you have already figured it out for doing the select into an array, I would just create a little stand-alone program and call it from the title band of the report to create your array or whatever there. Quite often I run into people who don't have the SBT source code but need simple things added to the report. Since SBT lets you edit the report, this is an easy way to do it. I even put a little note on the report in red bold pointing to the function call so we don't miss that it is there and then just make the note as print when .F.

Bill


>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