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 |
|
Tart_SQL
Starting Member
41 Posts |
 Posted - 2008-10-01 : 18:28:03
|
| I have this list in my report which I bind to a dataset. I then have a textbox on this list which should display the sum of a particular field. It actually displays the sum but the problem is that it repeats the sum three or more times. How do I stop this from repeating. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Tart_SQL
Starting Member
41 Posts |
Posted - 2008-10-02 : 00:42:09
|
| I really cant group it because on that column I only want to count the records greater than zero, thats why I decided to use the list. Can list work without grouping? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-02 : 04:32:01
|
quote:
Originally posted by Tart_SQL
I really cant group it because on that column I only want to count the records greater than zero, thats why I decided to use the list. Can list work without grouping?
you need to apply grouping on it and use Sum() to avoid repetition.or put it in header of container. |
|
|
|
Tart_SQL
Starting Member
41 Posts |
Posted - 2008-10-03 : 00:53:07
|
quote:
Originally posted by visakh16
quote:
Originally posted by Tart_SQL
I really cant group it because on that column I only want to count the records greater than zero, thats why I decided to use the list. Can list work without grouping?
you need to apply grouping on it and use Sum() to avoid repetition.or put it in header of container.
Unfortunately I do not want to change the query as it is used for other tables in the report, is it possible to apply a dummy grouping? That is if I can use a synthax as a dummy grouping if there is in SSRS, will that work? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-03 : 00:55:08
|
| how is your data currently coming? can you show sample from dataset? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-03 : 02:39:50
|
| Have you added any fields to Edit Deatils Group tab grouping field? |
|
|
|
|
|
|
Repeating list