

{"id":1962,"date":"2012-11-09T14:09:29","date_gmt":"2012-11-09T12:09:29","guid":{"rendered":"http:\/\/www.hackingsap.com\/blog\/?p=1962"},"modified":"2012-11-09T14:09:29","modified_gmt":"2012-11-09T12:09:29","slug":"book-review-100-things-you-should-know-about-reporting-with-sap-crystal-reports","status":"publish","type":"post","link":"https:\/\/www.hackingsap.com\/blog\/book-review-100-things-you-should-know-about-reporting-with-sap-crystal-reports","title":{"rendered":"Book review: 100 Things You Should Know about Reporting with SAP Crystal Reports"},"content":{"rendered":"<p><a href=\"https:\/\/www.amazon.com\/dp\/1592293905\/ref=as_li_ss_til?tag=haccom-20&amp;camp=0&amp;creative=0&amp;linkCode=as4&amp;creativeASIN=1592293905&amp;adid=02WCTZGKTV2HCD3FXHW2&amp;\" target=\"_blank\"><strong><img decoding=\"async\" class=\" wp-image-1968 alignleft\" title=\"100thingscrystal\" src=\"http:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/100thingscrystal.jpeg\" alt=\"\" width=\"160\" srcset=\"https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/100thingscrystal.jpeg 178w, https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/100thingscrystal-86x90.jpeg 86w\" sizes=\"(max-width: 178px) 100vw, 178px\" \/>100 Things You Should Know about Reporting with SAP Crystal Reports<\/strong><\/a> by Coy Yonce has been on the market for over a year, but really hasn\u2019t gotten a lot of attention yet. Maybe the reason is that <strong>Crystal Reports<\/strong> isn&#8217;t that new and interesting anymore compared to the other\u00a0SAP BusinessObjects tools and solutions like HANA. Also there are already <a href=\"http:\/\/www.amazon.com\/s\/?_encoding=UTF8&amp;camp=1789&amp;creative=390957&amp;keywords=crystal%20reports&amp;linkCode=ur2&amp;qid=1352454800&amp;rh=i%3Aaps%2Ck%3Acrystal%20reports&amp;tag=haccom-20\" target=\"_blank\">a lot of books<\/a> published on Crystal Reports in the past 10 years.\u00a0In the past months I had to create a series of Crystal Reports in a very short timespan so I decided to pick this book up for some quick tips that could save me some time.<\/p>\n<p>The approach of the &#8216;100 Things&#8217; series is very different from other SAP books. It won&#8217;t teach you the very basics of report creation and it won&#8217;t discuss every menu option available. Instead it covers 100 very practical tasks you might want to achieve in Crystal Reports and it shows you the steps to get them done. I like this approach, which falls within the same\u00a0philosophy we used in our\u00a0<a title=\"SAP BusinessObjects Dashboards 4.0 cookbook\" href=\"http:\/\/www.hackingsap.com\/blog\/sap-businessobjects-dashboards-4-0-cookbook\">SAP BusinessObjects Dashboards 4.0 cookbook<\/a>. This means that some level of experience in using Crystal Reports is required.<\/p>\n<p>I&#8217;ve been working with the &#8216;newer&#8217;\u00a0SAP Crystal Reports for Enterprise 4.0 which is mainly aimed at report creation on top of SAP BW. This book is written for <strong>SAP Crystal Reports 2011<\/strong> but I guess that over 90% of the material is usable in the Enterprise version without a problem.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1967\" title=\"100thingscrystal2\" src=\"http:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/100thingscrystal2.jpeg\" alt=\"\" width=\"306\" height=\"306\" srcset=\"https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/100thingscrystal2.jpeg 306w, https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/100thingscrystal2-90x90.jpeg 90w, https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/100thingscrystal2-300x300.jpeg 300w, https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/100thingscrystal2-100x100.jpeg 100w, https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/100thingscrystal2-150x150.jpeg 150w\" sizes=\"auto, (max-width: 306px) 100vw, 306px\" \/><\/p>\n<p>Each tip starts with a short introduction or case to explain the purpose and goal of the tip. Next you are taken through the steps and code. I think that about 70% of the tips use some kind of code, but in most cases these are single line statements that are not that complex, so don&#8217;t worry. A tip covers 2 to 4 pages.<\/p>\n<p>Some of the tips that I found interesting are:<\/p>\n<ul>\n<li>Suppressing duplicate rows<\/li>\n<li>Designing a cover page<\/li>\n<li>Creating a formula to calculate an average\/minimum while ignoring zero values<\/li>\n<li>Showing visual indicators<\/li>\n<li>Creating tool tips<\/li>\n<li>Formatting dates in a chart<\/li>\n<li>Creating effective report templates<\/li>\n<\/ul>\n<p>Also there are a bunch of tips that go beyond the standard Crystal Reports functionality and show some nice third-party solutions you can use in Crystal Reports, for example to create barcodes and QR-codes in your report. \u00a0The final 5 tips talk about monitoring and improving report performance.<\/p>\n<p>So if you find yourself Googling a lot to make your Crystal Reports better you should really check out the <a href=\"https:\/\/www.amazon.com\/dp\/1592293905\/ref=as_li_ss_til?tag=haccom-20&amp;camp=0&amp;creative=0&amp;linkCode=as4&amp;creativeASIN=1592293905&amp;adid=17DGFZSHGVBCCFK8MS7D&amp;\" target=\"_blank\">table of contents of this book<\/a>. If there is one tip in it you can use immediately I think this book is already worth the money.<\/p>\n<p><a href=\"https:\/\/www.amazon.com\/dp\/1592293905\/ref=as_li_ss_til?tag=haccom-20&amp;camp=0&amp;creative=0&amp;linkCode=as4&amp;creativeASIN=1592293905&amp;adid=02WCTZGKTV2HCD3FXHW2&amp;\" target=\"_blank\">100 Things You Should Know about Reporting with SAP Crystal Reports<\/a> by Coy Yonce, ISBN\u00a0978-1592293902.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>100 Things You Should Know about Reporting with SAP Crystal Reports by Coy Yonce has been on the market for over a year, but really hasn\u2019t gotten a lot of attention yet. Maybe the reason is that Crystal Reports isn&#8217;t that new and interesting anymore compared to the other SAP BusinessObjects tools and solutions like HANA. Also there are already a lot of books published on Crystal Reports in the past 10 years.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[34,183,9],"tags":[27,184],"class_list":["post-1962","post","type-post","status-publish","format-standard","hentry","category-books","category-review","category-sapbusinessobjects","tag-crystal-reports","tag-sap-crystal-reports-for-enterprise"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pKaa2-vE","jetpack-related-posts":[{"id":488,"url":"https:\/\/www.hackingsap.com\/blog\/bye-xcelsius-hello-sap-crystal-solutions","url_meta":{"origin":1962,"position":0},"title":"Bye bye Xcelsius, Hello SAP Crystal Solutions?","author":"Xavier Hacking","date":"May 24, 2010","format":false,"excerpt":"Why didn't they just name it SAP Crystal Xcelsius?","rel":"","context":"In &quot;SAP&quot;","block_context":{"text":"SAP","link":"https:\/\/www.hackingsap.com\/blog\/category\/sap"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1658,"url":"https:\/\/www.hackingsap.com\/blog\/book-review-reporting-and-analysis-with-sap-businessobjects-ingo-hilgefort","url_meta":{"origin":1962,"position":1},"title":"Book review: Reporting and Analysis with SAP BusinessObjects","author":"Xavier Hacking","date":"March 5, 2012","format":false,"excerpt":"For the past months I've been busy reading (and listening) a bunch of interesting tech books so it's time for another review. It looks like SAP Press is updating its book portfolio this year, since after the Integrating SAP BusinessObjects BI Platform 4.x with SAP Netweaver book I posted about\u2026","rel":"","context":"In &quot;Books&quot;","block_context":{"text":"Books","link":"https:\/\/www.hackingsap.com\/blog\/category\/books"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/reportinganalysisbook.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":2092,"url":"https:\/\/www.hackingsap.com\/blog\/errors-after-promoting-bi4-reports-with-bex-query-data-sources-crystal-reports-web-intelligence","url_meta":{"origin":1962,"position":2},"title":"Errors after promoting BI4 reports with BEx query data sources","author":"Xavier Hacking","date":"January 28, 2013","format":false,"excerpt":"Transporting (or promoting) objects in the SAP BusinessObjects BI4 environment is still a bit weird for those (like me) originally coming from the SAP BW world. The Lifecycle Manager (LCM) webapp somehow doesn\u2019t feel as robust as the Transport Management System in SAP, but in the end of it course\u2026","rel":"","context":"In &quot;Knowledge sharing&quot;","block_context":{"text":"Knowledge sharing","link":"https:\/\/www.hackingsap.com\/blog\/category\/knowledge-sharing"},"img":{"alt_text":"webi_change_datasource_1","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/webi_change_datasource_1.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1127,"url":"https:\/\/www.hackingsap.com\/blog\/bi4-product-names-xcelsius-dashboards","url_meta":{"origin":1962,"position":3},"title":"BI4 product names for Xcelsius","author":"Xavier Hacking","date":"March 21, 2011","format":false,"excerpt":"Overview of the new BI4 product naming for SAP BusinessObjects Dashboards (fka Xcelsius).","rel":"","context":"In &quot;SAP BusinessObjects Dashboards&quot;","block_context":{"text":"SAP BusinessObjects Dashboards","link":"https:\/\/www.hackingsap.com\/blog\/category\/sapbusinessobjects-dashboards"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":302,"url":"https:\/\/www.hackingsap.com\/blog\/sap-teched-video-ingo-hilgefort-interview","url_meta":{"origin":1962,"position":4},"title":"SAP TechEd video: Ingo Hilgefort interview","author":"Xavier Hacking","date":"December 17, 2009","format":false,"excerpt":"In this short TechEd '09 video Ingo Hilgefort is being interviewed on integrating BusinessObjects with the SAP world, covering the SAP BusinessObjects\/SDN community and his book on this subject.","rel":"","context":"In &quot;SAP BusinessObjects&quot;","block_context":{"text":"SAP BusinessObjects","link":"https:\/\/www.hackingsap.com\/blog\/category\/sapbusinessobjects"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/sap-business_objects-use1.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":183,"url":"https:\/\/www.hackingsap.com\/blog\/sap-constellation12sprints-and-kona","url_meta":{"origin":1962,"position":5},"title":"SAP Constellation\/12Sprints and Kona","author":"Xavier Hacking","date":"December 3, 2009","format":false,"excerpt":"The ultimate Decision Support platform?","rel":"","context":"In &quot;Preview&quot;","block_context":{"text":"Preview","link":"https:\/\/www.hackingsap.com\/blog\/category\/preview"},"img":{"alt_text":"12sprints","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/12sprints.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/12sprints.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/12sprints.png?resize=525%2C300 1.5x"},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/1962","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/comments?post=1962"}],"version-history":[{"count":10,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/1962\/revisions"}],"predecessor-version":[{"id":1974,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/1962\/revisions\/1974"}],"wp:attachment":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/media?parent=1962"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/categories?post=1962"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/tags?post=1962"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}