SQL Query to return total sales

I Need to write some reports using SRSS and I am struggling to calculate the total sales by area. does someone have some SQL queries they can share that return the total sales value for a client (after discounts and credits etc)? thanks in advance

do you create the reports in nav or in reporting services with direct connection to the database?