{"id":92,"date":"2011-04-01T15:10:18","date_gmt":"2011-04-01T20:10:18","guid":{"rendered":"https:\/\/www.apcdynamics.com\/articles\/?p=92"},"modified":"2012-03-19T20:36:57","modified_gmt":"2012-03-20T01:36:57","slug":"navision-rdlc-reporting-setdata-and-getdata-why-it-is-required","status":"publish","type":"post","link":"https:\/\/www.apcdynamics.com\/articles\/navision-rdlc-reporting-setdata-and-getdata-why-it-is-required\/","title":{"rendered":"Navision RDLC reporting – SetData and GetData – Why It Is REQUIRED"},"content":{"rendered":"

Ever wondered why there’s no tutorial on how to create a Sales Order report from scratch in the RDLC? The reason is because it takes a LONG TIME! Even for an experienced developer, it takes a long time. As I previously mentioned on my article<\/a>, Microsoft really needs to address this in future versions.<\/p>\n

The reason for SetData and GetData is not\u00a0because of performance reason as stated in the manual 80146B. For additional information on defining SetData and GetData, please look here<\/a>.<\/p>\n

For multiple pages, the header data is dependant on whether there are lines. If you’re printing multiple form type reports like the sales order and you do not use the SetData and GetData, the header will only link to the lines displayed on the first page of the report. So this means that if your sales order is printed to the 2nd page, the header information will all disappear.<\/p>\n

Here’s an example if you create a report without using the SetData and GetData logic:
\n\"\"<\/a><\/p>\n

This is the first page. As you can see, the header displays nice and pretty. I used whiteout to remove some sensitive information in Paint.<\/p>\n

Now this is what happens when you print the 2nd page:<\/p>\n

\"\"<\/a><\/p>\n

No, it’s not an error. You’re seeing it correct. It’s a blank page. I didn’t even have to use Paint to remove any information.<\/p>\n

The reason why the 2nd page is blank, again, is because the link was done only on the first page on the header. If the report goes to the 2nd page, the link is essentially gone, therefore, no value is loaded and so nothing is displayed.<\/p>\n

 <\/p>\n

So when you create a report that has headers in forms (sales order, quote, etc). You need these:<\/p>\n

Shared Offset As Integer<\/span>
\nShared NewPage As Object<\/span>
\n\u00a0<\/span>
\nPublic Function GetGroupPageNumber(NewPage As Boolean, PageNumber As Integer) As Object<\/span>
\n\u00a0\u00a0\u00a0 If NewPage<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Offset = PageNumber – 1<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NewPage = False<\/span>
\n\u00a0\u00a0\u00a0 End If<\/span>
\n\u00a0\u00a0\u00a0 Return PageNumber – Offset<\/span>
\nEnd Function<\/span>
\n\u00a0<\/span>
\nPublic Function IsNewPage As Boolean<\/span>
\n\u00a0\u00a0\u00a0 NewPage = True<\/span>
\n\u00a0\u00a0\u00a0 Return NewPage<\/span>
\nEnd Function<\/span>
\n\u00a0<\/span>
\nShared HeaderData As Object<\/span>
\n\u00a0<\/span>
\nPublic Function GetData(Num As Integer) As Object<\/span>
\n\u00a0\u00a0 Return Cstr(Choose(Num, Split(Cstr(HeaderData),Chr(177))))<\/span>
\nEnd Function<\/span>
\n\u00a0<\/span>
\nPublic Function SetData(NewData As Object)<\/span>
\n\u00a0\u00a0\u00a0 If NewData <> “” Then<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 HeaderData = NewData<\/span>
\n\u00a0\u00a0\u00a0 End If<\/span>
\nEnd Function<\/span><\/p>\n

\u00a0<\/span>And you need these controls with the proper code:<\/p>\n

\"\"<\/a><\/p>\n

We spent hours and hours trying to get our report header to print on multiple pages. Don’t make the same mistakes we did!<\/p>\n

EDIT<\/strong> – Thanks to Steven for pointing this out. It turns out that this was<\/strong> mentioned on the 80146B manual on Chapter 3 page 35. Shows you that you shouldn’t go through the 300+ page manual quickly!<\/p>\n","protected":false},"excerpt":{"rendered":"

Ever wondered why there’s no tutorial on how to create a Sales Order report from scratch in the RDLC? The reason is because it takes a LONG TIME! Even for an experienced developer, it takes a long time. As I previously mentioned on my article, Microsoft really needs to address this in future versions. TheRead more<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[8,64,9],"tags":[],"class_list":["post-92","post","type-post","status-publish","format-standard","hentry","category-programming","category-reporting","category-upgrade"],"yoast_head":"\nNavision RDLC reporting - SetData and GetData - Why It Is REQUIRED | Confessions of a Dynamics 365 Business Central Consultant<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.apcdynamics.com\/articles\/navision-rdlc-reporting-setdata-and-getdata-why-it-is-required\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Alex Chow\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/navision-rdlc-reporting-setdata-and-getdata-why-it-is-required\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/navision-rdlc-reporting-setdata-and-getdata-why-it-is-required\\\/\"},\"author\":{\"name\":\"Alex Chow\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#\\\/schema\\\/person\\\/aef29f75349626d15235713ce1db83f0\"},\"headline\":\"Navision RDLC reporting – SetData and GetData – Why It Is REQUIRED\",\"datePublished\":\"2011-04-01T20:10:18+00:00\",\"dateModified\":\"2012-03-20T01:36:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/navision-rdlc-reporting-setdata-and-getdata-why-it-is-required\\\/\"},\"wordCount\":463,\"commentCount\":15,\"publisher\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/navision-rdlc-reporting-setdata-and-getdata-why-it-is-required\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/wp-content\\\/uploads\\\/2011\\\/04\\\/NavisionRDLCPage1.jpg\",\"articleSection\":[\"programming\",\"reporting\",\"upgrade\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/navision-rdlc-reporting-setdata-and-getdata-why-it-is-required\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/navision-rdlc-reporting-setdata-and-getdata-why-it-is-required\\\/\",\"url\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/navision-rdlc-reporting-setdata-and-getdata-why-it-is-required\\\/\",\"name\":\"Navision RDLC reporting - SetData and GetData - Why It Is REQUIRED | Confessions of a Dynamics 365 Business Central Consultant\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/navision-rdlc-reporting-setdata-and-getdata-why-it-is-required\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/navision-rdlc-reporting-setdata-and-getdata-why-it-is-required\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/wp-content\\\/uploads\\\/2011\\\/04\\\/NavisionRDLCPage1.jpg\",\"datePublished\":\"2011-04-01T20:10:18+00:00\",\"dateModified\":\"2012-03-20T01:36:57+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/navision-rdlc-reporting-setdata-and-getdata-why-it-is-required\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/navision-rdlc-reporting-setdata-and-getdata-why-it-is-required\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/navision-rdlc-reporting-setdata-and-getdata-why-it-is-required\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/wp-content\\\/uploads\\\/2011\\\/04\\\/NavisionRDLCPage1.jpg\",\"contentUrl\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/wp-content\\\/uploads\\\/2011\\\/04\\\/NavisionRDLCPage1.jpg\",\"width\":\"519\",\"height\":\"276\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/navision-rdlc-reporting-setdata-and-getdata-why-it-is-required\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"programming\",\"item\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/category\\\/programming\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Navision RDLC reporting – SetData and GetData – Why It Is REQUIRED\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#website\",\"url\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/\",\"name\":\"APC Dynamics | Dynamics 365 Business Central Consultant\",\"description\":\"Dynamics 365 Business Central experts. Less Talk. More Results.\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#organization\",\"name\":\"APC Dynamics\",\"url\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/APCLogo216.png\",\"contentUrl\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/APCLogo216.png\",\"width\":216,\"height\":216,\"caption\":\"APC Dynamics\"},\"image\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/APCommerceInc\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/ap-commerce-inc-\\\/\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCkM_LLmB4333D4Arjk0knyw\\\/about\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#\\\/schema\\\/person\\\/aef29f75349626d15235713ce1db83f0\",\"name\":\"Alex Chow\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f72fa4e27588610bb80f41bb4e562d9b82762fe530709098d99963bd2da6f86f?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f72fa4e27588610bb80f41bb4e562d9b82762fe530709098d99963bd2da6f86f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f72fa4e27588610bb80f41bb4e562d9b82762fe530709098d99963bd2da6f86f?s=96&d=mm&r=g\",\"caption\":\"Alex Chow\"},\"sameAs\":[\"https:\\\/\\\/www.apcommerce.com\\\/\"],\"url\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Navision RDLC reporting - SetData and GetData - Why It Is REQUIRED | Confessions of a Dynamics 365 Business Central Consultant","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.apcdynamics.com\/articles\/navision-rdlc-reporting-setdata-and-getdata-why-it-is-required\/","twitter_misc":{"Written by":"Alex Chow","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.apcdynamics.com\/articles\/navision-rdlc-reporting-setdata-and-getdata-why-it-is-required\/#article","isPartOf":{"@id":"https:\/\/www.apcdynamics.com\/articles\/navision-rdlc-reporting-setdata-and-getdata-why-it-is-required\/"},"author":{"name":"Alex Chow","@id":"https:\/\/www.apcdynamics.com\/articles\/#\/schema\/person\/aef29f75349626d15235713ce1db83f0"},"headline":"Navision RDLC reporting – SetData and GetData – Why It Is REQUIRED","datePublished":"2011-04-01T20:10:18+00:00","dateModified":"2012-03-20T01:36:57+00:00","mainEntityOfPage":{"@id":"https:\/\/www.apcdynamics.com\/articles\/navision-rdlc-reporting-setdata-and-getdata-why-it-is-required\/"},"wordCount":463,"commentCount":15,"publisher":{"@id":"https:\/\/www.apcdynamics.com\/articles\/#organization"},"image":{"@id":"https:\/\/www.apcdynamics.com\/articles\/navision-rdlc-reporting-setdata-and-getdata-why-it-is-required\/#primaryimage"},"thumbnailUrl":"https:\/\/www.apcdynamics.com\/articles\/wp-content\/uploads\/2011\/04\/NavisionRDLCPage1.jpg","articleSection":["programming","reporting","upgrade"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.apcdynamics.com\/articles\/navision-rdlc-reporting-setdata-and-getdata-why-it-is-required\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.apcdynamics.com\/articles\/navision-rdlc-reporting-setdata-and-getdata-why-it-is-required\/","url":"https:\/\/www.apcdynamics.com\/articles\/navision-rdlc-reporting-setdata-and-getdata-why-it-is-required\/","name":"Navision RDLC reporting - SetData and GetData - Why It Is REQUIRED | Confessions of a Dynamics 365 Business Central Consultant","isPartOf":{"@id":"https:\/\/www.apcdynamics.com\/articles\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.apcdynamics.com\/articles\/navision-rdlc-reporting-setdata-and-getdata-why-it-is-required\/#primaryimage"},"image":{"@id":"https:\/\/www.apcdynamics.com\/articles\/navision-rdlc-reporting-setdata-and-getdata-why-it-is-required\/#primaryimage"},"thumbnailUrl":"https:\/\/www.apcdynamics.com\/articles\/wp-content\/uploads\/2011\/04\/NavisionRDLCPage1.jpg","datePublished":"2011-04-01T20:10:18+00:00","dateModified":"2012-03-20T01:36:57+00:00","breadcrumb":{"@id":"https:\/\/www.apcdynamics.com\/articles\/navision-rdlc-reporting-setdata-and-getdata-why-it-is-required\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.apcdynamics.com\/articles\/navision-rdlc-reporting-setdata-and-getdata-why-it-is-required\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.apcdynamics.com\/articles\/navision-rdlc-reporting-setdata-and-getdata-why-it-is-required\/#primaryimage","url":"https:\/\/www.apcdynamics.com\/articles\/wp-content\/uploads\/2011\/04\/NavisionRDLCPage1.jpg","contentUrl":"https:\/\/www.apcdynamics.com\/articles\/wp-content\/uploads\/2011\/04\/NavisionRDLCPage1.jpg","width":"519","height":"276"},{"@type":"BreadcrumbList","@id":"https:\/\/www.apcdynamics.com\/articles\/navision-rdlc-reporting-setdata-and-getdata-why-it-is-required\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.apcdynamics.com\/articles\/"},{"@type":"ListItem","position":2,"name":"programming","item":"https:\/\/www.apcdynamics.com\/articles\/category\/programming\/"},{"@type":"ListItem","position":3,"name":"Navision RDLC reporting – SetData and GetData – Why It Is REQUIRED"}]},{"@type":"WebSite","@id":"https:\/\/www.apcdynamics.com\/articles\/#website","url":"https:\/\/www.apcdynamics.com\/articles\/","name":"APC Dynamics | Dynamics 365 Business Central Consultant","description":"Dynamics 365 Business Central experts. Less Talk. More Results.","publisher":{"@id":"https:\/\/www.apcdynamics.com\/articles\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.apcdynamics.com\/articles\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.apcdynamics.com\/articles\/#organization","name":"APC Dynamics","url":"https:\/\/www.apcdynamics.com\/articles\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.apcdynamics.com\/articles\/#\/schema\/logo\/image\/","url":"https:\/\/www.apcdynamics.com\/articles\/wp-content\/uploads\/2025\/05\/APCLogo216.png","contentUrl":"https:\/\/www.apcdynamics.com\/articles\/wp-content\/uploads\/2025\/05\/APCLogo216.png","width":216,"height":216,"caption":"APC Dynamics"},"image":{"@id":"https:\/\/www.apcdynamics.com\/articles\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/APCommerceInc\/","https:\/\/www.linkedin.com\/company\/ap-commerce-inc-\/","https:\/\/www.youtube.com\/channel\/UCkM_LLmB4333D4Arjk0knyw\/about"]},{"@type":"Person","@id":"https:\/\/www.apcdynamics.com\/articles\/#\/schema\/person\/aef29f75349626d15235713ce1db83f0","name":"Alex Chow","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f72fa4e27588610bb80f41bb4e562d9b82762fe530709098d99963bd2da6f86f?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f72fa4e27588610bb80f41bb4e562d9b82762fe530709098d99963bd2da6f86f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f72fa4e27588610bb80f41bb4e562d9b82762fe530709098d99963bd2da6f86f?s=96&d=mm&r=g","caption":"Alex Chow"},"sameAs":["https:\/\/www.apcommerce.com\/"],"url":"https:\/\/www.apcdynamics.com\/articles\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/posts\/92","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/comments?post=92"}],"version-history":[{"count":12,"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/posts\/92\/revisions"}],"predecessor-version":[{"id":223,"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/posts\/92\/revisions\/223"}],"wp:attachment":[{"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/media?parent=92"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/categories?post=92"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/tags?post=92"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}