question

PatrickWong-3440 avatar image
0 Votes"
PatrickWong-3440 asked Joyzhao-MSFT commented

Wrong all total in SSRS

Having problem in this some one help ?
I new in SSRS just learn 1 month ago.
thank you
the all total count wrongly, Did any sollution?

121453-wechat-image-20210809100054.jpg


sql-server-reporting-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @PatrickWong-3440 ,
Has your issue been resolved?
If you have any questions, please feel free to let me know.
If the answer is helpful, please click "Accept Answer" and upvote it.
Best Regards,
Joy

0 Votes 0 ·

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT edited

Hi @PatrickWong-3440 ,
If I understand correctly, the total you need to calculate should be 29000 (10000+4000+15000). Are there any groupings in your report? What is the report structure? How did you get this 37000 value?
If it is possible, please provide testable data as much as possible.
You could also check the following official documents: Add a Total to a Group or Tablix Data Region (Report Builder and SSRS).
Lesson 6: Adding Grouping and Totals (Reporting Services).
Best Regards,
Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.