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 |
|
raaj
Posting Yak Master
129 Posts |
 Posted - 2008-05-19 : 11:33:32
|
| Hi Guys,I am having 3 columns named grossincome,taxes, and netincome with values something like this:grossincome taxes netincome 5000 1000 4000 6000 1500 4500 4500 750 3750with many more rows....Now i want my last page of the report to display the total of all the three...i.e. totalgrossincome,totaltaxes,totalnetincome with values like this (sum of the above values)totalGI totalTaxes totalNI15500 3250 13250So do i need to create a seperate report and table for this????or is there any way to do in the same report(like dropping another table in the body of the report and making it visible only in the last page of the report???) Thanks,Raaj.... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-19 : 13:21:26
|
| I think you can try placing a dummy group on any of your field in dataset and enable option place a page break after this group. |
 |
|
|
|
|
|
doing sum and displaying in a new page....