CODEWITHSUNDEEP
sql-serverreporting-servicesgroup-byssrs-2008-r2page-break
YelizavetaYR
YelizavetaYR

Reputation: 1711

SSRS - modify PageName using pagebreaks/group by elements

I have an SSRS report that has one Tablix, it is grouped based on a field 'venue'

enter image description here

It has a checkbox for 'Page break options' Between each instance of the group.

enter image description here

So each venue has its own page of data however PageName is set to one value under properties.

enter image description here

Is there a way to automate each page/instance of the venue to be more dynamic.

Upvotes: 1

Views: 2046

Answers (2)

Paris Guan
Paris Guan

Reputation: 21

Click the Row Group at the bottom to toggle the "Tablix Member" properties. Then you can see the PageName in Group section. On your case, PageName =Fields!venue.value

Upvotes: 1

Paris Guan
Paris Guan

Reputation: 21

Pick Expression at the PageName,

=First(Fields!venue.Value, "dataset")

Upvotes: 0

Related Questions