{"id":2486,"date":"2022-11-01T13:30:59","date_gmt":"2022-11-01T08:30:59","guid":{"rendered":"https:\/\/www.yourrightdecision.com\/blog\/?p=2486"},"modified":"2022-11-01T13:31:00","modified_gmt":"2022-11-01T08:31:00","slug":"learn-crystal-reports","status":"publish","type":"post","link":"https:\/\/www.yourrightdecision.com\/blog\/learn-crystal-reports\/","title":{"rendered":"Learn Crystal Reports"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n

SAP Crystal Reports is a business intelligence application that allows you to create, design, and deliver formatted and dynamic business reports and invoices to simplify and accelerate decision-making. SAP Crystal Reports can help you analyze your data by creating richly formatted, pixel-perfect, and multipage reports from virtually any data source, delivered in over a dozen formats.<\/p>\n\n\n\n

SAP acquired BusinessObjects on October 8, 2007, and released Crystal Reports 2011 on May 03, 2011. The latest version released is Crystal Reports 2020 on June 13, 2020. The file extension for Crystal Reports’ proprietary file format is .rpt. The design file can be saved without data, or with data for later viewing or sharing. Introduced with the release of Crystal Reports 2011, the read-only .rptr file extension option allows for viewing, but cannot be modified once exported. Microsoft Visual Studio versions 2003 through 2008 bundled an OEM version of Crystal Reports as a general purpose reporting tool. Microsoft discontinued this practice and later released their own competing reporting tool, SQL Server Reporting Services (SSRS).<\/p>\n\n\n\n

In this blog post, I will share some examples that will prove to be a handy reference for you in developing complex crystal reports. I have taken most examples from a famous book ‘Crystal Reports 2008: The Complete Reference’ written by George Peck. In this book, examples are based on a sample database Xtreme. This database is available to you when you install crystal reports on your computer. Keep visiting this page for the addition of examples!<\/p>\n\n\n\n

Useful Resources<\/h1>\n\n\n\n

Official website
https:\/\/www.sap.com\/products\/technology-platform\/crystal-reports.html<\/a><\/p>\n\n\n\n

Crystal Reports Consulting and Training
https:\/\/kenhamady.com\/default.html<\/a><\/p>\n\n\n\n

Crystal Reports 2008: The Complete Reference
https:\/\/www.amazon.com\/Crystal-Reports-2008-Complete-Reference\/dp\/0071590986<\/a><\/p>\n\n\n\n

SAP Crystal Frequently Asked Questions (FAQ)
https:\/\/community.sap.com\/topics\/crystal-reports\/faq<\/a><\/p>\n\n\n\n

Full Online Documentation for SAP Crystal Reports
https:\/\/help.sap.com\/docs\/SAP_CRYSTAL_REPORTS<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

SAP Crystal Reports is a business intelligence application that allows you to create, design, and deliver formatted and dynamic business…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37,9],"tags":[44,42,40,45,43,35],"class_list":["post-2486","post","type-post","status-publish","format-standard","hentry","category-programming","category-tech","tag-businessobjects","tag-crystalreports","tag-programming","tag-reportingtool","tag-sap","tag-technology"],"yoast_head":"\nLearn Crystal Reports - Your Right Decision Blog<\/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.yourrightdecision.com\/blog\/learn-crystal-reports\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Learn Crystal Reports - Your Right Decision Blog\" \/>\n<meta property=\"og:description\" content=\"SAP Crystal Reports is a business intelligence application that allows you to create, design, and deliver formatted and dynamic business…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.yourrightdecision.com\/blog\/learn-crystal-reports\/\" \/>\n<meta property=\"og:site_name\" content=\"Your Right Decision Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/yourrightdecision\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-01T08:30:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-01T08:31:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.yourrightdecision.com\/blog\/wp-content\/uploads\/2022\/11\/103.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\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:\/\/www.yourrightdecision.com\/blog\/learn-crystal-reports\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/learn-crystal-reports\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/#\/schema\/person\/1619bc20b251247bf3089fa41c507641\"},\"headline\":\"Learn Crystal Reports\",\"datePublished\":\"2022-11-01T08:30:59+00:00\",\"dateModified\":\"2022-11-01T08:31:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/learn-crystal-reports\/\"},\"wordCount\":301,\"commentCount\":37,\"publisher\":{\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/learn-crystal-reports\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.yourrightdecision.com\/blog\/wp-content\/uploads\/2022\/11\/103.png\",\"keywords\":[\"businessobjects\",\"crystalreports\",\"programming\",\"reportingtool\",\"sap\",\"technology\"],\"articleSection\":[\"Programming\",\"Technology\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.yourrightdecision.com\/blog\/learn-crystal-reports\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/learn-crystal-reports\/\",\"url\":\"https:\/\/www.yourrightdecision.com\/blog\/learn-crystal-reports\/\",\"name\":\"Learn Crystal Reports - Your Right Decision Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/learn-crystal-reports\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/learn-crystal-reports\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.yourrightdecision.com\/blog\/wp-content\/uploads\/2022\/11\/103.png\",\"datePublished\":\"2022-11-01T08:30:59+00:00\",\"dateModified\":\"2022-11-01T08:31:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/learn-crystal-reports\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.yourrightdecision.com\/blog\/learn-crystal-reports\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/learn-crystal-reports\/#primaryimage\",\"url\":\"https:\/\/www.yourrightdecision.com\/blog\/wp-content\/uploads\/2022\/11\/103.png\",\"contentUrl\":\"https:\/\/www.yourrightdecision.com\/blog\/wp-content\/uploads\/2022\/11\/103.png\",\"width\":844,\"height\":546},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/learn-crystal-reports\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.yourrightdecision.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Learn Crystal Reports\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/#website\",\"url\":\"https:\/\/www.yourrightdecision.com\/blog\/\",\"name\":\"Your Right Decision Blog\",\"description\":\"Your Right Decision on the Web\",\"publisher\":{\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.yourrightdecision.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/#organization\",\"name\":\"Your Right Decision\",\"url\":\"https:\/\/www.yourrightdecision.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.yourrightdecision.com\/blog\/wp-content\/uploads\/2020\/11\/156.jpg\",\"contentUrl\":\"https:\/\/www.yourrightdecision.com\/blog\/wp-content\/uploads\/2020\/11\/156.jpg\",\"width\":364,\"height\":364,\"caption\":\"Your Right Decision\"},\"image\":{\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/yourrightdecision\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/#\/schema\/person\/1619bc20b251247bf3089fa41c507641\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4ae389a5bfe7418706d8fd3157e4bd2b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4ae389a5bfe7418706d8fd3157e4bd2b?s=96&d=mm&r=g\",\"caption\":\"admin\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Learn Crystal Reports - Your Right Decision Blog","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.yourrightdecision.com\/blog\/learn-crystal-reports\/","og_locale":"en_US","og_type":"article","og_title":"Learn Crystal Reports - Your Right Decision Blog","og_description":"SAP Crystal Reports is a business intelligence application that allows you to create, design, and deliver formatted and dynamic business…","og_url":"https:\/\/www.yourrightdecision.com\/blog\/learn-crystal-reports\/","og_site_name":"Your Right Decision Blog","article_publisher":"https:\/\/www.facebook.com\/yourrightdecision","article_published_time":"2022-11-01T08:30:59+00:00","article_modified_time":"2022-11-01T08:31:00+00:00","og_image":[{"url":"https:\/\/www.yourrightdecision.com\/blog\/wp-content\/uploads\/2022\/11\/103.png","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.yourrightdecision.com\/blog\/learn-crystal-reports\/#article","isPartOf":{"@id":"https:\/\/www.yourrightdecision.com\/blog\/learn-crystal-reports\/"},"author":{"name":"admin","@id":"https:\/\/www.yourrightdecision.com\/blog\/#\/schema\/person\/1619bc20b251247bf3089fa41c507641"},"headline":"Learn Crystal Reports","datePublished":"2022-11-01T08:30:59+00:00","dateModified":"2022-11-01T08:31:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.yourrightdecision.com\/blog\/learn-crystal-reports\/"},"wordCount":301,"commentCount":37,"publisher":{"@id":"https:\/\/www.yourrightdecision.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.yourrightdecision.com\/blog\/learn-crystal-reports\/#primaryimage"},"thumbnailUrl":"https:\/\/www.yourrightdecision.com\/blog\/wp-content\/uploads\/2022\/11\/103.png","keywords":["businessobjects","crystalreports","programming","reportingtool","sap","technology"],"articleSection":["Programming","Technology"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.yourrightdecision.com\/blog\/learn-crystal-reports\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.yourrightdecision.com\/blog\/learn-crystal-reports\/","url":"https:\/\/www.yourrightdecision.com\/blog\/learn-crystal-reports\/","name":"Learn Crystal Reports - Your Right Decision Blog","isPartOf":{"@id":"https:\/\/www.yourrightdecision.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.yourrightdecision.com\/blog\/learn-crystal-reports\/#primaryimage"},"image":{"@id":"https:\/\/www.yourrightdecision.com\/blog\/learn-crystal-reports\/#primaryimage"},"thumbnailUrl":"https:\/\/www.yourrightdecision.com\/blog\/wp-content\/uploads\/2022\/11\/103.png","datePublished":"2022-11-01T08:30:59+00:00","dateModified":"2022-11-01T08:31:00+00:00","breadcrumb":{"@id":"https:\/\/www.yourrightdecision.com\/blog\/learn-crystal-reports\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.yourrightdecision.com\/blog\/learn-crystal-reports\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.yourrightdecision.com\/blog\/learn-crystal-reports\/#primaryimage","url":"https:\/\/www.yourrightdecision.com\/blog\/wp-content\/uploads\/2022\/11\/103.png","contentUrl":"https:\/\/www.yourrightdecision.com\/blog\/wp-content\/uploads\/2022\/11\/103.png","width":844,"height":546},{"@type":"BreadcrumbList","@id":"https:\/\/www.yourrightdecision.com\/blog\/learn-crystal-reports\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.yourrightdecision.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Learn Crystal Reports"}]},{"@type":"WebSite","@id":"https:\/\/www.yourrightdecision.com\/blog\/#website","url":"https:\/\/www.yourrightdecision.com\/blog\/","name":"Your Right Decision Blog","description":"Your Right Decision on the Web","publisher":{"@id":"https:\/\/www.yourrightdecision.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.yourrightdecision.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.yourrightdecision.com\/blog\/#organization","name":"Your Right Decision","url":"https:\/\/www.yourrightdecision.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.yourrightdecision.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.yourrightdecision.com\/blog\/wp-content\/uploads\/2020\/11\/156.jpg","contentUrl":"https:\/\/www.yourrightdecision.com\/blog\/wp-content\/uploads\/2020\/11\/156.jpg","width":364,"height":364,"caption":"Your Right Decision"},"image":{"@id":"https:\/\/www.yourrightdecision.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/yourrightdecision"]},{"@type":"Person","@id":"https:\/\/www.yourrightdecision.com\/blog\/#\/schema\/person\/1619bc20b251247bf3089fa41c507641","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.yourrightdecision.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/4ae389a5bfe7418706d8fd3157e4bd2b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4ae389a5bfe7418706d8fd3157e4bd2b?s=96&d=mm&r=g","caption":"admin"}}]}},"_links":{"self":[{"href":"https:\/\/www.yourrightdecision.com\/blog\/wp-json\/wp\/v2\/posts\/2486","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.yourrightdecision.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yourrightdecision.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yourrightdecision.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yourrightdecision.com\/blog\/wp-json\/wp\/v2\/comments?post=2486"}],"version-history":[{"count":10,"href":"https:\/\/www.yourrightdecision.com\/blog\/wp-json\/wp\/v2\/posts\/2486\/revisions"}],"predecessor-version":[{"id":2508,"href":"https:\/\/www.yourrightdecision.com\/blog\/wp-json\/wp\/v2\/posts\/2486\/revisions\/2508"}],"wp:attachment":[{"href":"https:\/\/www.yourrightdecision.com\/blog\/wp-json\/wp\/v2\/media?parent=2486"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yourrightdecision.com\/blog\/wp-json\/wp\/v2\/categories?post=2486"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yourrightdecision.com\/blog\/wp-json\/wp\/v2\/tags?post=2486"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}