CODEWITHSUNDEEP
sqlvb.netreporting-services
Serdia
Serdia

Reputation: 4418

why my page number in SSRS dashboard doesnt displays in the right corner of each page?

My dashboard consist of 10 sub-reports. And some of those sub-reports are several pages.In a page footer of a dashboard I entered expression in a textbox:

="Page " & Globals!OverallPageNumber & " of " & Globals!OverallTotalPages

which gives me the page number, but how can I move this to the right corner? As you can see on a below picture the expression already further right than even sub-report itself. What else can I do? This is my report properties for the Dashboard: enter image description here enter image description here

enter image description here

Upvotes: 0

Views: 127

Answers (1)

Hannover Fist
Hannover Fist

Reputation: 10860

It looks like the table you have is a Matrix with Column grouping. The grouping is expanding and pushing the width but unfortunately, that doesn't push the footer out.

Since you can't make the position dynamic, you'll have to figure out where the sub report page ends and extend the main report's width to fit the page number.

It looks like the first column is 4 inches wide and the matrix columns are 2 inches wide. I would put the text box at 15 inches and make it 1 inch wide.

Upvotes: 1

Related Questions