Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
PatDeV
Posting Yak Master
197 Posts |
 Posted - 2007-08-06 : 17:09:48
|
| Hi all,I have sales reports and I want to add row at the end of page or end of reportproduct quater 1 quater 2bike 45000.00 20000.00;;;;;Total 2000000.00 2000000.00ThanksPat |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2007-08-14 : 15:29:04
|
| Select Product, [quater 1], [quarter 2] from tblAUNIONSelect 'Total', Sum[quater 1], SUM[quarter 2] from tblA |
 |
|
|
|
|
|
add total row in report