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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-04-20 : 09:44:15
|
| Sheida writes "Hello,I think I'm encountering a bug in the SQL Server 2000 Reporting Services as I keep getting a "=Sum(Fields!NumberField.Value)" when I drag a numeric or currency field into a detail row. No matter what I do and I've tried many things, I only get a "Sum" (the total)for that field and not an individual amount/number. This has caused a lot of frustration and since all the books and documentation only associate the Sum function with the footer and groupings, I can only assume that this is a bug. I have a project to deliver by the end of this week (4/21/06) and I have a lot of calculation to account for, so I really would appreciate your response and insight into this problem.Thank you very much,Sheida" |
|
|
gsareport
Starting Member
4 Posts |
Posted - 2006-04-20 : 12:15:39
|
| Hi, delete the sum, try like this in the detail report = Fields!amount.value, it will display only the Amount in each row, not the Sum. |
 |
|
|
skourangi
Starting Member
7 Posts |
Posted - 2006-04-20 : 20:34:23
|
| Yes, I've tried that many times, but it just won't let me change the Sum and gives me error. Once the Sum is associated with a field, it won't let you manipulate it. I find it odd that nobody else seems to have had this issue. Please let me know when you drag a number/amount field into a table detail row, do you get just the field? |
|
|
|
gsareport
Starting Member
4 Posts |
Posted - 2006-04-21 : 10:03:10
|
| Yes I am getting just the field, I am using it in Tabular format, which one are you using, and did u check all of ur services packs( for sql 2000 it needs SRS SP1) Check with it. I'll let u know If I know any. |
|
|
|
skourangi
Starting Member
7 Posts |
Posted - 2006-04-21 : 11:01:13
|
| Thank you very much for your reply!I think I have SP2 and SP3a, but I don't know about SP1.And I don't know how to check for that! |
|
|
|
snktheone
Starting Member
20 Posts |
Posted - 2006-04-24 : 02:40:51
|
| you might be using a groupbut since u are facing issues in detail field it is only possible if u are using the Matrix report.because only matrix report need Sum function for the Data Fields.might this be helpful for u ... |
|
|
|
vnswathi
Starting Member
8 Posts |
Posted - 2006-05-02 : 10:15:48
|
| Check where are you dragging you field, are you getting an error even though you drag it onto your detail row, becasue if you drag any field onto your grouping then definetly you will be getting sum.But if you drag it on to your detail row then you will get just the field value.You can also go to properties and select fields instead of Dataset and then select the appropriate fields. |
|
|
|
|
|
|
|
|
SQL Server 2000 Reporting Services - Sum issue