Excel spreadsheet report with dollar totals, grouped by sales person in region
-
Hi, what is the best way to present a report, showing the dollar value per month for each salesperson in a certain region? Suppose we have Eastern and Western regions. Salesperson Sam, Sammantha, Roger,will Should I use SSIS package for this purpose, or would a stored proc be able to create this same type of layout? The report should look like, in an excel spreadsheet:
Region Salesperson Month(Total) Eastern Sam $1050.00 Roger $100.00 Will $100.00 Total $1250.00 Western Sammantha $2000.00 Total $2000.00 Grand total $3250.00Any ideas is appreciated! thanks.
-
Hi, what is the best way to present a report, showing the dollar value per month for each salesperson in a certain region? Suppose we have Eastern and Western regions. Salesperson Sam, Sammantha, Roger,will Should I use SSIS package for this purpose, or would a stored proc be able to create this same type of layout? The report should look like, in an excel spreadsheet:
Region Salesperson Month(Total) Eastern Sam $1050.00 Roger $100.00 Will $100.00 Total $1250.00 Western Sammantha $2000.00 Total $2000.00 Grand total $3250.00Any ideas is appreciated! thanks.
The UI (report layout) has absolutely NOTHING to do with the database. Use the stored proc to prepare the data for you. Use the UI (excel or a reporting tool) to do the formatting and layout. You sub/grand totalling should be done in the reporting app, the pretty currency format belongs in the reporting app as well.
Never underestimate the power of human stupidity RAH