{"id":516,"date":"2021-02-23T07:38:07","date_gmt":"2021-02-23T07:38:07","guid":{"rendered":"http:\/\/fredborg.org\/?p=516"},"modified":"2021-02-23T07:38:08","modified_gmt":"2021-02-23T07:38:08","slug":"simple-al-report-from-scratch-in-business-central","status":"publish","type":"post","link":"https:\/\/fredborg.org\/?p=516","title":{"rendered":"Simple AL Report from Scratch in Business Central"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">In this post we will go through the steps to create a simple RDLC report from scratch, now I know that most of the time you would copy a standard report and not create&nbsp;your&nbsp;reports from scratch, however&nbsp;I feel that it is important to understand the basics&nbsp;of how a report is created, to help you&nbsp;be most&nbsp;efficient.&nbsp;&#x1f913;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">As not to make this post too long, I would recommend that you watch the video &#x1f3a5; below&nbsp;to get a more&nbsp;in-depth&nbsp;walkthrough,&nbsp;well&nbsp;let us get to it.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To get started we first need to create a new AL file in our project, of type report, to make this simple I use the New Al File Wizard&nbsp;that you get by installing the Visual Studio Code extension AZ AL Dev Tools\/AL Code Outline, now I cannot recommend this extension enough, it has a lot of cool &#x1f60e; tools to make your life as a Business Central developer much easier.&nbsp;&#x1f60a;&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"257\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/image-5.png\" alt=\"\" class=\"wp-image-522\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/image-5.png 1024w, https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/image-5-300x75.png 300w, https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/image-5-768x193.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Once you have installed this extension, you can right click in your AL project and choose&nbsp;New AL File Wizard&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"449\" height=\"114\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/image.png\" alt=\"\" class=\"wp-image-517\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/image.png 449w, https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/image-300x76.png 300w\" sizes=\"auto, (max-width: 449px) 100vw, 449px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">And choose Report:&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"777\" height=\"583\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/image-4.png\" alt=\"\" class=\"wp-image-521\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/image-4.png 777w, https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/image-4-300x225.png 300w, https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/image-4-768x576.png 768w\" sizes=\"auto, (max-width: 777px) 100vw, 777px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">One of the&nbsp;great&nbsp;things about the Al Wizard is that it will automatically find the next&nbsp;valid&nbsp;object ID, next give it a name and set the Source Table Name to be Sales Header.&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"739\" height=\"332\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/image-2.png\" alt=\"\" class=\"wp-image-519\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/image-2.png 739w, https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/image-2-300x135.png 300w\" sizes=\"auto, (max-width: 739px) 100vw, 739px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Press next and choose the fields that you want to use from your header.&nbsp;Again,&nbsp;to keep it simple I have just&nbsp;chosen&nbsp;the No. And the Bill-to fields:&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"224\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/image-3.png\" alt=\"\" class=\"wp-image-520\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/image-3.png 1024w, https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/image-3-300x66.png 300w, https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/image-3-768x168.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Then hit finish, and as you can see it will generate a new AL report for you. Next you need to add some things to the report, the first is the location of where you wish to store your layout files, next is the caption of your report and you must set your Default layout to RDLC:&nbsp;<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\nreport 50100 MyInvoice \n{ \n    RDLCLayout = &#039;.\/layouts\/MyOrderConf.rdl&#039;; \n    Caption = &#039;My Order Confirmation&#039;; \n    DefaultLayout = RDLC; \n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">The&nbsp;RDLCLayout&nbsp;paramter&nbsp;should point to a location within your extension, and the first time you build your extension (CTRL+SHFT+B) it will generate&nbsp;an&nbsp;rdl&nbsp;file&nbsp;in your chosen location.&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"238\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/image-6.png\" alt=\"\" class=\"wp-image-523\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/image-6.png 1024w, https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/image-6-300x70.png 300w, https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/image-6-768x179.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Next let us add our sales lines to our dataset, this is done by editing our&nbsp;AL&nbsp;file&nbsp;so it looks like the following.&nbsp;<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\nDataset \n    { \n        dataitem(SalesHeader; &quot;Sales Header&quot;) \n        { \n            column(No; &quot;No.&quot;) \n            {   \n\t\t  } \n\n            column(BilltoCustomerNo; &quot;Bill-to Customer No.&quot;) \n            {   \n\t\t} \n\n            column(BilltoName; &quot;Bill-to Name&quot;) \n            { \n\n            } \n\n            column(BilltoAddress; &quot;Bill-to Address&quot;) \n\n            { \n\n            } \n\n            column(BilltoCity; &quot;Bill-to City&quot;) \n\n            { \n\n            } \n\n            column(BilltoPostCode; &quot;Bill-to Post Code&quot;) \n\n            { \n\n            } \n\n            dataitem(Line; &quot;Sales Line&quot;) \n\n            { \n\n                DataItemLink = &quot;Document No.&quot; = FIELD(&quot;No.&quot;); \n                DataItemLinkReference = SalesHeader; \n                DataItemTableView = SORTING(&quot;Document No.&quot;, &quot;Line No.&quot;); \n\n            } \n\n        } \n\n    } \n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">So what we have done here is we have added a new&nbsp;dataitem&nbsp;based on our sales lines, and linked this&nbsp;dataitem&nbsp;to our sales header on document no. Next let us just add No and description:&nbsp;<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\ndataitem(Line; &quot;Sales Line&quot;) \n  { \n\t\t  DataItemLink = &quot;Document No.&quot; = FIELD(&quot;No.&quot;); \n         DataItemLinkReference = SalesHeader; \n         DataItemTableView = SORTING(&quot;Document No.&quot;, &quot;Line No.&quot;); \n\n         column(No_;&quot;No.&quot;) \n         {} \n\n         column(Description;Description) \n         {} \n\n  } \n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">Once you have added these you should build your extension (CTRL+SHIFT+B) and next right click on your&nbsp;rdl&nbsp;file and choose Open&nbsp;Externally&nbsp;&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"449\" height=\"152\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/image-1.png\" alt=\"\" class=\"wp-image-518\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/image-1.png 449w, https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/image-1-300x102.png 300w\" sizes=\"auto, (max-width: 449px) 100vw, 449px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">This should launch your SQL Report Builder, if you do not have SQL Report Builder installed you can download it here:&nbsp;<a href=\"https:\/\/www.microsoft.com\/da-dk\/download\/details.aspx?id=53613\" target=\"_blank\" rel=\"noreferrer noopener\">Download Microsoft\u00ae Report Builder from Official Microsoft Download Center<\/a>&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In our RDL layout file we are going to add a list, and group it on Document No., add a table and your data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Now this is where I would suggest that you watch the video, because I cannot find a good way to explain this part in writing&nbsp;&#x1f60a;&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">And that is it for this blog post, I hope you enjoyed it and until next time stay safe.&nbsp;&#x1f637; &#x1f489;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><br>&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\"  id=\"_ytid_23896\"  width=\"1140\" height=\"641\"  data-origwidth=\"1140\" data-origheight=\"641\" src=\"https:\/\/www.youtube.com\/embed\/lWSP6bC-CQI?enablejsapi=1&#038;autoplay=0&#038;cc_load_policy=0&#038;cc_lang_pref=&#038;iv_load_policy=1&#038;loop=0&#038;rel=1&#038;fs=1&#038;playsinline=0&#038;autohide=2&#038;theme=dark&#038;color=red&#038;controls=1&#038;disablekb=0&#038;\" class=\"__youtube_prefs__  epyt-is-override  no-lazyload\" title=\"YouTube player\"  allow=\"fullscreen; accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen data-no-lazy=\"1\" data-skipgform_ajax_framebjll=\"\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>In this post we will go through the steps to create a simple RDLC report from scratch, now I know&#8230; <a class=\"read-more\" href=\"https:\/\/fredborg.org\/?p=516\" rel=\"nofollow\"> Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":531,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-516","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business-central","shapla-grid-item"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Simple AL Report from Scratch in Business Central - Fredborg<\/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:\/\/fredborg.org\/?p=516\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Simple AL Report from Scratch in Business Central - Fredborg\" \/>\n<meta property=\"og:description\" content=\"In this post we will go through the steps to create a simple RDLC report from scratch, now I know... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fredborg.org\/?p=516\" \/>\n<meta property=\"og:site_name\" content=\"Fredborg\" \/>\n<meta property=\"article:published_time\" content=\"2021-02-23T07:38:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-23T07:38:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/SimpleReportsThumb.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1152\" \/>\n\t<meta property=\"og:image:height\" content=\"648\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dfredborg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dfredborg\" \/>\n<meta name=\"twitter:site\" content=\"@dfredborg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dfredborg\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fredborg.org\/?p=516#article\",\"isPartOf\":{\"@id\":\"https:\/\/fredborg.org\/?p=516\"},\"author\":{\"name\":\"dfredborg\",\"@id\":\"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d\"},\"headline\":\"Simple AL Report from Scratch in Business Central\",\"datePublished\":\"2021-02-23T07:38:07+00:00\",\"dateModified\":\"2021-02-23T07:38:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fredborg.org\/?p=516\"},\"wordCount\":610,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d\"},\"image\":{\"@id\":\"https:\/\/fredborg.org\/?p=516#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/SimpleReportsThumb.png\",\"articleSection\":[\"Business Central\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fredborg.org\/?p=516#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fredborg.org\/?p=516\",\"url\":\"https:\/\/fredborg.org\/?p=516\",\"name\":\"Simple AL Report from Scratch in Business Central - Fredborg\",\"isPartOf\":{\"@id\":\"https:\/\/fredborg.org\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/fredborg.org\/?p=516#primaryimage\"},\"image\":{\"@id\":\"https:\/\/fredborg.org\/?p=516#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/SimpleReportsThumb.png\",\"datePublished\":\"2021-02-23T07:38:07+00:00\",\"dateModified\":\"2021-02-23T07:38:08+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/fredborg.org\/?p=516#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fredborg.org\/?p=516\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/fredborg.org\/?p=516#primaryimage\",\"url\":\"https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/SimpleReportsThumb.png\",\"contentUrl\":\"https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/SimpleReportsThumb.png\",\"width\":1152,\"height\":648},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fredborg.org\/?p=516#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/fredborg.org\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Simple AL Report from Scratch in Business Central\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fredborg.org\/#website\",\"url\":\"https:\/\/fredborg.org\/\",\"name\":\"Fredborg\",\"description\":\"Business Central and Azure\",\"publisher\":{\"@id\":\"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fredborg.org\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d\",\"name\":\"dfredborg\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/fredborg.org\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/06\/download.png\",\"contentUrl\":\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/06\/download.png\",\"width\":256,\"height\":256,\"caption\":\"dfredborg\"},\"logo\":{\"@id\":\"https:\/\/fredborg.org\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:fredborg.org\",\"https:\/\/www.linkedin.com\/in\/dfredborg\/\",\"https:\/\/x.com\/dfredborg\",\"https:\/\/www.youtube.com\/channel\/UCUNZglLDMjBlOK_T9JtI8UA\"],\"url\":\"https:\/\/fredborg.org\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Simple AL Report from Scratch in Business Central - Fredborg","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:\/\/fredborg.org\/?p=516","og_locale":"en_US","og_type":"article","og_title":"Simple AL Report from Scratch in Business Central - Fredborg","og_description":"In this post we will go through the steps to create a simple RDLC report from scratch, now I know... Read more","og_url":"https:\/\/fredborg.org\/?p=516","og_site_name":"Fredborg","article_published_time":"2021-02-23T07:38:07+00:00","article_modified_time":"2021-02-23T07:38:08+00:00","og_image":[{"width":1152,"height":648,"url":"https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/SimpleReportsThumb.png","type":"image\/png"}],"author":"dfredborg","twitter_card":"summary_large_image","twitter_creator":"@dfredborg","twitter_site":"@dfredborg","twitter_misc":{"Written by":"dfredborg","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fredborg.org\/?p=516#article","isPartOf":{"@id":"https:\/\/fredborg.org\/?p=516"},"author":{"name":"dfredborg","@id":"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d"},"headline":"Simple AL Report from Scratch in Business Central","datePublished":"2021-02-23T07:38:07+00:00","dateModified":"2021-02-23T07:38:08+00:00","mainEntityOfPage":{"@id":"https:\/\/fredborg.org\/?p=516"},"wordCount":610,"commentCount":0,"publisher":{"@id":"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d"},"image":{"@id":"https:\/\/fredborg.org\/?p=516#primaryimage"},"thumbnailUrl":"https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/SimpleReportsThumb.png","articleSection":["Business Central"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fredborg.org\/?p=516#respond"]}]},{"@type":"WebPage","@id":"https:\/\/fredborg.org\/?p=516","url":"https:\/\/fredborg.org\/?p=516","name":"Simple AL Report from Scratch in Business Central - Fredborg","isPartOf":{"@id":"https:\/\/fredborg.org\/#website"},"primaryImageOfPage":{"@id":"https:\/\/fredborg.org\/?p=516#primaryimage"},"image":{"@id":"https:\/\/fredborg.org\/?p=516#primaryimage"},"thumbnailUrl":"https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/SimpleReportsThumb.png","datePublished":"2021-02-23T07:38:07+00:00","dateModified":"2021-02-23T07:38:08+00:00","breadcrumb":{"@id":"https:\/\/fredborg.org\/?p=516#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fredborg.org\/?p=516"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/fredborg.org\/?p=516#primaryimage","url":"https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/SimpleReportsThumb.png","contentUrl":"https:\/\/fredborg.org\/wp-content\/uploads\/2021\/02\/SimpleReportsThumb.png","width":1152,"height":648},{"@type":"BreadcrumbList","@id":"https:\/\/fredborg.org\/?p=516#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/fredborg.org\/"},{"@type":"ListItem","position":2,"name":"Simple AL Report from Scratch in Business Central"}]},{"@type":"WebSite","@id":"https:\/\/fredborg.org\/#website","url":"https:\/\/fredborg.org\/","name":"Fredborg","description":"Business Central and Azure","publisher":{"@id":"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fredborg.org\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d","name":"dfredborg","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/fredborg.org\/#\/schema\/person\/image\/","url":"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/06\/download.png","contentUrl":"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/06\/download.png","width":256,"height":256,"caption":"dfredborg"},"logo":{"@id":"https:\/\/fredborg.org\/#\/schema\/person\/image\/"},"sameAs":["https:fredborg.org","https:\/\/www.linkedin.com\/in\/dfredborg\/","https:\/\/x.com\/dfredborg","https:\/\/www.youtube.com\/channel\/UCUNZglLDMjBlOK_T9JtI8UA"],"url":"https:\/\/fredborg.org\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/fredborg.org\/index.php?rest_route=\/wp\/v2\/posts\/516","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fredborg.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fredborg.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fredborg.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fredborg.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=516"}],"version-history":[{"count":6,"href":"https:\/\/fredborg.org\/index.php?rest_route=\/wp\/v2\/posts\/516\/revisions"}],"predecessor-version":[{"id":533,"href":"https:\/\/fredborg.org\/index.php?rest_route=\/wp\/v2\/posts\/516\/revisions\/533"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fredborg.org\/index.php?rest_route=\/wp\/v2\/media\/531"}],"wp:attachment":[{"href":"https:\/\/fredborg.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=516"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fredborg.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=516"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fredborg.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=516"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}