Still having problems designing an asp report that gives sub totals. I have an online report that pulls from a SQL view and returns a User's Name, some description fields and an amount. I want to subtotal it by each person. I have tried doing a 'compute sum(amount) by username' in the view but I can not assign an alias to that value. The other problem is once I get the sub total value, how do I dynamically display it in the report. Any help would be appreciated..