SSRS page number within groups works most of the time

Question

SSRS page number within groups works most of the time

Bob-7209 66

I have a report showing data on hundreds of students. I have it grouped to show only one student per page with the page number in the corner counting the number of pages per student. Most students have 5 - 7 pages. It will occasionally (about every 30 or so students) show that a student has 10 - 14 pages. It is actually counting two students as one in those instances for the page number only. The student names and data on the pages are all correct. The only issue is that the page numbers are not separating the two people. The StudentGroup is where it should be delineating the page numbers. I have been searching through the data for any common fields the pairs of random people may have in common. I have not found anything to indicate why SSRS is choosing to see them as one yet. Is there some other setting I could change?

1 answer

Your answer

Answer 1

Joyzhao-MSFT 15,646

Hi @Bob-7209 ,
Judging from your settings, I did not find any problems.
In my test, the report page number was reset according to the grouping, and the report performed well.

In your case, when the page numbers of your two students appear to be in the same group, is the PageName displayed normally?
If the problem exists in individual reports, you should consider whether it is the source data problem. And you need to check your grouping situation.
If this issue occurs intermittently in your same report, please feel free to let me know.
Best Regards,
Joy

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.

Bob-7209 66 Reputation points

2021-11-09T15:59:09.573+00:00

I do not have page names. I will continue investigating. Thank you.
Joyzhao-MSFT 15,646 Reputation points

2021-11-10T01:17:25.787+00:00

So does your situation only appear in a single report or in multiple reports? Does this phenomenon always exist in this report?
Bob-7209 66 Reputation points

2021-11-10T04:37:20.273+00:00

This is the only report where I have had the page numbers linked to the groups. All of my other reports just count the number of pages. That is an interesting idea though. I will try to recreate the issue in another report.

The report was complete until my end user asked that I change the page numbers with the groups. So, this was when the problem showed up.
Joyzhao-MSFT 15,646 Reputation points

2021-11-11T01:59:14.627+00:00

Could you share your report design? I think it may be related to the [StudentSubreportsGroup] group you set. Did you just set a page break in [StudentGroup]?
Bob-7209 66 Reputation points

2021-11-11T04:30:31.12+00:00

The selected group in this image is the StudentSubreportsGroup. It joins the subreports into the main report on the student ID number. Some students will have records in the one or both subreports and some will not have either. I have been scrolling through a lot of the pages looking for instances of the problem. The common trait I see so far is that the first person in the pair will have records in the transfer subreport. This does not necessarily indicate the root cause of the issue because a lot people have transfer records. I also noticed that while it usually only groups two people together, there are a few occasions with three people under one set of pages.
Joyzhao-MSFT 15,646 Reputation points

2021-11-15T08:11:56.74+00:00

It sounds like the subreport affects the page number. If possible, re-create the report and remove the sub-report to check whether the problem comes from the sub-report. Since your report cannot be obtained, there is no way to test it for you.
Bob-7209 66 Reputation points

2021-11-16T14:45:40.053+00:00

Hi Joy,
This does seem to be the case. I am investigating how to fix it.

Thank you
Bob-7209 66 Reputation points

2021-11-23T16:35:32.343+00:00

@Joyzhao-MSFT I have not found the problem yet. Not all people have subreport records. So I found two students who show up in the report and are not being delineated by the main report page number. I added the page number and student name into this subreport just like they are in the main report. The ResetPageNumber is set to true and the BreakLocation is between in the StudentGroup settings. The subreport is properly separating the students.
I am using the student's id number to join the subreport in, and each student does have a unique number.
What else could I check?

Share via

SSRS page number within groups works most of the time

1 answer

Your answer