question

Bob-2687 avatar image
0 Votes"
Bob-2687 asked Bob-2687 commented

Report Builder not returning all rows for each group

I have a report where a student should have multiple rows if they are receiving multiple degrees.

Here are the results from my SQL. The query designer returns this as well, so I know the correct data is going into the report.

123860-sql-results.png


I should see the MA records for each of these people as well. It is not hiding all MA records. I tested this just now with other people. It appears to only choose one when a person has a record with each value.

123989-report-results.png



The bracketed section is all included in the StudentLevelGroup. The top row of it seems to be where the problem is. Everything else is working correctly. I have double checked there no filters on the tablix or any of the groups. The only visibility expressions are on those bottom sections that are not shown in the results. HideDuplicates in the properties is also empty for each of these rows.

Is there anything else I could check?

123950-design-view.png


sql-server-reporting-services
report-results.png (13.1 KiB)
design-view.png (23.7 KiB)
sql-results.png (89.4 KiB)
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.

Bob-2687 avatar image
0 Votes"
Bob-2687 answered Bob-2687 commented

I found out just now that the rows show up correctly if I change the grouping of the row with the red arrow in the first image to have the three little horizontal lines. The new problem that comes with it is that the other rows have to change as well. So I need to find the visibility expressions to correct them.

· 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.

125655-corrected-design-view.png


This is what it looks like now.

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

Hi @Bob-2687 ,
Can you share the complete report design part? It is best to provide some test data so that I can reproduce your issue.
What does your dataset look like, and is it filtered for [Degree]? If possible, please provide dataset query statements, and as detailed test data as possible.
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.

Bob-2687 avatar image
0 Votes"
Bob-2687 answered Bob-2687 converted comment to answer

@Joyzhao-MSFT Thank you for your help. The first image is the full tablix design. The address row is hidden if there is no value.

124513-full-design-view.png


I originally did not want to include this portion of the report because it is confusing, and this part seems to be working correctly. Donald has one degree record because that is the only one he's getting, and the other people were getting two. So it is fine that his record number is 3. He is the 3rd person listed on that page, and it is a different page than the other two. Some people still have courses open. Donald has three of these. Compiler Design has two records because he took it in two different terms.

124229-donald-results.png



donald-results.png (45.2 KiB)
full-design-view.png (103.2 KiB)
· 4
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.

Have you created a parent group based on [Degree] and grouped by [Name] ?If there is such a group, I don’t understand why you lost the data of [Degree].

0 Votes 0 ·

I do not have that group. The StudentLevelGroup is the one in my first image with the red bracket. You think I should add a parent group there and group on Name. Correct?

0 Votes 0 ·

The IDGroup under StudentLevelGroup is grouping on the person's unique identifier.

0 Votes 0 ·
Show more comments