richard smith

richard smith

  • 1.5k
  • 285
  • 160.3k

Query SQL Return Results to Excel & Format

Mar 8 2013 11:20 PM
Essentially this is what I need...if you have any follow-up ?'s or need any further info please ask...
1st row of each section would be headers
Query SQL Table
Return results under headers
Total the $ column
space
headers
Return results
Total the $column
space
(if bottom of set) 
Grand Total & A total of all the totalcolumns


SalesRep    ItemSold    Quantity    Price
JoeName      40' tv      3           $500
JoeName      20' tv      10          $200
Total                                $700

SaleRep     ItemSold    Quantity    Price
Rname       10' TV       200        $100
Rname       30' TV       75         $300
Total                               $400

Grand Total                         $1100

How would I do that in C#?

Answers (1)