>Would you please tell me how to create a sequence number for data grouping in report designer ? I haven't got the way to do that from within the report designer, so I create a temporary table (with an additional pre-defined column for sequence number) to store the result from a SQL-statement and then I create a procedure to fill the column with a sequence number for each group.
>
>Thanks a lot for your help,
>Andi Hidajat
>pkshq@cbn.net.id
>Jakarta, Indonesia
Andi, you can use a user-defined function for a variable in the report group header and increase it by one each time it's called.
HTH