{"id":2106,"date":"2021-02-01T08:19:00","date_gmt":"2021-02-01T08:19:00","guid":{"rendered":"https:\/\/cssi.com\/gp\/?p=2106"},"modified":"2021-01-27T21:29:53","modified_gmt":"2021-01-27T21:29:53","slug":"item-status-report-for-ssr","status":"publish","type":"post","link":"https:\/\/cssi.com\/gp\/2021\/02\/01\/item-status-report-for-ssr\/","title":{"rendered":"Item Status Report for SQL Server Reporting Services"},"content":{"rendered":"\n<p>In this video, we present a custom report created in SQL Server Reporting Services (SSRS), but also possible to use in Crystal Reports or Power BI.<\/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 title=\"CSSI&#039;s Item Status Report for SSRS \/ Power BI \/ Crystal Reports\" width=\"500\" height=\"281\" data-src=\"https:\/\/www.youtube.com\/embed\/87ElwcpPhPo?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" data-load-mode=\"1\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">What does this SQL Server Reporting Services Report Do?<\/h2>\n\n\n\n<p>This custom SSRS report lists items that are needed for current open sales orders in Dynamics GP. It also shows a running total of the projected available quantity for each item, based on the requested ship date or the promise date for PO&#8217;s. Finally, the report will highlight items with quantity available of 0 or less.<\/p>\n\n\n\n<p>If this SSRS report would be useful in your business, or if you would like assistance in <a href=\"https:\/\/cssi.com\/gp\/service\/dashboard-report-development\/\">report design<\/a>, creating other custom reports in SSRS, Crystal Reports, or Power BI, or custom code and applications, please <a href=\"https:\/\/cssi.com\/gp\/contact\/\">contact the report designer experts at CSSI<\/a>. CSSI can also assist you with <a href=\"https:\/\/cssi.com\/software\/custom-programming\/\">custom programming services<\/a>, developing unique high-value applications for your business.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this video, we present a custom report created in SQL Server Reporting Services (SSRS), but also possible to use in Crystal Reports or Power BI. What does this SQL Server Reporting Services Report Do? This custom SSRS report lists items that are needed for current open sales orders in.<\/p>\n","protected":false},"author":4,"featured_media":2108,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","footnotes":""},"categories":[8],"tags":[251,248,250,249,247],"class_list":["post-2106","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-crystal-reports","tag-custom-report","tag-dynamics-gp-report","tag-sql-server-reporting-services","tag-ssrs-report"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Item Status Report for SQL Server Reporting Services - CSSI<\/title>\n<meta name=\"description\" content=\"In this video, we present a custom report created in SQL Server Reporting Services (SSRS), but also usable in Crystal Reports or Power BI.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cssi.com\/gp\/2021\/02\/01\/item-status-report-for-ssr\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Item Status Report for SQL Server Reporting Services - CSSI\" \/>\n<meta property=\"og:description\" content=\"In this video, we present a custom report created in SQL Server Reporting Services (SSRS), but also usable in Crystal Reports or Power BI.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cssi.com\/gp\/2021\/02\/01\/item-status-report-for-ssr\/\" \/>\n<meta property=\"og:site_name\" content=\"Dynamics GP Support in PA - CSSI Technologies LLC\" \/>\n<meta property=\"article:published_time\" content=\"2021-02-01T08:19:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cssi.com\/gp\/wp-content\/uploads\/sites\/2\/2021\/01\/report-screen-scapture.png\" \/>\n\t<meta property=\"og:image:width\" content=\"997\" \/>\n\t<meta property=\"og:image:height\" content=\"523\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"jtosolt\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@jtosolt@cssi.com\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"jtosolt\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2021\\\/02\\\/01\\\/item-status-report-for-ssr\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2021\\\/02\\\/01\\\/item-status-report-for-ssr\\\/\"},\"author\":{\"name\":\"jtosolt\",\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/#\\\/schema\\\/person\\\/2af2cbcbd389a279188e6b4608ddb4db\"},\"headline\":\"Item Status Report for SQL Server Reporting Services\",\"datePublished\":\"2021-02-01T08:19:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2021\\\/02\\\/01\\\/item-status-report-for-ssr\\\/\"},\"wordCount\":162,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2021\\\/02\\\/01\\\/item-status-report-for-ssr\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cssi.com\\\/gp\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2021\\\/01\\\/report-screen-scapture.png\",\"keywords\":[\"crystal reports\",\"custom report\",\"dynamics gp report\",\"sql server reporting services\",\"ssrs report\"],\"articleSection\":[\"blog\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/cssi.com\\\/gp\\\/2021\\\/02\\\/01\\\/item-status-report-for-ssr\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2021\\\/02\\\/01\\\/item-status-report-for-ssr\\\/\",\"url\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2021\\\/02\\\/01\\\/item-status-report-for-ssr\\\/\",\"name\":\"Item Status Report for SQL Server Reporting Services - CSSI\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2021\\\/02\\\/01\\\/item-status-report-for-ssr\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2021\\\/02\\\/01\\\/item-status-report-for-ssr\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cssi.com\\\/gp\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2021\\\/01\\\/report-screen-scapture.png\",\"datePublished\":\"2021-02-01T08:19:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/#\\\/schema\\\/person\\\/2af2cbcbd389a279188e6b4608ddb4db\"},\"description\":\"In this video, we present a custom report created in SQL Server Reporting Services (SSRS), but also usable in Crystal Reports or Power BI.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2021\\\/02\\\/01\\\/item-status-report-for-ssr\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/cssi.com\\\/gp\\\/2021\\\/02\\\/01\\\/item-status-report-for-ssr\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2021\\\/02\\\/01\\\/item-status-report-for-ssr\\\/#primaryimage\",\"url\":\"https:\\\/\\\/cssi.com\\\/gp\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2021\\\/01\\\/report-screen-scapture.png\",\"contentUrl\":\"https:\\\/\\\/cssi.com\\\/gp\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2021\\\/01\\\/report-screen-scapture.png\",\"width\":997,\"height\":523,\"caption\":\"Item report for SQL Server Reporting Services\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2021\\\/02\\\/01\\\/item-status-report-for-ssr\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/cssi.com\\\/gp\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Item Status Report for SQL Server Reporting Services\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/#website\",\"url\":\"https:\\\/\\\/cssi.com\\\/gp\\\/\",\"name\":\"Dynamics GP Support in PA - CSSI Technologies LLC\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/cssi.com\\\/gp\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/#\\\/schema\\\/person\\\/2af2cbcbd389a279188e6b4608ddb4db\",\"name\":\"jtosolt\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6322382d65cc71df3e9c204b08e5722e704d53b70cbd527b85c7cb3a758a3d3d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6322382d65cc71df3e9c204b08e5722e704d53b70cbd527b85c7cb3a758a3d3d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6322382d65cc71df3e9c204b08e5722e704d53b70cbd527b85c7cb3a758a3d3d?s=96&d=mm&r=g\",\"caption\":\"jtosolt\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/jtosolt@cssi.com\"],\"url\":\"https:\\\/\\\/cssi.com\\\/gp\\\/author\\\/jtosolt\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Item Status Report for SQL Server Reporting Services - CSSI","description":"In this video, we present a custom report created in SQL Server Reporting Services (SSRS), but also usable in Crystal Reports or Power BI.","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:\/\/cssi.com\/gp\/2021\/02\/01\/item-status-report-for-ssr\/","og_locale":"en_US","og_type":"article","og_title":"Item Status Report for SQL Server Reporting Services - CSSI","og_description":"In this video, we present a custom report created in SQL Server Reporting Services (SSRS), but also usable in Crystal Reports or Power BI.","og_url":"https:\/\/cssi.com\/gp\/2021\/02\/01\/item-status-report-for-ssr\/","og_site_name":"Dynamics GP Support in PA - CSSI Technologies LLC","article_published_time":"2021-02-01T08:19:00+00:00","og_image":[{"width":997,"height":523,"url":"https:\/\/cssi.com\/gp\/wp-content\/uploads\/sites\/2\/2021\/01\/report-screen-scapture.png","type":"image\/png"}],"author":"jtosolt","twitter_card":"summary_large_image","twitter_creator":"@jtosolt@cssi.com","twitter_misc":{"Written by":"jtosolt","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cssi.com\/gp\/2021\/02\/01\/item-status-report-for-ssr\/#article","isPartOf":{"@id":"https:\/\/cssi.com\/gp\/2021\/02\/01\/item-status-report-for-ssr\/"},"author":{"name":"jtosolt","@id":"https:\/\/cssi.com\/gp\/#\/schema\/person\/2af2cbcbd389a279188e6b4608ddb4db"},"headline":"Item Status Report for SQL Server Reporting Services","datePublished":"2021-02-01T08:19:00+00:00","mainEntityOfPage":{"@id":"https:\/\/cssi.com\/gp\/2021\/02\/01\/item-status-report-for-ssr\/"},"wordCount":162,"commentCount":0,"image":{"@id":"https:\/\/cssi.com\/gp\/2021\/02\/01\/item-status-report-for-ssr\/#primaryimage"},"thumbnailUrl":"https:\/\/cssi.com\/gp\/wp-content\/uploads\/sites\/2\/2021\/01\/report-screen-scapture.png","keywords":["crystal reports","custom report","dynamics gp report","sql server reporting services","ssrs report"],"articleSection":["blog"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/cssi.com\/gp\/2021\/02\/01\/item-status-report-for-ssr\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/cssi.com\/gp\/2021\/02\/01\/item-status-report-for-ssr\/","url":"https:\/\/cssi.com\/gp\/2021\/02\/01\/item-status-report-for-ssr\/","name":"Item Status Report for SQL Server Reporting Services - CSSI","isPartOf":{"@id":"https:\/\/cssi.com\/gp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/cssi.com\/gp\/2021\/02\/01\/item-status-report-for-ssr\/#primaryimage"},"image":{"@id":"https:\/\/cssi.com\/gp\/2021\/02\/01\/item-status-report-for-ssr\/#primaryimage"},"thumbnailUrl":"https:\/\/cssi.com\/gp\/wp-content\/uploads\/sites\/2\/2021\/01\/report-screen-scapture.png","datePublished":"2021-02-01T08:19:00+00:00","author":{"@id":"https:\/\/cssi.com\/gp\/#\/schema\/person\/2af2cbcbd389a279188e6b4608ddb4db"},"description":"In this video, we present a custom report created in SQL Server Reporting Services (SSRS), but also usable in Crystal Reports or Power BI.","breadcrumb":{"@id":"https:\/\/cssi.com\/gp\/2021\/02\/01\/item-status-report-for-ssr\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cssi.com\/gp\/2021\/02\/01\/item-status-report-for-ssr\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cssi.com\/gp\/2021\/02\/01\/item-status-report-for-ssr\/#primaryimage","url":"https:\/\/cssi.com\/gp\/wp-content\/uploads\/sites\/2\/2021\/01\/report-screen-scapture.png","contentUrl":"https:\/\/cssi.com\/gp\/wp-content\/uploads\/sites\/2\/2021\/01\/report-screen-scapture.png","width":997,"height":523,"caption":"Item report for SQL Server Reporting Services"},{"@type":"BreadcrumbList","@id":"https:\/\/cssi.com\/gp\/2021\/02\/01\/item-status-report-for-ssr\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cssi.com\/gp\/"},{"@type":"ListItem","position":2,"name":"Item Status Report for SQL Server Reporting Services"}]},{"@type":"WebSite","@id":"https:\/\/cssi.com\/gp\/#website","url":"https:\/\/cssi.com\/gp\/","name":"Dynamics GP Support in PA - CSSI Technologies LLC","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cssi.com\/gp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/cssi.com\/gp\/#\/schema\/person\/2af2cbcbd389a279188e6b4608ddb4db","name":"jtosolt","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/6322382d65cc71df3e9c204b08e5722e704d53b70cbd527b85c7cb3a758a3d3d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/6322382d65cc71df3e9c204b08e5722e704d53b70cbd527b85c7cb3a758a3d3d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6322382d65cc71df3e9c204b08e5722e704d53b70cbd527b85c7cb3a758a3d3d?s=96&d=mm&r=g","caption":"jtosolt"},"sameAs":["https:\/\/x.com\/jtosolt@cssi.com"],"url":"https:\/\/cssi.com\/gp\/author\/jtosolt\/"}]}},"_links":{"self":[{"href":"https:\/\/cssi.com\/gp\/wp-json\/wp\/v2\/posts\/2106","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cssi.com\/gp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cssi.com\/gp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cssi.com\/gp\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/cssi.com\/gp\/wp-json\/wp\/v2\/comments?post=2106"}],"version-history":[{"count":0,"href":"https:\/\/cssi.com\/gp\/wp-json\/wp\/v2\/posts\/2106\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cssi.com\/gp\/wp-json\/wp\/v2\/media\/2108"}],"wp:attachment":[{"href":"https:\/\/cssi.com\/gp\/wp-json\/wp\/v2\/media?parent=2106"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cssi.com\/gp\/wp-json\/wp\/v2\/categories?post=2106"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cssi.com\/gp\/wp-json\/wp\/v2\/tags?post=2106"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}