Wrong all total in SSRS

Patrick Wong 1 Reputation point
2021-08-09T02:03:50.287+00:00

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
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,951 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,601 Reputation points
    2021-08-09T03:21:00.977+00:00

    Hi @Patrick Wong ,
    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.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.