When adding a parent group to group by project, my data is getting split between two groups with the same project number. What do I need to fix?

Question

I created a nice report with groups and parameters. When I ran it by certain date ranges, I noticed that I would get the same group shown twice but with different data in each group. I assumed I had an issue with a calculated field, parameter, etc., so I created a new version of the report that just pulls the data. I then grouped it by project number. When I run the report, I see two groups for the same project number. Here's a sample of the report data. I'm fairly new to Reporting Services, so I'm not sure what to do to fix it!

Answer 1

Hi @hjReads ,
Is "999-10" the project number?
Could you provide your report structure? As shown below:

This allows me to see your grouping situation clearly. Have you made any other settings, what is the calculated field you mentioned? Is your parameter only a date parameter or a cascade parameter? Since you only provided some pale data, I have no way of starting.

The following is the test I did. I didn’t set the date parameter here, because I don’t think it is related to the parameter. The group by ProjectNumber is displayed as expected:
Design：

Preview:

Then I added a parent group：

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.