{"id":33,"date":"2013-03-20T07:01:00","date_gmt":"2013-03-20T01:31:00","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=33"},"modified":"2013-03-20T07:01:00","modified_gmt":"2013-03-20T01:31:00","slug":"show-different-headerfooter-on-different-pages-of-ssrs-report","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2013\/03\/show-different-headerfooter-on-different-pages-of-ssrs-report\/","title":{"rendered":"Show different Header\/Footer on different pages of SSRS report"},"content":{"rendered":"
\n
Sometimes, there\u00a0are requirements to show different Header\/ Footer on different pages of the report.<\/p>\n

<\/span><\/span><\/span><\/span><\/div>\n

<\/span><\/div>\n
Like say, on the first page, header\/ footer of report should be some text and on the second page it should be some different text. Please refer below screenshots.<\/p>\n

<\/span><\/span><\/span><\/div>\n

<\/span><\/div>\n
First Page Footer<\/span><\/span><\/b><\/div>\n
<\/span><\/a><\/div>\n
<\/span><\/a><\/div>\n
<\/div>\n
<\/span>Second Page Footer<\/span><\/strong><\/span><\/span><\/span><\/div>\n
<\/span><\/a><\/div>\n
<\/div>\n
<\/span><\/div>\n
This can be achieved using the solution as described below:<\/span><\/span><\/div>\n
You need to write a simple expression on the textbox control which is placed on the footer. Here you can utilize expression \u201cGlobals!PageNumber<\/b>\u201d which is used to show page numbers. This expression returns the page number, and we can alter this to show different footer on different pages.<\/span><\/span><\/div>\n
You need to write following expression on the textbox control.<\/p>\n

<\/span><\/span><\/span><\/div>\n

<\/span>=IIf(cstr(Globals!PageNumber)=“1”<\/span>,“1111-XYZ (2012\/12)\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a9 ABC Sol, 2012”<\/span>,“1111-XYZ (2012\/12)”<\/span>)<\/span><\/span><\/span><\/span><\/div>\n
<\/span><\/span><\/span>If the report page is the first page, then this expression would set the specified text else it would display alternate text.<\/span><\/span><\/div>\n
General Syntax<\/span><\/span><\/u><\/b><\/div>\n
=IIF(cstr(Globals!PageNumber)=\u201d\u201d,\u201d \u201d , \u201d \u201d)<\/span><\/span><\/div>\n
Similarly, you can use this expression to show different header on different pages as well.<\/span><\/span><\/div>\n
<\/div>\n
Hope this article helps!<\/p>\n

<\/span><\/span><\/span><\/div>\n

<\/span><\/div>\n
<\/p>\n

<\/f><\/f><\/f><\/f><\/f><\/f><\/f><\/f><\/f><\/f><\/f><\/f><\/formulas><\/lock><\/path><\/stroke><\/span><\/span><\/shapetype><\/span><\/p>\n

<\/span><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Sometimes, there\u00a0are requirements to show different Header\/ Footer on different pages of the report. Like say, on the first page, header\/ footer of report should be some text and on the second page it should be some different text. Please refer below screenshots. First Page Footer Second Page Footer This can be achieved using the\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[20,21,22,58],"tags":[879,1293],"class_list":["post-33","post","type-post","status-publish","format-standard","hentry","category-dynamics-crm-2011","category-dynamics-crm-2013","category-dynamics-crm-2015","category-ssrs-reports","tag-header-footer","tag-paging"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/33","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=33"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/33\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=33"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=33"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=33"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}