topic Re: new page when data changes in data in Report Server

new page when data changes in data

meyersmike — Fri, 25 Aug 2023 20:17:16 GMT

i'm looking to turn data like this:

site	schoolYear	student	course	grade
Site A	2023-2024	Student A	Math	A
Site A	2023-2025	Student A	Science	B
Site A	2023-2026	Student A	History	A
Site B	2023-2024	Student B	Geography	C
Site B	2023-2025	Student B	Gym	A
Site B	2023-2026	Student B	Health	A

into 2 separate pages like this:

i need to setup the page break when the student changes from Student A to Student B

how do i do this using Power BI Report Builder?

Re: new page when data changes in data

KVRKarthik — Wed, 30 Aug 2023 19:03:15 GMT

Hi meyersmike,

1. Click on View Menu and check Grouping.

2. Select the tablix in which you have this data.

3. Go to Row Groups and then "Details".

4. Right click on "Details". Select Group Properties.

5. In the window>>General>>Group expressions: Add>> Group on >> Either select from dropdown or use expression builder to add "Student" column( in which you have Student A & Student B) here.

6. In the same window>>Page Breaks>>Check "Between each instance of a group". and click on OK.

7. Then you'll get the desired output.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: new page when data changes in data

meyersmike — Fri, 01 Sep 2023 00:07:17 GMT

hi KVRKarthik ,

when i do the above, i get 2 pages, which is correct, but unfortunately, only the first row of data is returned per student. also, i notice that on page 2, the table headers aren't included, even though i have repeatColumnHeaders set to true in the tablix properties

thoughts?