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 |
|
sachya45
Starting Member
25 Posts |
 Posted - 2009-05-02 : 16:49:20
|
| I need to sum detail column in my table footer.The detail column has duplicate entries but i need sum of only distinct entries.i want those duplicates to display in my Report but while calculating sum take distinct values only.and then get the sum of each group values.I have tried runningvalue function and tried to hide duplicates and then get the sum of only displayedvalues but its not working please help.....i have been trying this for long...Thanks in advance....my Report looks as follow:Group1 headergroup2 headergroup3 headerDetail rowgroup 3 footergroup2 footergroup1 footerexample:group1 001group2 0989group3 7890Detail row 1722929.711722929.711722929.71------------group3 total 1722929.715276198.025276198.02group3 total -----------5276196.02group2 -----------------group2 total (1722929.71+ 5276198.02)------------------------(group1 total) total of all fields of group 2 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-07 : 14:22:57
|
| do you have any field to distinguish distinct entries in detail row? |
 |
|
|
|
|
|
Need help on group total