Below is an old tip from one of the GP Reports Viewer monthly newsletters. In the past few months I have had to look this up several times, because I just cannot seem to remember the syntax, so I thought I would put it on my blog, where it will be easier for to find […]
Continue readingRenaming tables in Crystal Reports
From the May 2010 GP Reports Viewer newsletter comes a tip for renaming the tables (or views or stored procedures) on Crystal Reports. Some may ask why this in needed – I actually use this quite a bit in the following scenario. I often find that I am using one report as a template for another […]
Continue readingCrystal Reports is not going anywhere
Are you using Crystal Reports with Dynamics GP? Are you starting to hear rumors that Crystal Reports is not supported with GP anymore? Don’t worry, Crystal Reports is not going anywhere. For more on this, take a look at my latest article for MSDynamicsWorld.com, The Good News for Users of Crystal Reports with Microsoft Dynamics GP.
Continue readingCheckboxes in Crystal Reports
This Crystal Reports tip comes from the January edition of our GP Reports Viewer Newsletter. There are often times when a report is printed so that someone can go down the list and verify items or see where information may be missing. While it was a little more timely in January, at the time of the newsletter, confirming […]
Continue readingSelective highlighting in Crystal Reports
The Crystal Reports tip from Flexible Solutions GP Reports November newsletter shows how to selectively highlight values in a list without having to write a formula. Let’s say you have a customer list with balances: Now what if you wanted to make all customers with balances of $50,000 or higher more visible? Here are the steps to […]
Continue readingRunning Totals in Crystal Reports
Here is a tip from the Flexible Solutions GP Reports October newsletter on how to create a running total in Crystal Reports. Running totals are a great way to show totals that have a different calculation than a subtotal without having to write additional formulas. Let’s look at an example: You have a list of unapplied […]
Continue readingHow to get next Monday’s date in Crystal Reports
From the Flexible Solutions’ GP Reports July 2009 Newsletter, here is a great new tip: how to calculate next Monday’s date in Crystal Reports. This comes up periodically when someone wants to have weekly columns on a report showing totals of something like sales, expenses or invoices due. So if you have a report parameter called […]
Continue readingSuppressing blank lines in Crystal Reports
Here is a Crystal Reports tip from the GP Reports Viewer newsletters that can help when you are working with addresses that are stored in multiple fields. Dynamics GP (and probably many other systems) stores address components in separate fields, so if we look at a customer address window there are many individual fields that make […]
Continue readingDynamically change decimal places in Crystal Reports
The May 2009 Flexible Solutions GP Reports Newsletter brings us a tip for dynamically changing decimal places in Crystal Reports. This can be really useful for creating Sales Order Processing (SOP) reports for Dynamics GP, where GP stores the number of decimal places for each line item in the SOP10200 and SOP30300 tables. Here are the […]
Continue reading
Crystal Reports service packs and versions
Here is a handy list for determining what version and service pack of Crystal Reports you are running: CR 2013 2011 2008 XI R2 XI R1 RTM 14.0.0.760 12.0.0.549 11.5.0.313 11.0.0.895 SP 0 12.0.0.683 SP 1 14.1.1.1036 14.0.1.287 12.1.0.892 11.5.3.417 11.0.0.1282 SP 2 14.1.2.1121 14.0.2.364 12.2.0.290 11.5.8.826 link SP 3 14.1.3.1257 14.0.3.613 12.3.0.601 11.5.9.1076 11.0.0.2269 […]
Continue readingAdding watermarks to Crystal Reports
Here is the latest tip from the Flexible Solutions GP Reports Newsletter: how to add a watermark to your Crystal Reports. I am going to demonstrate with an example. I have created a statement report, but it’s a little bland, especially when there are only a few lines of data to show: First step is to […]
Continue readingAlternating shading for lines in Crystal Reports
Here is a new Crystal Reports tip from the GP Reports Viewer newsletter collection. I have added an example with some screenshots to better illustrate. Want to spruce up your Crystal report a little by adding alternate color shading to the lines? Here is how. (Click on the screenshots to see them clearer.) As an example, let’s start with […]
Continue readingSQL view to show security roles and tasks in Dynamics GP
Dynamics GP 10.0 has brought about a drastic change in GP security. Not only is the security pessimistic now, so by default no permissions are granted, but setting up and administering security is quite different from what many of us are used to after working with previous versions of GP for many years. And, of course, reporting on […]
Continue readingHow to get a definition of your Crystal Report
Here is the latest Crystal Reports tip from the Flexible Solutions GP Reports Newsletter: Ever try to delete a parameter from a Crystal Report and get a pop-up message saying the field is in use on the report and then discover that you can’t find where it is actually used? Or need to be able […]
Continue readingHow to get rid of the blank page at the end of a Crystal report
Here is a tip from the Flexible Solutions GP Reports newsletter: Often when creating a Crystal report for something that needs a new page for each group (like Invoices or Purchase Orders) we use the New Page After option for the Group Footer in Crystal’s Section Expert. This works great, however it prints a blank […]
Continue readingCrystal Reports book recommendation
Recently I picked up an excellent book on Crystal Reports. I was looking for answers to some of my more difficult questions, primarily in the area of special formatting and cross tab reports. This book has helped answer my questions and then some. Since I get asked for recommendations on Crystal Reports books all the time, I thought I […]
Continue reading
Recent Blog Comments